Database

select e.*
  from employee e
 where e.department = 'Sales'
   and exists ( select a.EmployeeId
                  from Address a
                 where e.EmployeeId = a.EmployeeId
              )
;

jaganil wrote:

my SQL Query is ---
select * from t_ItemPriceMaster Group BY c_DateForm Having ( ( max( c_DateForm )and c_SoftDelete='1')";

wrote:

where dataset tables stored ?

DataSet ds = GetDatasetFromDb();
if (ds != null && ds.Tables.Count > 0)
{
  foreach (DataRow row in ds.Tables[0])
  {
    // Do something
  }
}

SELECT MSysObjects.Name<br />
FROM MSysObjects<br />
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1));<br />

<br />
                foreach <br />
                ( <br />
                    System.Data.DataRow dr <br />
                in <br />
                    ((System.Data.OleDb.OleDbConnection) this.dbc ).GetOleDbSchemaTable<br />
                    (<br />
                        System.Data.OleDb.OleDbSchemaGuid.Tables<br />
                    ,<br />
                        new object[] { null , null , null , "TABLE" }<br />
                    ).Rows <br />
                )<br />

CREATE ASSEMBLY MyAssembly FROM 'c:\dev\MyAssembly.dll'
WITH PERMISSION_SET = SAFE