Simply import whats in your datagridview to ms access 2007

i got the datagrid to work to send to the database, What happens is in access Index is a key word, So therefore you cant use keywords as column header, it will never work, it took a thousand years to figure that out
alot of people dont know. So be careful guys . I change Index to CIfIndex and it work perfectly find.

But I after the program finish update its get a error saying object reference is not set to an instance of an object.  I think thats a null issue, how can i advoid that.

kiran did you do anything yet ?

How you do it with the table adapter or dataset, importing to the Access , that might be quicker since you say its huge data

I get a synax error into the INSERT statement, when i run the program

I get a synax error into the INSERT statement, when i run the program

this is one method of inserting,if you have huge data then go for  dataadapter
mark the answer if it helps you

you try, adding rows dynamically.set the enable adding to false.do the same like what i did.i.e adding rows dynamically,then put the data in the grid and then insert it to database

MARK THE ANSWER IF IT HELPS YOU

OleDbParameter odbpOpTimeStamp = new OleDbParameter("@Op_Time_Stamp", OleDbType.VarChar, 50);
why you go for varchar,take the datatype as datetime
mark the answer if it helps you

I sent you the project did you get it
the properties are

int              Index
datetime    Op_Time_Stamp
text           UUT_MSN
text           OperationID
text           Etag
text           EDescription
text           E_Time_Stamp1
text           E_Time_Stamp2
text           EValue

I think it fails at the datetime property im not for sure, I have 916 rows in the datatable right now, so I didnt step through all of the rows


but

Now Im revieving a error saying fail to parameter value ro datagridviewtextbox cell to a string.

Also karan  if my column headers in access are       int , datetime, text, text , text, text, text, text    does  thats matter in code.


meaning  the OleDbType.VarChar, 50.

should it be this way


OleDbType.Interger, 50
OleDbType.DBDatetime, 50
OleDbType.VarChar, 50
OleDbType.VarChar, 50
OleDbType.VarChar, 50
OleDbType.VarChar, 50
OleDbType.VarChar, 50
OleDbType.VarChar, 50

I received a  error saying fail to convert parameter as a string, I dont know what else to do.

Does it matter that my first two columns are a integer and the second column is a datetime?

kiran how do you set the enable property, Im new to this database period.

what do you mean try adding rows dynamically?

set enable adding  property to false..try adding your rows dynamically and put the data and save it to database..then regarding the query passed to the command object..you need to check if the attributes specified in the query matches the one specified in the database table
hope it resolves your problem
mark the answer if it helps you

have you tested my project?ok,what is the complete statement of error,mail me your project files..

Ok im running into a error, Syntax error into to INSERT statement, I dont know why im getting that error, Do you think because I hide one of the roles in the .mdb file could be the reason why im getting this error, I aslo starting the cell[] from 0. cell[0] , when I start from cell[0], I get a error thats saids object is not reference.


                strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\z1083774\\Desktop\\CIF CCA UTILITY\\Working Project CIF\\Software Info\\CifCLUOpDataLibrary\\WindowsFormsApplication1\\bin\\Debug\\CLU_OpData.mdb";

                objConnection = new OleDbConnection(strConnection);
                objConnection.ConnectionString = strConnection;
                objConnection.Open();

 
                OleDbCommand cmd = new OleDbCommand("insert into    
            CLU_OpData(Index,Op_Time_Stamp,UUT_MSN,OperationID,Etag,EDescription,E_Time_Stamp1,E_Time_Stamp2,EValue)values(@Index,@Op_Time_Stamp,@UUT_MSN,@OperationID,@Etag,@EDescription,@E_Time_Stamp1,@E_Time_Stamp2,@EValue)", objConnection);
                for (int i = 0; i < dataGridView2.RowCount; i++)
                {

                    OleDbParameter odbpIndex = new OleDbParameter("@Index", OleDbType.VarChar, 50);
                    odbpIndex.Value = this.dataGridView2.Rows[i].Cells[0].Value.ToString();
                    cmd.Parameters.Add(odbpIndex);
                    OleDbParameter odbpOpTimeStamp = new OleDbParameter("@Op_Time_Stamp", OleDbType.VarChar, 50);
                    odbpOpTimeStamp.Value = dataGridView2.Rows[i].Cells[1].Value.ToString();
                    cmd.Parameters.Add(odbpOpTimeStamp);

                    OleDbParameter odbpUutMsn = new OleDbParameter("@UUT_MSN", OleDbType.VarChar, 50);
                    odbpUutMsn.Value = dataGridView2.Rows[i].Cells[2].Value.ToString();
                    cmd.Parameters.Add(odbpUutMsn);

                    OleDbParameter odbpOperationID = new OleDbParameter("@OperationID", OleDbType.VarChar, 50);
                    odbpOperationID.Value = this.dataGridView2.Rows[i].Cells[3].Value.ToString();
                    cmd.Parameters.Add(odbpOperationID);

                    OleDbParameter odbpEtag = new OleDbParameter("@Etag", OleDbType.VarChar, 50);
                    odbpEtag.Value = dataGridView2.Rows[i].Cells[4].Value.ToString();
                    cmd.Parameters.Add(odbpEtag);

                    OleDbParameter odbpEDescription = new OleDbParameter("@EDescription", OleDbType.VarChar, 50);
                    odbpEDescription.Value = this.dataGridView2.Rows[i].Cells[5].Value.ToString();
                    cmd.Parameters.Add(odbpEDescription);

                    OleDbParameter odbpEtimeStamp1 = new OleDbParameter("@E_Time_Stamp1", OleDbType.VarChar, 50);
                    odbpEtimeStamp1.Value = dataGridView2.Rows[i].Cells[6].Value.ToString();
                    cmd.Parameters.Add(odbpEtimeStamp1);

                    OleDbParameter odbpEtimeStamp2 = new OleDbParameter("@E_Time_Stamp2", OleDbType.VarChar, 50);
                    odbpEtimeStamp2.Value = this.dataGridView2.Rows[i].Cells[7].Value.ToString();
                    cmd.Parameters.Add(odbpEtimeStamp2);

                    OleDbParameter odbpEvalue = new OleDbParameter("@EValue", OleDbType.VarChar, 50);
                    odbpEvalue.Value = this.dataGridView2.Rows[i].Cells[8].Value.ToString();
                    cmd.Parameters.Add(odbpEvalue);

                    cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();

hello darnell,i have written a sample code for you,check it out.i followed a way to insert  your datagrid values to access database.i am uploading my project files and database file too..check it out 
here is the screen shots of my sample project.

you can add rows dynamically.enter the no of rows in the textbox to be added in the datagrid and click on the button "add rows",after doing this enter the values in datagrid and click on the button "save to access database"  and a window appears informing you that your values were saved to access database


PLEASE MARK THE ANSWER IF IT HELPS YOU

You can use the Server Explorer to connect to the database, then use the Data Sources window to create a data source. Then you can drag the data source to a blank form. By default, a DataGridView bound to the table will be created in the form with a navigation bar above it. If you build the project as-is, you have a functioning database program. The generated program will include code to save the modifications in the DataGridView. All of that without writing any code. You can merge into that whatever code that you have developed that is relevant to your data.
 
See Visual C++ Guided Tour for a worthwhile tour, except you don't need to do them in the order they appear.