Display data from Database in HTML table using Stored Procedure in ASP.Net

Mr.Mudassar

I am using your code Display data from database in HTML table in ASP.Net

But It is in query string. But I need using strored Procedure due to large data. I have given code below

Pls advice me 

Maideen

        Dim constr As String = ConfigurationManager.ConnectionStrings("ConnectString").ConnectionString
        Using con As New SqlConnection(constr)
            Using cmd As New SqlCommand("usp_CL_LogType_Details")
                cmd.Parameters.AddWithValue("@Action", "INBOUND_ACTIVE_HTML_TABLE")
                cmd.Connection = con
                cmd.CommandType = CommandType.StoredProcedure
                Using sda As New SqlDataAdapter(cmd)
                    Dim dt As New DataTable()
                    sda.Fill(dt)
                    Dim html As New StringBuilder()
                    html.Append("<table border = '1'>")
                    html.Append("<tr>")
                    For Each column As DataColumn In dt.Columns
                        html.Append("<th>")
                        html.Append(column.ColumnName)
                        html.Append("</th>")
                    Next
                    html.Append("</tr>")

                    For Each row As DataRow In dt.Rows
                        html.Append("<tr>")
                        For Each column As DataColumn In dt.Columns
                            html.Append("<td>")
                            html.Append(row(column.ColumnName))
                            html.Append("</td>")
                        Next
                        html.Append("</tr>")
                    Next
                    html.Append("</table>")
                    PlaceHolder1.Controls.Add(New Literal() With {.Text = html.ToString()})

                End Using
            End Using
        End Using