definitely Take a look at my corner of the net at Code Research Center

Well I can say if you make a class which is global then can tranfer parent form to child form . The easiest way is example if your form1 have textbox1.text = "....." and if you want to show that string in another form name form2 it would be label1.text=form1.textbox1.text then it would show the string have in your textbox1.text Hope it will help you

Google broken where you live ? There's an article on CP on communication between forms, I suggest you look that up, it will go into more detail than I will go into for a forum reply. Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

rajulama wrote: Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=;Data Source=" & fi.DirectoryName The names used in your code, you're trying to open a directory as a database. You have to give it the path to the .MDB file, not just it's parent directory. rajulama wrote: Dim objCmdSelect As New OleDbCommand("select * from table1" & fi.Name, objConn) On top of that, your SQL query to get the data in table1 (if it even exists in that database) is wrong. You appending the filename to the end of the SQL SELECT statement, which won't work. The filename goes in the Data Source if your connection string, not the SELECT statement. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Your's is actually the better alternative for this case (I hadn't even thought of that one). The only advantage to the method I suggested is that if the user deletes the contents of all the cells of a row, but does not delete the row itself, the row will also not be inserted. My advice is free, and you may get what you paid for.

You can't. Access doesn't have such a facility. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Hi, Great :) ... on the other hand, check Dave's comment regarding the location of database! best regards, NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]

The code you wrote, or dragged'n'dropped, is not automatically updated when you make changes to the database schema. You have to update any code you're written to deal with the new changes to the database. No, I really can't tell you the step-by-step on how to do it. There's just too much that you could have done and I have no way of knowing what needs to be changed and how. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Well, I can tell your SQL statement is wrong. Your code says something like this: SELECT \* FROM C:\\folder\\somefile.mdf which will not work at all. You're trying to try a file path as a table in SQL. You have to provide a TABLE name in the database to the SQL statement, not a file path. Seriously, you're missing the very basic concepts of working with databases. I highly suggest picking up a book on VB.NET and ADO.NET and working through them. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

If OpenFileDialog1.ShowDialog(Me) = DialogResult.OK Then Dim fi As New FileInfo(OpenFileDialog1.FileName) Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Text;Data Source=" & fi.DirectoryName Dim objConn As New OleDbConnection(sConnectionString) Dim objDataSet As DataSet = New DataSet() objConn.Open() Dim objCmdSelect As New OleDbCommand("SELECT * FROM " & fi.Name, objConn) Dim objAdapter1 As New OleDbDataAdapter objAdapter1.SelectCommand = objCmdSelect objAdapter1.Fill(objDataSet, "test") DataGridView1.DataSource = objDataSet.Tables(0).DefaultView objConn.Close() After this I wrote: objAdapter1.Update(Me.Db1DataSet.Sheet1("test")) Because the dataset that I want to update is in by DB1DataSet.Sheet1. I dont want to update the datagridview itself. I want to update an existing database called DB1DataSet.Sheet1 from the datagridview. when I wrote above line its says following error: Error 1 Overload resolution failed because no accessible 'Update' can be called with these arguments: 'Public Function Update(dataTable As System.Data.DataTable) As Integer': Value of type 'WindowsApplication1.db1DataSet.Sheet1Row' cannot be converted to 'System.Data.DataTable'. 'Public Function Update(dataRows() As System.Data.DataRow) As Integer': Value of type 'WindowsApplication1.db1DataSet.Sheet1Row' cannot be converted to '1-dimensional array of System.Data.DataRow'. 'Public Overrides Function Update(dataSet As System.Data.DataSet) As Integer': Value of type 'WindowsApplication1.db1DataSet.Sheet1Row' cannot be converted to 'System.Data.DataSet'.