Monday, November 16, 2009

Fill Grid !!

private void fillGrid()
{
string FileDirectory = Server.MapPath("Database/admin.mdb");
OleDbConnection ocon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileDirectory.ToString() + "");
//OleDbConnection ocon = new OleDbConnection();
try
{
ocon.Open();
string str = "select *,User_name from (Project_master inner join User_Master on Project_master.User_id=User_Master.User_id ) "+" " +
" inner join Client_master on Project_master.Client_id=Client_master.Client_id order by Project_id desc";
// String str = "select *,User_name from Project_master inner join User_Master on Project_master.User_id=User_Master.User_id order by Project_id desc";
OleDbDataAdapter osap = new OleDbDataAdapter(str, ocon);

DataSet ds = new DataSet();
osap.Fill(ds, "temp");
GridDisplayCat.DataSource = ds;
GridDisplayCat.DataBind();


}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}

}

No comments: