databound datagridview - 'null password given; login denied'

[scottsheck]

I am using VB 2005 and placed just a DataGridView on a form. In design mode, I can preview data fine, but when I run the program, I get an error 'null password given; login denied'. This is probably because when I set up the data source, I specified not to store the password in the connection string.

What am I doing wrong and also, how is the adapter know what connection string to use? I'm new to vb.net. help...

Scott

 

[babila]

how is the adapter know what connection string to use?
Scott

adpt.SelectCommand.Connection = Connection_Name

 

[scottsheck]

connecion

thanks, that works. But isn't there a way to modify the default connection that the adapter uses at runtime, rather than setting the adapters connection. In other words, if I had many adapters and controls, it would be nice not to have to set the connection property for each control.

Basically, I have a login screen that prompts for a password and I would like to set the password in the connection string at runtime once.

thanks,
Scott