Please refer below sample:
I have made this sample using Northwind database of Customers table.
ASP Textbox consider as string so it doesn’t display as textbox in browser.
HTML
<body>
<form id="form1" runat="server">
<div id="divUsers" runat="server">
</div>
</form>
</body>
Namespace
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Text;
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = "SELECT * FROM CUSTOMERS";
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand cmd = new SqlCommand(query))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
StringBuilder str = new StringBuilder();
StringBuilder str1 = new StringBuilder();
str.Append("<table>");
str.Append("<tr>");
for (int k = 0; k < dt.Columns.Count; k++)
{
str.Append("<th>");
str.Append(dt.Columns[k].ColumnName);
str.Append("</th>");
}
str.Append("<th>");
str.Append("");
str.Append("</th>");
str.Append("</tr>");
for (int i = 0; i < dt.Rows.Count; i++)
{
str.Append("<tr>");
for (int k = 0; k < dt.Columns.Count; k++)
{
str.Append("<td>");
str.Append(dt.Rows[i][k]);
str.Append("</td>");
}
str.Append("<td>");
str.Append("<input type='text' ID='txtId"+(i+1)+"' runat='server' />");
str.Append("</td>");
str.Append("</tr>");
}
str.Append("</table>");
str.Append("<table>");
str.Append("<tr>");
for (int k = 0; k < dt.Columns.Count; k++)
{
str.Append("<th>");
str.Append("Head");
str.Append("</th>");
}
str.Append("</tr>");
for (int i = 0; i < dt.Rows.Count; i++)
{
str.Append("<tr>");
for (int k = 0; k < dt.Columns.Count; k++)
{
str.Append("<td>");
str.Append("Test");
str.Append("</td>");
}
str.Append("</tr>");
}
str.Append("</table>");
divUsers.InnerHtml = str.ToString();
}
}
}
}
}
}
SQL
I have used Northwind Customers table. You can download the Database from here.
Install the Northwind and Pubs Sample Databases in SQL Server Express
Screenshot
