transfer datatable data to labels with for while

roohollah azari

hello! how are you?

i have a problem in developing my project.

i want that in my project create label dynamically to (number of database(datatable)rows count * columns count) and fill that labels with datatable Informations but we have a many errors:The following sourcecode:

private void TxtSearch_TextChanged(object sender, EventArgs e)

{

string selectstr = "";

SqlConnection conn = new SqlConnection(adresedatabase);

switch (comboBox1.SelectedIndex)

{

case 0:

{

selectstr = "select * from TblKala where Barcode =@barcode";

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = new SqlCommand();

da.SelectCommand.Connection = conn;

da.SelectCommand.CommandText = selectstr;

da.SelectCommand.Connection = conn;

da.SelectCommand.Parameters.AddWithValue("@barcode", Convert.ToInt32(TxtSearch.Text));

conn.Open();

DataTable dt = new DataTable();

da.Fill(dt);

object result = da.SelectCommand.ExecuteScalar();

rs = Convert.ToInt32 (result);

conn.Close();

System.Windows.Forms.Label[] lb = new System.Windows.Forms.Label[Convert.ToInt32(result) * 7];

for (int i = 0; i < Convert.ToInt32(result); i++)

for (int j = 0, px = 30, py = 30; j <= 6; i++)

{

lb[Convert.ToInt32(i.ToString() + j.ToString())].Text = dt.Rows[i].ItemArray[j].ToString(); //error line//

lb[Convert.ToInt32(i.ToString() + j.ToString())].Name = "lb" + i.ToString() + j.ToString(); //error line//

this.Controls.Add(lb[Convert.ToInt32(i.ToString() + j.ToString())]); //error line//

lb[Convert.ToInt32(i.ToString() + j.ToString())].Location = new System.Drawing.Point(px, py); //error line//

px += 30;

}

break;

}

database design:

database data:

please help me. resolve that.

2 Replies

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

Upendra Pratap Shahi11y ago
https://www.datatables.net/forums/discussion/25660/loading-2500-rows-with-datatable-editor-taking-even-with-breferender
Syed Shanu11y ago
Try this

Add a panel in your windows form.Now in the panel you can add all your text box.
Lets consider your panel height =400 and penl width =400;

private void TxtSearch_TextChanged(object sender, EventArgs e)
{
loadLableDetails()
}
System.Windows.Forms.Label[] lb;

private void loadLableDetails()
{
string selectstr = "";
SqlConnection conn = new SqlConnection(adresedatabase);
switch (comboBox1.SelectedIndex)
{
case 0:
{
selectstr = "select * from TblKala where Barcode =@barcode";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = conn;
da.SelectCommand.CommandText = selectstr;
da.SelectCommand.Connection = conn;
da.SelectCommand.Parameters.AddWithValue("@barcode", Convert.ToInt32(TxtSearch.Text));
conn.Open();
DataTable dts= new DataTable();
da.Fill(dts);
object result = da.SelectCommand.ExecuteScalar();
rs = Convert.ToInt32 (result);
conn.Close();

lb = new System.Windows.Forms.Label[Convert.ToInt32(result) * 7];
int xVal = 10;
                int yVal = 20;
                int boxWidth = 280;
                int boxHeight = 54;
for (int i = 0; i < Convert.ToInt32(result); i++)
{
            lb [i] = new Button();
         lb [i].Name = dts.Rows[i]["YOURCOLUMNNAME"].ToString();
lb [i].Font = new System.Drawing.Font("Arial", 12F);

lb [i].ForeColor = System.Drawing.Color.White;

lb [i].Location = new System.Drawing.Point(xVal, yVal);

lb [i].Size = new System.Drawing.Size(boxWidth, boxHeight);


lb [i].Text = dts.Rows[i]["ColumnNAme"].ToString();

       Panel1.Controls.Add(lb[i]);

                        xVal = xVal + boxWidth + 10;
                      if (xVal + 100 >= Panel1.Width)
                        {
                            xVal = 10;
                            yVal = yVal + boxHeight+10 ;
                        }
                    }

}

break;
}
}