Getting SQL Data to display in webforms

[BezerkRogue]

I have constructed a query and want the data to load in specific locations in the page when the page loads. I keep getting BC30311: Value of type 'String' cannot be converted to 'System.Web.UI.WebControls.TextBox'. when I run the page.

Here is the code I have so far:

Dim strSQL
Dim strShift
Dim strSelDate

strShift = lblShift.Text
strSelDate = lblSelDate.Text
strSQL = "SELECT * FROM Manpower_data INNER JOIN Shift ON Shift.Shift_ID = Manpower_data.Shift_ID WHERE Manpower_data.Date = '" & strSelDate & "' AND Shift.Shift = '" & strShift & "'"
Dim objConn As New Data.SqlClient.SqlConnection("Data Source=SomeServer;Initial Catalog=SomeDB;User ID=SomeUser;password=XXXXXXX;")
Dim objCmd As New Data.SqlClient.SqlDataAdapter(strSQL, objConn)
Dim objDataSet As New Data.DataSet
objCmd.Fill(objDataSet)
objConn.Open()
objConn.Close()

txtAbsent = objDataSet.Tables("Absent").ToString
txtTO = objDataSet.Tables("TO").ToString
txtHeadCount = objDataSet.Tables("HeadCount").ToString
txtStdHeadCount = objDataSet.Tables("STDHeadCount").ToString
txtMPNotes = objDataSet.Tables("Notes").ToString

What am I missing?

[Plater]

The error message should have been the big hint.

You have:

txtAbsent = objDataSet.Tables("Absent").ToString
txtTO = objDataSet.Tables("TO").ToString
txtHeadCount = objDataSet.Tables("HeadCount").ToString
txtStdHeadCount = objDataSet.Tables("STDHeadCount").ToString
txtMPNotes = objDataSet.Tables("Notes").ToString
 

What you need is:

txtAbsent.Text = objDataSet.Tables("Absent").ToString
txtTO.Text = objDataSet.Tables("TO").ToString
txtHeadCount.Text = objDataSet.Tables("HeadCount").ToString
txtStdHeadCount.Text = objDataSet.Tables("STDHeadCount").ToString
txtMPNotes.Text = objDataSet.Tables("Notes").ToString
 

However, the object you are trying to fill them with, will have a .ToString() of something like "DataTable" and not your values, you will need to pick the value from out of the table.

[BezerkRogue]

Doh.... thanks man. ur a lifesaver.

[BezerkRogue]

The error message should have been the big hint.

You have:

txtAbsent = objDataSet.Tables("Absent").ToString
txtTO = objDataSet.Tables("TO").ToString
txtHeadCount = objDataSet.Tables("HeadCount").ToString
txtStdHeadCount = objDataSet.Tables("STDHeadCount").ToString
txtMPNotes = objDataSet.Tables("Notes").ToString
 

What you need is:

txtAbsent.Text = objDataSet.Tables("Absent").ToString
txtTO.Text = objDataSet.Tables("TO").ToString
txtHeadCount.Text = objDataSet.Tables("HeadCount").ToString
txtStdHeadCount.Text = objDataSet.Tables("STDHeadCount").ToString
txtMPNotes.Text = objDataSet.Tables("Notes").ToString
 

However, the object you are trying to fill them with, will have a .ToString() of something like "DataTable" and not your values, you will need to pick the value from out of the table.

How do I do this with this code? I get the expected Object reference not set to an instance of an object error message.

[Plater]

This line:

objDataSet.Tables("Absent")
 

Is looking for a table called "Absent" in your dataset. I am going to guess you want a column by that name?

You will need to get at your table, there is probably only one table:

DataTable dt=objDataSet.Tables[0];
 

And then you will need the row, is there only going to be one row?

DataRow dr=dt.Rows[0];
 

Then from THAT you can get your columns

dr["Absent"].ToString()
 

You should be able to condense down if you want:

objDataSet.Tables[0].Rows[0]["Absent"].ToString();
 

[BezerkRogue]

This line:

objDataSet.Tables("Absent")
 

Is looking for a table called "Absent" in your dataset. I am going to guess you want a column by that name?

You will need to get at your table, there is probably only one table:

DataTable dt=objDataSet.Tables[0];
 

And then you will need the row, is there only going to be one row?

DataRow dr=dt.Rows[0];
 

Then from THAT you can get your columns

dr["Absent"].ToString()
 

You should be able to condense down if you want:

objDataSet.Tables[0].Rows[0]["Absent"].ToString();
 

Thanks. That's working great.