what is the vb .net coding fordatagridview control to add items?

Question

1.00/5 (3 votes)

See more:

VB

the purchased items should be added to datagridview control for report generation and to print the bill

Posted 27-Jul-11 23:34pm

KaniUmesh

Add a Solution

2 solutions

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)

Manas Bhardwaj · Answer 1 · 2011-07-27T23:41:00

If you could get the code for your project/task on CP without even caring to atleast explain in detail, thn it should be Code Porject who should get your pay check/payment from your client.
On a more serious note, this is a community where like you every one else works and tries to help other people when they have doubts. This is definitly not a place where you can Rent A Coder

dks1383 · Answer 2 · 2011-07-28T01:13:00

If your are familiar with ms access, make a database in access; for example db1.mdb.
then make a table on it : purchaseditems whit 2 fields: name (text) and price (number)

then make a vb.net project, add a datagridview to the form and use this code:

Imports System.Data
Imports System.Data.OleDb
Public Class Form1
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim con As OleDbConnection
        Dim cm As OleDbCommand
        Dim StrSql As String
        Dim da As OleDbDataAdapter
        Dim ds As New DataSet
        con = New OleDbConnection("provider=Microsoft.jet.OLEDB.4.0; data source=" + CurDir() + "\db1.mdb")
        con.Open()
        StrSql = "insert into purchaseditems (name,price) values ('book',65)"
        cm = New OleDbCommand(StrSql, con)
        cm.ExecuteNonQuery()
        StrSql = "select * from purchaseditems"
        da = New OleDbDataAdapter(StrSql, con)
        da.Fill(ds, "purchaseditems")
        Me.DataGridView1.DataSource = ds.Tables("purchaseditems")
        con.Close()
    End Sub
End Class

what is the vb .net coding fordatagridview control to add items?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0