how to increase the number of row in a vb.net form?

King Umar

how to increase the number of row of a table in a form in vb.net when the number of row are controlled by the user using a textbox? anyone have any idea...

5 Replies

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

Syed Shanu11y ago
Accepted answer
Yes you can do that.
For example create a publi datatable and in form load create columns for the table like below

DataTable dt = new DataTable();
private void Form1_Load(object sender, EventArgs e)
        {
dt.Columns.Add("No");
dt.Columns.Add("Name");
dt.Columns.Add("Phone");
}

In button Click event
   private void button1_Click(object sender, EventArgs e)
        {
int rowsCount=system.Convert.toInt32(Textbox1.Text.Trim());

dt.Clear();
            dt.Rows.Clear();
            for (int i = 1; i <= rowsCount; i++)
            {
                DataRow row = dt.NewRow();
                row["NO"] = i.ToString();
                for (int jval = 1; jval <= totalColumntoDisplay; jval++)
                {
                    row["Name"] ="";
                 row["Phone"] ="";
                }

                dt.Rows.Add(row);
            }

}

Try this hope this will help you.
+2
Manoj Bhoir11y ago
Hi,

Try this Code :

Public Class Form1

Private mDataable As DataTable

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

For mRow As Int16 = 1 To Val(Me.TextBox1.Text)

Dim mNewRow As DataRow = mDataable.NewRow

mNewRow("SerialNo") = ""

mNewRow("FirstName") = ""

mNewRow("MiddleName") = ""

mNewRow("LastName") = ""

mDataable.Rows.Add(mNewRow)

Next

Me.DataGridView1.DataSource = mDataable

End Sub

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

mDataable = New DataTable

mDataable.Columns.Add("SerialNo")

mDataable.Columns.Add("FirstName")

mDataable.Columns.Add("MiddleName")

mDataable.Columns.Add("LastName")

End Sub

End Class
Also find attahced Sample.
+1
Govinda Rajulu Yemineni11y ago
Hi,

first daclare datatable globally and define structure for that table in form load event

Dim dt As New DataTable

in form load event

dt.Columns.Add("No")
dt.Columns.Add("Name")

in button click event

Dim rowcount As Integer = Integer.Parse(txtrowcount.Text)
For i As Integer = 0 To rowcount
Dim dr As DatatRow = dt.NewRow()
     dr("No") = ""
     dr("Name") = ""
       dt.Rows.Add(dr)
Next
+1
King Umar11y ago
yes sir,something like that...do you have logic to do that ? or idea...
0
Syed Shanu11y ago
What table your are taling about do you mean you want to add empty row for datatable programaticly for example in textbox when i enter 5 and click button then need to create 5 empty row in Datatable?
0