Add Rows To Databound DatagridView

Question

1.00/5 (1 vote)

See more:

I have datagridview which is Filled
with Database values.
I want to add rows in the DataGridView
on Add button click .

Can It is Possible.
Assist

Posted 27-Jun-12 1:14am

Karwa_Vivek

Updated 17-Jan-19 4:56am

Add a Solution

4 solutions

Solution 1

If the datagridview is not bound some datasource then you can add blank rows by

C#

datagridview1.Rows.Add()

method.
If your datagridview is bound, then adding a new item in datasource will automatically add a blank row in datagrid view.

Posted 27-Jun-12 1:28am

Kiran Susarla

Comments

Karwa_Vivek 27-Jun-12 7:33am

Can YOu please Explain a bit How Can I Do that.
How Can I Add new Item In Datasource.
I am using a Stored procedure To Fetch Data And To Fill the Datagridview.
Thanks

Kiran Susarla 27-Jun-12 7:48am

Can you please post how you have done till now.

Karwa_Vivek 27-Jun-12 8:09am

Have DOne like This
Private Sub CreateDataGridView(ByVal ChallanID As Integer)
Dim sSQL As String = ""
Dim MyRecordset5 As Data.DataTable = Nothing
MyRecordset5 = New Data.DataTable

sSQL = "SPIS_GetTransDtl " & ChallanID
MyConnection.ExecuteSQL(sSQL, MyRecordset5)
If MyRecordset5.Rows.Count > 0 Then
rowCnt = MyRecordset5.Rows.Count
'lblTotal.Text = MyRecordset5.Rows.Count.ToString & " Items"
dgv.AutoGenerateColumns = False
dgv.DataSource = MyRecordset5
dgv.Columns("SlNo").DataPropertyName = "Slno"
dgv.Columns("Item").DataPropertyName = "Name"
dgv.Columns("ItemId").DataPropertyName = "ItemID"
dgv.Columns("ItemCode").DataPropertyName = "ItemCode"
dgv.Columns("Quantity").DataPropertyName = "Qty"
dgv.Columns("Description").DataPropertyName = "Description"

End If

End Sub

Solution 2

try like this

VB

   Dim f As Integer
          f = datagridview1.Rows.Count
         ' Add Values to the new row ...
         Dim n As Integer = datagridview1.Rows.Add()
         datagridview1.Rows.Item(n).Cells(0).Value = f + 1
         datagridview1.Rows.Item(n).Cells(1).Value = txtJob.Text
         datagridview1.Rows.Item(n).Cells(2).Value = cboBatch.Text
         datagridview1.Rows.Item(n).Cells(3).Value = ""
MessageBox.Show("New record added below. Please insert details.")

Posted 27-Jun-12 1:32am

vangapally Naveen Kumar

Comments

Karwa_Vivek 27-Jun-12 7:37am

I have tried This .. But It Throws error that Adding Rows Programmaticaly is not valid in bound DatagridView.
I have Filled the Datagridview With Database Values using Stored Procedure.

Solution 4

hello,

if your want to add a Row directly from datadridviewObject:

1. take one existing ExistRow in Datagridview
2. add this ExistRow by (DataBoundItem.GetType.ToString)to your Bindingsource Object

This code add a new empty Row:

ObjectBindingSource.Add(Type.GetType(ExistRow.DataBoundItem.GetType.ToString()).GetConstructor(New System.Type() {}).Invoke(New Object() {}))

Datagridview will update automatically

enjoy!

Posted 11-Jun-15 22:01pm

phatly

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raimis9 · Accepted Answer · 2012-06-27T02:38:00

Solution 3

You can add new row to your DataTable (MyRecordset5):

VB

dim MyNewRow as DataRow
MyNewRow=MyRecordset5.NewRow
with MyNewRow
   .Item(0)="NewItem"
   .Item(1)=1234
...
end with
MyRecordset5.rows.add(MyNewRow)
MyRecordset5.acceptchanges

The datagridview will update automatically.

Posted 27-Jun-12 2:38am

Raimis9