jhpajiri

This is my sample source Code.. [CODE]Dim i as Integer For i=0 to DataGridView1.Rows.Count INSERT INTO tableName(Field1,Field2) VALUES('" & DataGridView1.Item(0,i).value & "','" & DataGridView1.Item(1,i) & "')" Next[/CODE] I hope it will help.. JHPAJIRI

[QUOTE=saadsaidi;580052]Hello all, A friend of mine developed a program using vb 6 using an "MS Access" database. he used ODBC to connect the users to database over network. The problem is he needs to connect 20+ computers to this program, and all computers are equipped with winxp sp2, that as …

'You must[code] import the System.Data.sqlClient 'Import this in General Declaration Imports System.Data.sqlClient[/code] 'Declare this in your Form Declaration [code]Dim conn as sqlConnection[/code] 'In your Form Load type this. Try [code] conn=new sqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=databaseName;Integrated Security=True") conn.open() msgbox("Connection Established.") Catch ex as Exception msgbox(ex.Message) End Try[/code]

[QUOTE=wiss.dev;1080354]i published a project from project properties. it creates an installer file but launching the application automatically, plus not promtting a save dialogue box for a directory . is there any other ways of doing it.............thanks[/QUOTE] Go to the directory where your project is located, look for the "bin" folder …