datasetUserinfo is filled with values from my DB (using sqlclient)
datagridviewUserinfo is bound to my dataset
I am uploading data ( a CSV file ) into my dataset (using ODBC)
the dataset reflects the row additions (datasetUserinfo.Tables("userinfo").Rows.Count) as does datagridviewUserinfo
I am attempting to save to my database using the following code:
no dice. Nothing is updated. I don't even get an error message.VB Code:
Dim CmdBuilderUserInfoAs New SqlClient.SqlCommandBuilder(UserInfoDataAdapter) UserinfoDataAdapter.UpdateCommand = CmdBuilderUserinfo.GetUpdateCommand UserinfoDataAdapter.Update(datasetUserinfo, "userinfo")
Could the glitch come with using more than one connection type on the same form? Sql and ODBC




Reply With Quote