Search results for query: *

Thanks ... the problem here is that i'm pulling data in from a text file ... adding some data to to it and pushing it out to a sql server.

The problem here is that the convert function below gives me an error in the ODBC data string. The SQL string works fine!!! Here is the error message I get at execution on console: error: ERROR [42000] [Microsoft][ODBC Text Driver] Undefined function 'convert' in expression...

okay but how do i put them into the dataset individualy??

...catalog=rathmisc;data source=server;user id=sysadm;password=sysadm") Dim MyDataAdaptor As New System.Data.sqlclient.SqlDataAdapter("select * from tbl_data_laser_1", connect) Try connect.Open() Dim DataSet As New DataTable...

...catalog=rathmisc;data source=server;user id=sysadm;password=sysadm") Dim MyDataAdaptor As New System.Data.sqlclient.SqlDataAdapter("select * from tbl_data_laser_1", connect) Try connect.Open() Dim DataSet As New DataTable...

okay the #$@$%^ connection string wrong ... I didn't have the data source= myserver in there.... thanks all .... boy this ain't easy....

that was all greek to me ..... i'm a struggling newbie ;)

okay I'm getting further.... now I get this!!!! error: Complex DataBinding accepts as a data source either an IList or an IListSource

moved it up one line .... same error

I put the stmt oSQLConn.Open() right before the MyAdaptor.fill(ds) line ..... Same error.....

...Dim MyDataTable As New DataSet Dim ds As New DataSet MyDataAdaptor = New SqlDataAdapter("select * from tbl_data_laser_1", oSQLConn) MyDataAdaptor.Fill(ds) An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional...

got ya

thanks ... I'll be at the library tonight!!!

that works thanks

just tried that ... same error : An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

...MyDataAdaptor As System.Data.sqlclient.SqlDataAdapter Dim MyDataTable As New DataTable MyDataAdaptor = New SqlDataAdapter("select * from tbl_data_laser_1", oSQLConn) MyDataAdaptor.Fill(MyDataTable) DataGrid1.DataSource = MyDataTable Code halts at the second to...

In this connection string : oSQLConn.ConnectionString="Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" what is the data source supposed to point at? this connection string was copied from an example. and I dont know what "aron1" is thanks jeff

I need a good book on vb.net as it relates to windows applications and sql database. I dont need any web stuff. Any suggestions. Oh lest I forget .... I dont know squat about vb.net. I get along fine in VBA. But this .net stuff is way different Thanks Jeff

...As String strSavedFolder = "c:\inetpub\wwwroot\" strFilename = "test.csv" strMyConnection = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" & strSavedFolder & ";" MyConnection = New Odbc.OdbcConnection(strMyConnection) MyDataAdaptor = New...

Okay thanks .... my problem was I put the imports stmt below (inside) the class stmt NOT on the first line of code Thanks .... I'll be back !!!! Jeff