<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="Id" > <Columns> <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" /> <asp:BoundField DataField="HeaderId" HeaderText="HeaderId" SortExpression="HeaderId" /> <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" /> <asp:BoundField DataField="DeviceId" HeaderText="DeviceId" SortExpression="DeviceId" /> <asp:BoundField DataField="DateStamp" HeaderText="DateStamp" SortExpression="DateStamp" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringline %>" SelectCommand="SELECT * FROM [Tables]"> <SelectParameters> <asp:SessionParameter Name="HeaderId" SessionField="id" Type="Int32" /> </SelectParameters> </asp:SqlDataSource>
public void bindgridview() { SqlCommand sqlcmd; SqlDataAdapter dap; DataTable data = new DataTable(); SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionStringline"].ConnectionString); sqlcon.Open(); sqlcmd = new SqlCommand("SELECT [Id], [HeaderId],[Description], [DeviceId], [DateStamp], FROM [Tables] WHERE ([HeaderId] = '"+Session["id"].ToString()+"')", sqlcon); dap = new SqlDataAdapter(sqlcmd); dap.Fill(data); if (data.Rows.Count > 0) { GridView1.DataSource = data; GridView1.DataBind(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)