[k3nnt0ter0]

Here's my connection

Public cnn2 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TSA-RMS\TSA-RMS\database\tsaDb.mdb")
    Public acc As String
    Public da As New OleDb.OleDbDataAdapter
    Public objcommand As New OleDb.OleDbCommand
    Public ds As New DataSet
    Public temp As String

Database : MS Access
Database Name : tsaDB.mdb
Table Name : dailyIncome
Datagrid Name : dgvDailyInc


Can you give me a sample?

By the way. How am I going to make my program locate the database even I transfer my database on other drives? I am having a hard time debugging the program after transferring my program to laptop. Database error always occur after transferring.

This post has been edited by k3nnt0ter0: 10 October 2011 - 10:27 PM

[Elda]

See it here

[k3nnt0ter0]

Elda, on 10 October 2011 - 11:29 PM, said:

See it here

Uhmm. . It seems like the problem in that link was saving data from textbox.
I know how to save from textbox but I don't know in datagrid. It's complicated for me

[smohd]

Or may be this

[k3nnt0ter0]

smohd, on 11 October 2011 - 01:10 AM, said:

Or may be this

I still don't get it

[smohd]

I sorry for wrong link first, I miss read your question, that link shows how to retrieve data from database to grid.
But how did you retrieve data from the table to grid which you want to change update now? Because if your data adapter has a connection to a source, then we can feed data and ask it to update..

[k3nnt0ter0]

smohd, on 11 October 2011 - 05:40 AM, said:

I sorry for wrong link first, I miss read your question, that link shows how to retrieve data from database to grid.
But how did you retrieve data from the table to grid which you want to change update now? Because if your data adapter has a connection to a source, then we can feed data and ask it to update..

Don't mind it

I haven't done yet the data retrieval. Should I do that first?

[smohd]

It depends on what you need to do, but we must use have a data set with table and an adapter to update the data source.
If you want to call the table, preview it in data grid, do changes and then update, yes then you need to call data first to the grid so the data set associated to it will know changes that has been done(either adding new rows or make changes to the existing rows)

[k3nnt0ter0]

smohd, on 11 October 2011 - 06:06 AM, said:

It depends on what you need to do, but we must use have a data set with table and an adapter to update the data source.
If you want to call the table, preview it in data grid, do changes and then update, yes then you need to call data first to the grid so the data set associated to it will know changes that has been done(either adding new rows or make changes to the existing rows)

Correct me if I'm wrong. Is the adapter you are talking about the one stated at post #1?
I'll place some data on my database. Help me call it.

[smohd]

Yes indeed, you will need to initialize it and pass to it the connection and the query to be executed. After that you will use its Fill() method to fill the data set. Then get the table from data set and add it to the grid view.
Simple enough like this pseudo:

objcommand.CommanText = "query"
objcommand.COnnection = yourConnection
da = New OleDbDataAdapter(objcommand)
da.Fill(ds, "TableName")
datagrid.DataSource = ds.Table(0)

Implement it and ou will be happy.