protected void Page_Load(object sender, EventArgs e) { load(); } public void load() { SqlConnection cnn = new SqlConnection("Data Source=HAMEED_KHAN\\SQLEXPRESS;Initial Catalog=db_compiler;Integrated Security=True"); string query = "SELECT Column_Name FROM tbl_field WHERE Table_Name='std'"; SqlCommand cmd = new SqlCommand(query, cnn); cnn.Open(); string somevalue = cmd.ExecuteScalar().ToString(); DataTable dt1 = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt1); cmd.ExecuteNonQuery(); int rows = dt1.Rows.Count; DataRow dr = null; foreach (DataRow row in dt1.Rows) { DataTable dt2 = new DataTable(); dt2 = new DataTable(); for (int i = 0; i < rows; i++) { dt2.Columns.Add(dt1.Rows[i][0].ToString(), System.Type.GetType("System.String")); dr = dt2.NewRow(); } Session["MyDataTable"] = dt2; DataTable dt3 = (DataTable)Session["MyDataTable"]; DataRow row1 = dt3.NewRow(); dt3.Rows.Add(row1); Session["MyDataTable"] = dt3; GridView1.DataSource = dt3; GridView1.DataBind(); cnn.Close(); } } }
<body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" > <Columns> <asp:CommandField ShowEditButton="True" /> <asp:CommandField ShowDeleteButton="True" /> <asp:ButtonField CommandName="Cancel" HeaderText="Operation" ShowHeader="True" Text="Insert" /> </Columns> </asp:GridView> </div> </form> </body>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)