R
roger.breton
Guest
I am developing a small SQL database, less than 2,000 records, at the present.
I'm using the Data Source Configuration Wizard in VisualStudio (my bad?) to create a Dataset which I then use in my application through the "Me." interface like this :
Me.ProductTableAdapter.Fill(Me.CIMSQLDataSet.Product)
By the time the code gets to this instruction, it's implicit that the Connection String associated with this DataSource has been consumed to fill the DataSet. My problem is that, I don't see where I can effectively *tell* the DataSet to use a different Connection String, at runtime, other than the one that was used at the time of going through the "DataSource Configuration Wizard"?
For the purpose of testing and development, I'm always connecting with the same user/pwd but for deployment, when UserX launches my application on machine Y, after he signs in, don't I need to use his credentials to log in the database?
I don't see how I can use users credentials to log into the database when the Connection String has been "coded" in SQLDataAdpters? (That's the best of my humble understanding) I'm not sure if I remember there is an option to supply the credentials later during DataSource Configuration? Will have to revisit its options...
Sorry if I seem to make this problem more complicated than it is.
Continue reading...
I'm using the Data Source Configuration Wizard in VisualStudio (my bad?) to create a Dataset which I then use in my application through the "Me." interface like this :
Me.ProductTableAdapter.Fill(Me.CIMSQLDataSet.Product)
By the time the code gets to this instruction, it's implicit that the Connection String associated with this DataSource has been consumed to fill the DataSet. My problem is that, I don't see where I can effectively *tell* the DataSet to use a different Connection String, at runtime, other than the one that was used at the time of going through the "DataSource Configuration Wizard"?
For the purpose of testing and development, I'm always connecting with the same user/pwd but for deployment, when UserX launches my application on machine Y, after he signs in, don't I need to use his credentials to log in the database?
I don't see how I can use users credentials to log into the database when the Connection String has been "coded" in SQLDataAdpters? (That's the best of my humble understanding) I'm not sure if I remember there is an option to supply the credentials later during DataSource Configuration? Will have to revisit its options...
Sorry if I seem to make this problem more complicated than it is.
Continue reading...