trying to use fill method with SQL select statement

[Paul]

Hi I am trying to fill a datagrid based on the results of an SQL select statement. I am getting a login failure but am thinking
my connection string is ok as I am able to preview data from the data adapter and it looks correct so it is connecting to the dbase ok. I have it in the page load event

Server Error in '/user-login' Application
-------------------------------------------------------------------------------

Login failed for user 'xxxxxx'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Line 98:
Line 99: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Loa
Line 100: SqlDataAdapter1 .Fill(DataSetUs ers, "SqlSelectComma nd1"


Thanks Paul.

[Paul]

RE: trying to use fill method with SQL select statement

got this working, incorrect password in connection string.