<asp:DataList ID="DataList1" runat="server"> <ItemTemplate> <table><tr><td><asp:Label ID="Label1" runat="server" Text='<%#Eval("Column_Name")%>'></asp:Label></td></tr> <tr><td> <asp:Label ID="Label2" runat="server" Text='<%#Eval("Column_Name")%>'></asp:Label></td></tr> </table> </ItemTemplate> </asp:DataList>
public void BindData() { try { con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from Table_Name", con); DataTable ds = new DataTable(); da.Fill(ds); DataList1.DataSource = ds; DataList1.DataBind(); } catch (Exception ex) { Label1.Text = ex.Message.ToString(); } finally { con.Close(); }}
Login to post response