How to Fetch Data From Database to display into dynamically created Textbox on button click?

Question

I have made a form in which I have two fields, Name and Products. Beside Products I have taken a Textbox and a button. I am allowing my user to add more than one textbox and the limit is upto 5 textbox's. Now I am inserting data from this form into my SQL Database. And Now I want to fetch the data from table and display into the respective Textbox's. I want that on clicking Show All Button all the dynamic Textbox should appear on the form. And if the data is present in the DB for that particular field then it should display as text in these dynamic textbox.

I have tried doing this-

<div>
    <table border="1" width="1000px">
    <tr><td colspan="2" align="center"><b>Inserting Data Into Table</b></td></tr>
    <tr>
    <td class="style1">Name: </td>
    <td class="style2">
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
    </tr>
    <tr>
    <td class="style1">Add Text Box: </td>
    <td class="style2">
        <asp:TextBox ID="txt1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Add More" 
            onclick="Button1_Click" /><br />
        <asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>      
        </td>
    </tr>
    <tr><td colspan="2" align="center">
        <asp:Button ID="Button2" runat="server" Text="Submit" onclick="Button2_Click" />
        <br />
        </td></tr>
    </table>
    </div><br /><br />
    <div>
    <table border="1" width="1000px">
    <tr><td colspan="2" align="center"><b>Fetching Data And Showing into Textbox</b></td></tr>
    <tr>
    <td class="style1">Name: </td>
    <td class="style2">
        <asp:TextBox ID="txtname" runat="server"></asp:TextBox></td>
    </tr>
    <tr>
    <td class="style1">Add Text Box: </td>
    <td class="style2">
        <asp:TextBox ID="txtt1" runat="server"></asp:TextBox>
        <asp:Button ID="Button3" runat="server" Text="Show All" 
            onclick="Button3_Click" /><br />
        <asp:PlaceHolder ID="PlaceHolder2" runat="server"></asp:PlaceHolder>      
        </td>
    </tr>
    <tr><td colspan="2" align="center">
        <asp:Button ID="Updt" runat="server" Text="Update" onclick="Updt_Click" />
        <br />
        </td></tr>
    </table>
    </div>

CS Page:-

General_Logic g1 = new General_Logic();
DataTable dt = new DataTable();
int rows = 0;
List<string> ControlIdList = new List<string>();
int Counter = 1;
TextBox tb = new TextBox();
protected override void LoadViewState(object SavedState)
{
    base.LoadViewState(SavedState);
    ControlIdList = (List<string>)ViewState["ControlIdList"];
    foreach (string Id in ControlIdList)
    {
        Counter++;
        TextBox tb = new TextBox();
        tb.ID = Id;
        LiteralControl linebreak = new LiteralControl();
        PlaceHolder1.Controls.Add(tb);
        PlaceHolder1.Controls.Add(linebreak);
    }
}
protected void Page_Load(object sender, EventArgs e)
{
    show();
}
public void show()
{
    dt = g1.return_dt("select product1,product2,product3,product4,product5,name from tbl_products where name='Yo Yo'");
    if (dt.Rows.Count > 0)
    {
        txtname.Text = dt.Rows[0]["name"].ToString();
        txtt1.Text = dt.Rows[0]["product1"].ToString();
        //TextBox txtb;
        int x = 2;
        foreach (Control ctrl in PlaceHolder2.Controls)
        {
            if (ctrl is TextBox)
            {
                if (x <= 5)
                {
                    if (Counter <= 4)
                    {
                        Counter++;
                        tb.ID = "TextBox" + Counter;
                        //tb.Text = tb.ID;
                        tb = (TextBox)ctrl;
                        LiteralControl linebreak = new LiteralControl("<br />");
                        tb.Text = dt.Rows[0]["product'" + x + "'"].ToString();
                        PlaceHolder2.Controls.Add(tb);
                        PlaceHolder2.Controls.Add(linebreak);
                        ControlIdList.Add(tb.ID);
                        ViewState["ControlIdList"] = ControlIdList;
                        x++;
                    }
                    //txtb = (TextBox)ctrl;
                    //LiteralControl linebreak = new LiteralControl("<br />");
                    //txtb.Text = dt.Rows[0]["product'" + x + "'"].ToString();
                    //PlaceHolder2.Controls.Add(txtb);
                    //PlaceHolder2.Controls.Add(linebreak);
                    //x++;
                }
            }

        }
    }
}
protected void Button1_Click(object sender, EventArgs e)
{
    if (Counter <= 4)
    {
        Counter++;
        tb.ID = "TextBox" + Counter;
        tb.Text = tb.ID;
        LiteralControl linebreak = new LiteralControl("<br />");
        PlaceHolder1.Controls.Add(tb);
        PlaceHolder1.Controls.Add(linebreak);
        ControlIdList.Add(tb.ID);
        ViewState["ControlIdList"] = ControlIdList;
    }
    else
    {
        Button1.OnClientClick = null;
        Response.Write("<script>alert('Maximum Entry is 5');</script>");
    }
}
protected void Button2_Click(object sender, EventArgs e)
{
        int limit = 4;
        string[] DBVALUES = new string[5];
        for (int parcount = 0; parcount<=limit; parcount++)
        {
            if (parcount == 0)
            {
                DBVALUES[parcount] = txt1.Text;
            }
            else
            {
                DBVALUES[parcount] = Request.Form["TextBox" + (parcount + 1).ToString()];
            }
        }
        for (int i = 0; i <= 4; i++)
        {
            if (DBVALUES[i] == null)
            {
                DBVALUES[i] = "NULL";
            }
        }
        rows = g1.ExecDB("insert into tbl_products(product1,product2,product3,product4,product5,name) values('" + DBVALUES[0].ToString() + "','" + DBVALUES[1].ToString() + "','" + DBVALUES[2].ToString() + "','" + DBVALUES[3].ToString() + "','" + DBVALUES[4].ToString() + "','"+TextBox1.Text.ToString()+"')");
        TextBox1.Text = string.Empty;
        txt1.Text = string.Empty;
        TextBox txtb;
        foreach (Control ctrl in PlaceHolder1.Controls)
        {
            if (ctrl is TextBox)
            {
                txtb = (TextBox)ctrl;
                txtb.Text = string.Empty;
            }
        }
    Response.Write("<script>alert('Data Inserted!!!');</script>");
}
protected void Updt_Click(object sender, System.EventArgs e)
{

}
protected void Button3_Click(object sender, System.EventArgs e)
{
    show();
}

Please guide me where I am doing wrong. I am waiting for your all suggestions.

As per your code where you are facing the issue are u able to find the dynamically created textboxes? — Developer
– Developer, Commented Feb 28, 2014 at 7:33
@Dotnet Actually in second div I am not able to get the dynamically created textboxes on clicking Show All Button. Here I want that on clicking show all the dynamically created Textboxes should appear with the values from database. And in First Div I am able to create Textbox on clicking Add More button. And also I am able to insert values into DB into respective attributes of my table. — Omi
– Omi, Commented Feb 28, 2014 at 7:38
Omi as per your code I have seen that you are not adding the controls to the second place holder, just debug and check whether your Show method is entering in to this condition on button click foreach (Control ctrl in PlaceHolder2.Controls){ — Developer
– Developer, Commented Feb 28, 2014 at 7:44
Also I think instead of counter while you are retrieving and creating the controls from database I will suggest you can give the primary key value so that it will be unique id for each control — Developer
– Developer, Commented Feb 28, 2014 at 7:58
@Dotnet Sir, I am not able to do what you suggested. Please can you provide me with a solution. Or some example of this kind. — Omi
– Omi, Commented Feb 28, 2014 at 9:07

Developer · Accepted Answer · 2014-02-28 13:14:41Z

1

I think you need to modify your show method like this to have the controls inside placeholder, if your datatable is returning multiple rows you need to loop through all the rows to get the data of individual

public void show()
{
 dt = g1.return_dt("select product1,product2,product3,product4,product5,name from tbl_products where name='Yo Yo'");
if (dt.Rows.Count > 0)
{
    txtname.Text = dt.Rows[0]["name"].ToString();
    txtt1.Text = dt.Rows[0]["product1"].ToString();
    //TextBox txtb;
    int x = 2;
            if (x <= 5)
            {
                if (Counter <= 4)
                {
                    TextBox tb = new TextBox();
                    Counter++;
                    tb.ID = "TextBox" + Counter;
                    //tb.Text = tb.ID;
                    LiteralControl linebreak = new LiteralControl("<br />");
                    tb.Text = dt.Rows[0]["product'" + x + "'"].ToString();
                    PlaceHolder2.Controls.Add(tb);
                    PlaceHolder2.Controls.Add(linebreak);
                    ControlIdList.Add(tb.ID);
                    ViewState["ControlIdList"] = ControlIdList;
                    x++;
                }
                //txtb = (TextBox)ctrl;
                //LiteralControl linebreak = new LiteralControl("<br />");
                //txtb.Text = dt.Rows[0]["product'" + x + "'"].ToString();
                //PlaceHolder2.Controls.Add(txtb);
                //PlaceHolder2.Controls.Add(linebreak);
                //x++;
            }
        }

    }

If it was fixed that the controls should not be more that 4 try this code, while your clicking on showall replace with DataTable row as per your requirement

protected void Button3_Click(object sender, EventArgs e)
    {
        createControls();
    }

private void createControls()
    {
        PlaceHolder2.Controls.Clear();
        for (int i = 0; i < 4; i++)
        {
            TextBox tb = new TextBox();
            tb.ID = "TextBox" + i;
            tb.Text = tb.ID;
            LiteralControl linebreak = new LiteralControl("<br />");
            PlaceHolder2.Controls.Add(tb);
            PlaceHolder2.Controls.Add(linebreak);
        }
    }

I have created a datatable as per your requirement check this

private void createControls()
    {
        PlaceHolder2.Controls.Clear();
        DataTable dt = Session["Table"] as DataTable;
        for (int i = 1; i < 5; i++)
        {
            int cnt = 0;
            cnt = i;
            TextBox tb = new TextBox();
            cnt = cnt + 1;
            tb.ID = "TextBox" + i;
            tb.Text = dt.Rows[0]["Product" + cnt + ""].ToString();
            LiteralControl linebreak = new LiteralControl("<br />");
            PlaceHolder2.Controls.Add(tb);
            PlaceHolder2.Controls.Add(linebreak);
        }
    }

    private void assignValues()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("Product2", typeof(string));
        dt.Columns.Add("Product3", typeof(string));
        dt.Columns.Add("Product4", typeof(string));
        dt.Columns.Add("Product5", typeof(string));

        DataRow lrow = dt.NewRow();
        lrow["Product2"] = "ABC";
        lrow["Product3"] = "DEF";
        lrow["Product4"] = "GHI";
        lrow["Product5"] = "JKL";
        dt.Rows.Add(lrow);
        Session["Table"] = dt;
    }

 protected void Button3_Click(object sender, EventArgs e)
    {
        assignValues();
        createControls();
    }

Here is the o/p as per my datatable on clicking showall

PageLoad

ShowAll

edited Feb 28, 2014 at 13:14

answered Feb 28, 2014 at 10:29

Developer

8,69743 gold badges137 silver badges254 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Omi Over a year ago

I have replaced my code and now I am getting this exception System.ArgumentException: Column 'product '2'' does not belong to table I am getting error in this line- tb.Text = dt.Rows[0]["product '" + x + "'"].ToString(); What is wrong in it sir?

Developer Over a year ago

tb.Text = dt.Rows[0]["product '" + x + "'"].ToString(); what is x Here

Omi Over a year ago

Actually I have attributes in my table like this- product1,product2,. . etc That is why I am concatenating the value of x with the attribute name within if statement.

Developer Over a year ago

How many products will be there like that 4 or more, and will that Product1,Product2,Product3,Product4 will be in datatable rows

Developer Over a year ago

Also can you post the sample data what ur datatable consists

|

Collectives™ on Stack Overflow

How to Fetch Data From Database to display into dynamically created Textbox on button click?

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related