As I am fetching data from database Same size of table will be append Is there possible to add asp textbox for each row DataSet ds new DataSet DataTable dt new DataTable Listltadmingt details new Listltadmingt SqlConnection conn new SqlConnection34Integrated SecuritySSPIPersist Security InfoFalseInitial CatalogSUJAYData SourceSUPREME6PC34 connOpen SqlCommand cmd new SqlComm

Please refer below sampleI have made this sample using Northwind database of Customers tableASP Textbox consider as string so it doesnrsquot display as textbox in browserHTMLltbodygtltform id34form134 runat34server34gtltdiv id34divUsers34 runat34server34gtltdivgt ltformgtltbodygtNamespaceusing SystemConfigurationusing SystemDataSqlClientusing SystemDatausing SystemTextCprotected void PageLoadobject sender EventArgs e if thisIsPostBack string conString ConfigurationManagerConnectionStrings34constr34ConnectionString string query 34SELECT FROM CUSTOMERS34 using SqlConnection con new SqlConnectionconString using SqlCommand cmd new SqlCommandquery using SqlDataAdapter sda new SqlDataAdapter cmdConnection con sdaSelectCommand cmd

Build HTML table with TextBoxes and display on page in ASP.Net

sujayana...

SOLVED CLOSED ACTIVE ANSWERED
User: sujayanand
Posted: on Sep 23, 2014 05:14 AM
Forum: HTML and CSS
Answer: 1
Views: 3956

As I am fetching data from database. Same size of table will be append. Is there possible to add asp textbox for each row.

 DataSet ds = new DataSet();
               DataTable dt = new DataTable();
               //List<admin> details = new List<admin>();
               SqlConnection conn = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SUJAY;Data Source=SUPREME6-PC");
               conn.Open();
               SqlCommand cmd = new SqlCommand("Select *from admintab", conn);
               SqlDataAdapter adp = new SqlDataAdapter(cmd);
               adp.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("</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("</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();
        }
    }   
}

Download FREE API for Word, Excel and PDF in ASP.Net

mosin

0 11

Reply
ANSWER
User: mosin
Replied: on Sep 23, 2014 07:39 AM
Modified: on Sep 23, 2014 07:42 AM
Report

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;

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Build HTML table with TextBoxes and display on page in ASP.Net

Company

Explore

Follow us

Contact Us