Posted on: 7/17/2014 6:31:20 AM | Views : 390

this is my Aspx.vb
Public Sub binddata() Dim data As New SqlDataAdapter Dim ds As New DataSet Dim df As New DataTable Dim dt As New DataTable ' Dim cblbind As New CheckBoxList Dim strcon As String = ConfigurationManager.ConnectionStrings("sample").ConnectionString Dim con As New SqlConnection(strcon) Dim CmdString As String = "select Teamid,teamname from team" Dim cmd As New SqlCommand(CmdString, con) con.Open() data.SelectCommand = cmd data.Fill(dt) Dim HtmlStr As New StringBuilder 'For i As Integer = 0 To dt.Rows.Count - 1 HtmlStr.Append("<table id='table1' border='1' align='center'>") HtmlStr.Append("<tr>") HtmlStr.Append("<th>" + "TeamName" + "</th>") HtmlStr.Append("<th>" + "TeamMember" + "</th>") HtmlStr.Append("</tr>") For i As In ...

Go to the complete details ...