Problem reading data into Dataset

[Camper Joe]

Here's my code:

Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s)
Dim db As New SqlConnection
Dim strSQL As String = "SELECT * FROM users WHERE strUsername = '" &
txtUsername.Tex t & "'"
Dim ds1 As DataSet = New DataSet()

db.ConnectionSt ring = "Data Source=.\SQLExp ress;Integrated
Security=True;U ser
Instance=True;d atabase=permit5 0;AttachDBFilen ame=|DataDirect ory|aspnetdb.md f;"
db.Open()

Dim mySqlAdapter As SqlDataAdapter = New SqlDataAdapter( strSQL, db)
mySqlAdapter.Fi ll(ds1, "users")

If ds1.Tables("str Username").Rows .Count = 0 Then
lblError.Text = "Invalid Username"
Else
If ds1.Tables("USe rs").Columns("s trPassword").Ca ption <> Not
txtPassword.Tex t Then
lblError.Text = "Invalid Password"
Else
Session("tblUse rsID") =
ds1.Tables("Use rs").Columns("t blUsersID").Cap tion
Session("strFir stname") =
ds1.Tables("Use rs").Columns("s trFirstname").C aption
Session("strUse rname") =
ds1.Tables("Use rs").Columns("s trUsername").Ca ption
Response.Redire ct("welcome.asp x")
End If
End If
End Sub

My Error is on the part that goes: mySqlAdapter.Fi ll(ds1, "users")

My error message is:System.data. SqlClientExcept ion: Invalid pbject name
'users'.

Users does exist in my database. I am using SQL Server 2005 Express.

Any Ideas? Any Questions?

[serge calderara]

Hi,

Check if your Adapter object is really valid and then verify also your ds1
object
Try to remove second parameter of the Fill method to verify if it able to
fill data in default dataset table name
When you create a dataset obect it has a default table named Table1
When you use the fill method as you do, the second string could be anything
and will be used as the dataset table name object

"Camper Joe" wrote:

Here's my code:

Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s)
Dim db As New SqlConnection
Dim strSQL As String = "SELECT * FROM users WHERE strUsername = '" &
txtUsername.Tex t & "'"
Dim ds1 As DataSet = New DataSet()

db.ConnectionSt ring = "Data Source=.\SQLExp ress;Integrated
Security=True;U ser
Instance=True;d atabase=permit5 0;AttachDBFilen ame=|DataDirect ory|aspnetdb.md f;"
db.Open()

Dim mySqlAdapter As SqlDataAdapter = New SqlDataAdapter( strSQL, db)
mySqlAdapter.Fi ll(ds1, "users")

If ds1.Tables("str Username").Rows .Count = 0 Then
lblError.Text = "Invalid Username"
Else
If ds1.Tables("USe rs").Columns("s trPassword").Ca ption <> Not
txtPassword.Tex t Then
lblError.Text = "Invalid Password"
Else
Session("tblUse rsID") =
ds1.Tables("Use rs").Columns("t blUsersID").Cap tion
Session("strFir stname") =
ds1.Tables("Use rs").Columns("s trFirstname").C aption
Session("strUse rname") =
ds1.Tables("Use rs").Columns("s trUsername").Ca ption
Response.Redire ct("welcome.asp x")
End If
End If
End Sub

My Error is on the part that goes: mySqlAdapter.Fi ll(ds1, "users")

My error message is:System.data. SqlClientExcept ion: Invalid pbject name
'users'.

Users does exist in my database. I am using SQL Server 2005 Express.

Any Ideas? Any Questions?

[Camper Joe]

Hi.

Thanks for the advice.
I've tried it. Whether I leave the second part of the .fill blank, or put in
"table1", it still
gives me the error System.Data.Sql Client.SqlExcep tion: Invalid object name
'users'.
CJ

"serge calderara" wrote:

Hi,

Check if your Adapter object is really valid and then verify also your ds1
object
Try to remove second parameter of the Fill method to verify if it able to
fill data in default dataset table name
When you create a dataset obect it has a default table named Table1
When you use the fill method as you do, the second string could be anything
and will be used as the dataset table name object

"Camper Joe" wrote:

Here's my code:

Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s)
Dim db As New SqlConnection
Dim strSQL As String = "SELECT * FROM users WHERE strUsername = '" &
txtUsername.Tex t & "'"
Dim ds1 As DataSet = New DataSet()

db.ConnectionSt ring = "Data Source=.\SQLExp ress;Integrated
Security=True;U ser
Instance=True;d atabase=permit5 0;AttachDBFilen ame=|DataDirect ory|aspnetdb.md f;"
db.Open()

Dim mySqlAdapter As SqlDataAdapter = New SqlDataAdapter( strSQL, db)
mySqlAdapter.Fi ll(ds1, "users")

If ds1.Tables("str Username").Rows .Count = 0 Then
lblError.Text = "Invalid Username"
Else
If ds1.Tables("USe rs").Columns("s trPassword").Ca ption <> Not
txtPassword.Tex t Then
lblError.Text = "Invalid Password"
Else
Session("tblUse rsID") =
ds1.Tables("Use rs").Columns("t blUsersID").Cap tion
Session("strFir stname") =
ds1.Tables("Use rs").Columns("s trFirstname").C aption
Session("strUse rname") =
ds1.Tables("Use rs").Columns("s trUsername").Ca ption
Response.Redire ct("welcome.asp x")
End If
End If
End Sub

My Error is on the part that goes: mySqlAdapter.Fi ll(ds1, "users")

My error message is:System.data. SqlClientExcept ion: Invalid pbject name
'users'.

Users does exist in my database. I am using SQL Server 2005 Express.

Any Ideas? Any Questions?

[kashifahmed.bse.mg]

hi,

u may assign a name to dataset at creating time..

dim ds as dataset=new dataset("user1" )

and please use try catch exception with finally....

u may better just declare variable first, then use try catch exception
and open connection

allocate memory for adapter then dataset and do further ur business
programming...

this all may help u to solve prob....

kashif ahmed

[serge calderara]

if mySqlAdapter.Fi ll(ds1) generate the error then try to verify your SQl
query within SQL querry to check if it works.

If it is, the from your code juste for test run the query "SELECT * FROM
user" just to check

If it works, verify your SQL string when it is build

regards
serge
"Camper Joe" wrote:

Hi.

Thanks for the advice.
I've tried it. Whether I leave the second part of the .fill blank, or put in
"table1", it still
gives me the error System.Data.Sql Client.SqlExcep tion: Invalid object name
'users'.
CJ

"serge calderara" wrote:

Hi,

Check if your Adapter object is really valid and then verify also your ds1
object
Try to remove second parameter of the Fill method to verify if it able to
fill data in default dataset table name
When you create a dataset obect it has a default table named Table1
When you use the fill method as you do, the second string could be anything
and will be used as the dataset table name object

"Camper Joe" wrote:

Here's my code:

Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s)
Dim db As New SqlConnection
Dim strSQL As String = "SELECT * FROM users WHERE strUsername = '" &
txtUsername.Tex t & "'"
Dim ds1 As DataSet = New DataSet()

db.ConnectionSt ring = "Data Source=.\SQLExp ress;Integrated
Security=True;U ser
Instance=True;d atabase=permit5 0;AttachDBFilen ame=|DataDirect ory|aspnetdb.md f;"
db.Open()

Dim mySqlAdapter As SqlDataAdapter = New SqlDataAdapter( strSQL, db)
mySqlAdapter.Fi ll(ds1, "users")

If ds1.Tables("str Username").Rows .Count = 0 Then
lblError.Text = "Invalid Username"
Else
If ds1.Tables("USe rs").Columns("s trPassword").Ca ption <> Not
txtPassword.Tex t Then
lblError.Text = "Invalid Password"
Else
Session("tblUse rsID") =
ds1.Tables("Use rs").Columns("t blUsersID").Cap tion
Session("strFir stname") =
ds1.Tables("Use rs").Columns("s trFirstname").C aption
Session("strUse rname") =
ds1.Tables("Use rs").Columns("s trUsername").Ca ption
Response.Redire ct("welcome.asp x")
End If
End If
End Sub

My Error is on the part that goes: mySqlAdapter.Fi ll(ds1, "users")

My error message is:System.data. SqlClientExcept ion: Invalid pbject name
'users'.

Users does exist in my database. I am using SQL Server 2005 Express.

Any Ideas? Any Questions?

[Camper Joe]

Thanks for the support.

After reading up on datasets, I saw that if your SELECT query doesn't return
any rows, the table object doesn't get created.

CJ.

"ka************ ****@gmail.com" wrote:

hi,

u may assign a name to dataset at creating time..

dim ds as dataset=new dataset("user1" )

and please use try catch exception with finally....

u may better just declare variable first, then use try catch exception
and open connection

allocate memory for adapter then dataset and do further ur business
programming...

this all may help u to solve prob....

kashif ahmed

[Camper Joe]

Thanks for the support.

After reading up on datasets, I saw that if your SELECT query doesn't return
any rows, the table object doesn't get created.

CJ.

"serge calderara" wrote:

if mySqlAdapter.Fi ll(ds1) generate the error then try to verify your SQl
query within SQL querry to check if it works.

If it is, the from your code juste for test run the query "SELECT * FROM
user" just to check

If it works, verify your SQL string when it is build

regards
serge
"Camper Joe" wrote:

Hi.

Thanks for the advice.
I've tried it. Whether I leave the second part of the .fill blank, or put in
"table1", it still
gives me the error System.Data.Sql Client.SqlExcep tion: Invalid object name
'users'.
CJ

"serge calderara" wrote:

Hi,

Check if your Adapter object is really valid and then verify also your ds1
object
Try to remove second parameter of the Fill method to verify if it able to
fill data in default dataset table name
When you create a dataset obect it has a default table named Table1
When you use the fill method as you do, the second string could be anything
and will be used as the dataset table name object

"Camper Joe" wrote:

> Here's my code:
>
> Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
> System.EventArg s)
> Dim db As New SqlConnection
> Dim strSQL As String = "SELECT * FROM users WHERE strUsername = '" &
> txtUsername.Tex t & "'"
> Dim ds1 As DataSet = New DataSet()
>
> db.ConnectionSt ring = "Data Source=.\SQLExp ress;Integrated
> Security=True;U ser
> Instance=True;d atabase=permit5 0;AttachDBFilen ame=|DataDirect ory|aspnetdb.md f;"
> db.Open()
>
> Dim mySqlAdapter As SqlDataAdapter = New SqlDataAdapter( strSQL, db)
> mySqlAdapter.Fi ll(ds1, "users")
>
> If ds1.Tables("str Username").Rows .Count = 0 Then
> lblError.Text = "Invalid Username"
> Else
> If ds1.Tables("USe rs").Columns("s trPassword").Ca ption <> Not
> txtPassword.Tex t Then
> lblError.Text = "Invalid Password"
> Else
> Session("tblUse rsID") =
> ds1.Tables("Use rs").Columns("t blUsersID").Cap tion
> Session("strFir stname") =
> ds1.Tables("Use rs").Columns("s trFirstname").C aption
> Session("strUse rname") =
> ds1.Tables("Use rs").Columns("s trUsername").Ca ption
> Response.Redire ct("welcome.asp x")
> End If
> End If
>
>
> End Sub
>
>
>
> My Error is on the part that goes: mySqlAdapter.Fi ll(ds1, "users")
>
> My error message is:System.data. SqlClientExcept ion: Invalid pbject name
> 'users'.
>
> Users does exist in my database. I am using SQL Server 2005 Express.
>
> Any Ideas? Any Questions?
>
>