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??

Here is what I have: Dim connect As New SqlConnection("initial 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()...

woo hooo ..... this works!!!! Dim connect As New SqlConnection("initial 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...

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.....

Still stuck here .... the code runs till the last line then hang for about 10-15 seconds then returns the error shown below the code sample. This is basically straight out of and example.... Dim oSQLConn As SqlConnection = New SqlConnection oSQLConn.ConnectionString = "Initial...

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

Just trying to get data into a datagrid but it doesn't like my second to last line Dim oSQLConn As SqlConnection = New SqlConnection oSQLConn.ConnectionString = "Initial Catalog=rathmisc;User Id=sysadm;Password=sysadm;" Dim MyDataAdaptor As...

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

need to get time as time not date... Dim MyConnection As System.Data.Odbc.OdbcConnection Dim MyDataTable As New DataTable Dim MyDataAdaptor As System.Data.Odbc.OdbcDataAdapter Dim strMyConnection, strSavedFolder, strFilename As String strSavedFolder =...

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