public void BindGrid()
{
using (SqlConnection con = new SqlConnection("ConnectionString"))
{
SqlCommand cmd = new SqlCommand()
{
Connection = con,
CommandText = "StoreProcedureName/sqlquery",
CommandType = CommandType.StoredProcedure
};
cmd.Connection.Open();
SqlDataReader rdr = cmd.ExecuteReader();
DataTable _dt = new DataTable();
_dt.Load(rdr);
System.IO.StringWriter _writer = new System.IO.StringWriter();
_dt.WriteXml(_writer, XmlWriteMode.WriteSchema, false);
string _result = _writer.ToString();
_gridview.DataSource = _dt;
_gridview.DataBind();
}
}