How to bind textboxes dynamically using C#

Aaditya Ganesan

15y21.1k.NET

Hi,

I have created a table of textboxes dynamically with a constant 8 column but the row value keeps changing with the corresponding selection from the dropdown.

I want to fill these textboxes as they are created dynamically from SQL database,
but I am not sure on how to refer them in order to bind them with the database.
I ll attach a part of the code here. plz look into it and help me.

PlaceHolder1.Controls.Clear();
Table table = new Table();

table.ID = "Table1";
PlaceHolder1.Controls.Add(table);
// Now iterate through the table and add your controls
for (int i = 0; i < rowsCount; i++)
{
TableRow row = new TableRow();
for (int j = 0; j < 8; j++)
{
TableCell cell = new TableCell();
TextBox tb = new TextBox ();
// Set a unique ID for each TextBox added
tb.ID = "TextBoxRow_" + i + "Col_" + j;
// Add the control to the TableCell
SqlConnection cnn = new SqlConnection("Data Source=MPMSQLDEV;nitial Catalog=ASN;User ID=sa;Password=marcal");
cnn.Open();
SqlCommand cmmd = new SqlCommand("SELECT polinenum,marcalitem, vendornum, itemdesc, qtyunit, noroll, totqty, unit FROM asnvendor WHERE (vendorno ='" + TextBox116.Text + "') AND (ponumber ='" + TextBox117.Text + "')", cnn);

SqlDataReader dar = cmmd.ExecuteReader();
while (dar.Read())
{
//???????????????????????????????????????????????????????????????????????

}

cnn.Close();
cell.Controls.Add(tb);
// Add the TableCell to the TableRow
row.Cells.Add(cell);
}
// Add the TableRow to the Table
table.Rows.Add(row);
}

I hope I am clear, pls let me know the possible answer, the 8 columns are bound to different fields as per the select statement and the following number of rows are bound to the same fields of the as per the columns...

Thanks in advance
Aaditya

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

knights15y ago
Truly appreciate that you are sharing the solution across
Aaditya Ganesan15y ago
hey,
Thanks for the efforts, I got the ans from rivdiv from ASP.net forums. I have attached the code for some1 in need
1. PlaceHolder1.Controls.Clear();
2. Table table = new Table();
3. table.ID = "Table1";
5. int i = 0;
7. SqlConnection cnn = new SqlConnection("Data Source=MPMSQLDEV;nitial Catalog=ASN;User ID=sa;Password=marcal"); cnn.Open();
8. // Always use parameterized queries
9. SqlCommand cmmd = new SqlCommand("SELECT polinenum,marcalitem, vendornum, itemdesc, qtyunit, noroll, totqty, unit FROM asnvendor WHERE (vendorno = @vendorno) AND (ponumber = @ponumber)", cnn);
10. // Add parameters
11. cmmd.Parameters.AddWithValue("@vendorno", TextBox116.Text);
12. cmmd.Parameters.AddWithValue("@ponumber", TextBox117.Text);
13. SqlDataReader dar = cmmd.ExecuteReader();
14. while (dar.Read())
15. {
16. TableRow row = new TableRow();
18. // Now iterate through the columns and add your controls
19. for (int j = 0; j < 8; j++)
20. {
21. TableCell cell = new TableCell();
22. TextBox tb = new TextBox();
24. // Set a unique ID for each TextBox added
25. tb.ID = "TextBoxRow_" + i + "Col_" + j;
26. // Set the Text property
27. tb.Text = dar[j].ToString();
28. // Add the control to the TableCell
29. cell.Controls.Add(tb);
30. // Add the TableCell to the TableRow
31. row.Cells.Add(cell);
32. }
34. i += 1;
36. // Add the TableRow to the Table
37. table.Rows.Add(row);
38. }
40. dar.Close();
41. cnn.Close();
43. // Add Table to PlaceHolder
44. PlaceHolder1.Controls.Add(table);
Aaditya Ganesan15y ago
Hey JP,

Thanks for the reply, First this is a Web application and does it work the same way you said for the web as well.
second can you be a little more clear on how to go about this problem.

Thank you

Adi
Jean Paul15y ago
Hello Friend,

According to my understanding I am preferring the following.

When you dynamically create the textboxes the first time, set the tag property of the text box to the field name.

So next time you can iterate through the form.Controls array and find those textboses whose tag is not null.
I hope this is a windows application: if so you can use the following query:
this.Controls.OfType().Where(t => t.Tag != null)

Once you find the textbox, you can use the tag property - convert to string and set the value based on your row.

Regards,
JP