Post Your Vb6 Or Vb.net Problems Here

I want 2 start learning frm scratch can you help me?

I am trying to copy data from another dataset then save the new dataset into my database. Below is my code. The line hightlighted in red assigns my dataset (containing copied data) to the grid's datasource and displays the copied data just fine. However, after calling the DBAdapter.Update, the copied data is not commited into my database.

In a Nutshell -- The output displayed on the grid contains copied data while the data updated to the database doesnt. Can tell what i'm doing wrong?

Thanks

===============================================================================

Private Sub UpdateDataBase(ByVal ds As DataSet)

        Dim dbConnString As String

        Dim dbConnection As SqlConnection = New SqlConnection
        dbConnection.ConnectionString = "Data Source=ServerName; Initial Catalog=DB;" & _
        "UID=uid;PASSWORD=psw; Trusted_Connection=false"
        dbConnection.Open()

        Dim DBCmd As SqlCommand
        DBCmd = New SqlCommand("Select * from [Table1]", dbConnection)

        Dim DBAdapter As New SqlDataAdapter
        DBAdapter.SelectCommand = DBCmd

        Dim DBds As New DataSet
        DBAdapter.Fill(DBds, "Table1")

        DBds = ds.Copy()
        DBds.AcceptChanges()
        DBAdapter.Update(DBds.Tables("Table1"))
        DataGrid1.DataSource = DBds.Tables(0).DefaultView
        DataGrid1.DataBind()

        DBds = Nothing
        DBAdapter = Nothing
        DBCmd = Nothing
        ds = Nothing

    End Sub

@rookie, I think the problem is that you did not specify an updatecommand for the dataAdapter.
The code in blue is my addition to your code.

Private Sub UpdateDataBase(ByVal ds As DataSet)

        Dim dbConnString As String

        Dim dbConnection As SqlConnection = New SqlConnection
        dbConnection.ConnectionString = "Data Source=ServerName; Initial Catalog=DB;" & _
        "UID=uid;PASSWORD=psw; Trusted_Connection=false"
        dbConnection.Open()

        Dim DBCmd As SqlCommand
        DBCmd = New SqlCommand("Select * from [Table1]", dbConnection)

        Dim DBAdapter As New SqlDataAdapter
        DBAdapter.SelectCommand = DBCmd

        Dim builder as new SqlCommandBuilder
        builder.DataAdapter = DBAdapter
        DBAdapter.UpdateCommand = builder.getUpdateCommand
        DBAdapter.InsertCommand = builder.getInsertCommand
       
        Dim DBds As New DataSet
        DBAdapter.Fill(DBds, "Table1")

        DBds = ds.Copy()
        DBds.AcceptChanges()
        DBAdapter.Update(DBds.Tables("Table1"))
        DataGrid1.DataSource = DBds.Tables(0).DefaultView
        DataGrid1.DataBind()

        DBds = Nothing
        DBAdapter = Nothing
        DBCmd = Nothing
        ds = Nothing

    End Sub

The DataAdapter needs to know the SELECT, INSERT,UPDATE and DELETE statements to use against the database.
You have already specified the SELECT sql but the remaining are missing.
I used the sqlCommandbuilder to build the remaining sql statements so you wont have to do it manually.
Hope this helps.

please i'm a new fellow in vb area
please i need someone to help with code using ado
to Connect to ms access dbase using Application Path

2. To Add record
3. To Update Record
4. Delete Record

5. Move First,Next,Previous, Last record
6. Search Record.
I will very gratefull for ur help thnks
My mail is vb_4all@yahoo.com

I create a dll file in VB.net converted it vb6.0 dll but I could not see all the public properties. What will I do?

Have a problem on : A program or subroutine to solve
1-- Matrix Multiplication of any order
2--Determinant of a matrix
3--Cofactor of a matrix
4--Inverse of a Matrix
5--rank of a matrix
6--Guassian elimination
7--Triangular decomposition
8--differential equation of order 3

how do i connect my access database to my form in visual basics

this is my 2nd reply to this issue.
solution

specify the updatecommand and set its appropriate requirements.
it is important
call the Update method of the dataadapter.
call the acceptchanges.

this is how datasets work
when u call update, it checks all the rows on the dataset object u want to update to c if the rowstatechanged property is true
if it is true, it updates on the database.
however, calling acceptchanges before update, sets the rowstatechanged property to false thus, when update is called , no rowchange is detected and so updates are not made.

this is a standard MCAD,MCSD question. there is no other solution as regards this issue. if you need more info, mail me at callcarliecode@yahoo.co.uk . i av passed 70-306 with 100% score and I'm writing 70-305 this wk. i av used dotnet 4 about 6yrs. i am so sure

@ Dejisys


can u give some hints to my matrices quest