how to add rows in a datagrid from data base

[mails4vijayakumar]

how to add multiple rows in a datagrid from data base

[jmcilhinney]

Haven't we already covered this in a previous thread? Use a data adapter to populate a DataTable and then bind that to the grid, i.e. assign the table to the grid's DataSource. If you don't know how to populate the DataTable then follow the Database FAQ link in my signature and check out the ADO.NET resources there.

[jmcilhinney]

Yes this has been covered before.

http://www.vbforums.com/showthread.php?t=626486

Please don't keep asking basically the same question over and over in multiple threads. One thread per topic and one topic per thread.

[mails4vijayakumar]

i programatically created a datagridview rows in my form load event

now i want to add some rows in that datagrid from database.


here is my code of programatically created datagridview

Private Sub LandDetailsCreateDataGrid()

        DataGridViewLandDetails.Visible = True

        If DataGridViewLandDetails.Columns.Count = 0 Then

            Me.DataGridViewLandDetails.Columns.Add("memberid", "memberid")

            Me.DataGridViewLandDetails.Columns.Add("serialnumber", "serialnumber")

            Me.DataGridViewLandDetails.Columns.Add("customerid", "customerid")

            Me.DataGridViewLandDetails.Columns.Add("landvillagecode", "landvillagecode")

            Me.DataGridViewLandDetails.Columns.Add("surveynumber", "surveynumber")

            Me.DataGridViewLandDetails.Columns.Add("oldsurveynumber", "oldsurveynumber")

            Me.DataGridViewLandDetails.Columns.Add("pattanumber", "pattanumber")

            Me.DataGridViewLandDetails.Columns.Add("ownershiptype", "ownershiptype")

            Me.DataGridViewLandDetails.Columns.Add("areainhectare", "areainhectare")

            Me.DataGridViewLandDetails.Columns.Add("cultivationareainhectare", "cultivationareainhectare")

            Me.DataGridViewLandDetails.Columns.Add("leaseareagiveninhectare", "leaseareagiveninhectare")

            Me.DataGridViewLandDetails.Columns.Add("leaseareaintakenhectare", "leaseareaintakenhectare")

            Me.DataGridViewLandDetails.Columns.Add("areainhector1", "areainhector1")

            Me.DataGridViewLandDetails.Columns.Add("areainhector2", "areainhector2")

            Me.DataGridViewLandDetails.Columns.Add("areainhector3", "areainhector3")

            Me.DataGridViewLandDetails.Columns.Add("areainacre", "areainacre")

            Me.DataGridViewLandDetails.Columns.Add("areaincent", "areaincent")

            Me.DataGridViewLandDetails.Columns.Add("partowneredyesno", "partowneredyesno")

            Me.DataGridViewLandDetails.Columns.Add("partownedareainacre", "partownedareainacre")

            Me.DataGridViewLandDetails.Columns.Add("partownedareaincent", "partownedareaincent")

            Me.DataGridViewLandDetails.Columns.Add("landcharacteristictype", "landcharacteristictype")

            Me.DataGridViewLandDetails.Columns.Add("numberofwells", "numberofwells")

            Me.DataGridViewLandDetails.Columns.Add("numberofpumpsets", "numberofpumpsets")

            Me.DataGridViewLandDetails.Columns.Add("cultivationareainhector1", "cultivationareainhector1")

            Me.DataGridViewLandDetails.Columns.Add("cultivationareainhector2", "cultivationareainhector2")

            Me.DataGridViewLandDetails.Columns.Add("cultivationareainhector3", "cultivationareainhector3")

            Me.DataGridViewLandDetails.Columns.Add("cultivationareainacre", "cultivationareainacre")

            Me.DataGridViewLandDetails.Columns.Add("cultivationareaincent", "cultivationareaincent")

            Me.DataGridViewLandDetails.Columns.Add("cultivatedcrop", "cultivatedcrop ")

            Me.DataGridViewLandDetails.Columns.Add("leaseareagiveninhector1", "leaseareagiveninhector1")

            Me.DataGridViewLandDetails.Columns.Add("leaseareagiveninhector2", "leaseareagiveninhector2")

            Me.DataGridViewLandDetails.Columns.Add("leaseareagiveninhector3", "leaseareagiveninhector3")

            Me.DataGridViewLandDetails.Columns.Add("leaseareagiveninacre", "leaseareagiveninacre")

            Me.DataGridViewLandDetails.Columns.Add("leaseareagivenincent", "leaseareagivenincent")

            Me.DataGridViewLandDetails.Columns.Add("lesseecustomerid", "lesseecustomerid ")

            Me.DataGridViewLandDetails.Columns.Add("lesseename", "lesseename ")

            Me.DataGridViewLandDetails.Columns.Add("lesseeaddress1", "lesseeaddress1")

            Me.DataGridViewLandDetails.Columns.Add("lesseeaddress2", "lesseeaddress2")

            Me.DataGridViewLandDetails.Columns.Add("lesseecity", "lesseecity")

            Me.DataGridViewLandDetails.Columns.Add("lesseepin", "lesseepin")

            Me.DataGridViewLandDetails.Columns.Add("lesseestate", "lesseestate")

            Me.DataGridViewLandDetails.Columns.Add("leaseareatakeninhector1", "leaseareatakeninhector1")

            Me.DataGridViewLandDetails.Columns.Add("leaseareaintakenhector2", "leaseareaintakenhector2")

            Me.DataGridViewLandDetails.Columns.Add("leaseareaintakenhector3", "leaseareaintakenhector3")

            Me.DataGridViewLandDetails.Columns.Add("leaseareaintakenacre", "leaseareaintakenacre ")

            Me.DataGridViewLandDetails.Columns.Add("leaseareaintakencent", "leaseareaintakencent")

            Me.DataGridViewLandDetails.Columns.Add("leasecustomerid", "leasecustomerid")

            Me.DataGridViewLandDetails.Columns.Add("ownername", "ownername ")

            Me.DataGridViewLandDetails.Columns.Add("owneraddress1", "owneraddress1")

            Me.DataGridViewLandDetails.Columns.Add("owneraddress2", "owneraddress2")

            Me.DataGridViewLandDetails.Columns.Add("ownercity", "ownercity ")

            Me.DataGridViewLandDetails.Columns.Add("ownerpin", "ownerpin ")

            Me.DataGridViewLandDetails.Columns.Add("ownerstate", "ownerstate")

            Me.DataGridViewLandDetails.Columns.Add("landvalue", "landvalue")

            Me.DataGridViewLandDetails.Columns.Add("amountborrowed", "amountborrowed")

        End If

    End Sub

[jmcilhinney]

If you've programmatically created rows already then you need to programmatically create more rows. Where the data comes from is irrelevant to how you create the rows. You really are doing this the hard way. If you had just bound a DataTable as I said in the first place it would been a lit simpler.

[mails4vijayakumar]

no the columns i create programmatically and data comes database both are equal.....



now i want to add rows in that datagrid from database

[Radjesh Klauke]

Ola,

Your code doesn't make sense. When using the DataTable the rows are created for you. After that you can change the names of the header. What database are you using and what code do you have to connect to the database?