Hi Sant
Try the following
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[urconnectionstring].ConnectionString.ToString());
SqlCommand sqlCom = new SqlCommand(urQuery);
sqlCom.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(sqlCom.CommandText, con);
DataSet dsEmp = new DataSet();
da.Fill(dsEmp);
if (dsEmp.Tables.Count > 0)
{
if (dsEmp.Tables[0] != null && dsEmp.Tables[0].Rows.Count>0)
{
dsEmp.Tables[0].Rows.InsertAt(dsEmp.Tables[0].NewRow(), 0);
}
}
GridView1.DataSource = dsEmp.Tables[0];
GridView1.DataBind();
Hope this helps