Data in dataset but not displaying in gridview

Hi Kjewell23,

I've moved your question to the .NET Forum.
The .NET Articles section is reserved for "how-tos" and other helpful tips and is not meant for questions. In the future please post your questions in the .NET Forum (Blue menu at top: Forums -> .NET).

Also, it is not a good idea to post your IP's with your code.
I've edited your post to remove the IP.

Thanks!

-Frinny

Hello, I'm new to this asp.net 2.0 I need help??
My database is coming from AS400 which uses odbc Commands. i have data in the dataset but nothing showing in my gridview. However the data does show on the page. Could you please see what I'm doing wrong. ....

What do you mean that it shows up on the page?

What do you mean that it shows up on the page?

The data shows up on the top of the page but it pushes everything down like the title of the page, textbox, and button. Here i show you want I mean

Down below

600452 1.000 0 1.000 9/25/2006 EA 06759055 30.450 ( this is the data)


(title)Order Detail Inquiry

Order Number(label) textbox here (submit button here)

Hi jewell,,

I would suggest to remove part of the code that i am pasting here and replace with what i am giving here.

Remove this :
Replace it with.
and let me know how it went.

thanks

Samir

The data shows up on the top of the page but it pushes everything down like the title of the page, textbox, and button. Here i show you want I mean

Down below

600452 1.000 0 1.000 9/25/2006 EA 06759055 30.450 ( this is the data)


(title)Order Detail Inquiry

Order Number(label) textbox here (submit button here)

Oh ok, that's because of the Response.Write that you have there...sorry for some reason I skipped over that whole bit of code...taking a closer look at your code now.

Try removing the gridview1.DataBind() from Here:

And try making this change as well:
It may be that it can't find
-Frinny

Ok that didn't work It shows nothing.

Hi jewell,,

I would suggest to remove part of the code that i am pasting here and replace with what i am giving here.

Remove this :

#
If numrows = 0 Then
#
txtOrderNumber.Text = "Order#" & txtOrderNumber.Text & " invalid order number"
#

#
Else
#
txtOrderNumber.Text = ""
#

#
For loop1 = 0 To numrows - 1
#

#
Response.Write(Server.HtmlEncode(gvResults.Rows(lo op1).Item("ordno")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quan o")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quan a")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quan s")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("c2rd t")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("unit m")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("prdn o")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("acts p")) & " <br>")
#

#

#
Next loop1
#
gridview1.DataBind()
#
End If
#

#
gridview1.DataSource = mydataset.Tables("OBCOP200").DefaultView


Replace it with.

gridview1.DataSource = mydataset.Tables("OBCOP200")

and let me know how it went.

thanks

Samir

So just take out the gridview1.databind() in the next loop1 section

Oh ok, that's because of the Response.Write that you have there...sorry for some reason I skipped over that whole bit of code...taking a closer look at your code now.

Try removing the gridview1.DataBind() from Here:

Expand|Select|Wrap|Line Numbers

1.  
2.         If numrows = 0 Then
3.             txtOrderNumber.Text = "Order#" & txtOrderNumber.Text & " invalid order number"
4.  
5.         Else
6.             txtOrderNumber.Text = ""
7.  
8.             For loop1 = 0 To numrows - 1
9.  
10.                 Response.Write(Server.HtmlEncode(gvResults.Rows(loop1).Item("ordno")) & " " & Server.HtmlEncode(g        gridview1.DataSource = mydataset.Tables("OBCOP200").DefaultView
11.         gridview1.DataBind()
12.         gridview1.Visible = True
13.  
14.  
15. vResults.Rows(loop1).Item("quano")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quana")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("quans")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("c2rdt")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("unitm")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("prdno")) & " " & Server.HtmlEncode(gvResults.Rows(loop1).Item("actsp")) & " <br>")
16.  
17.  
18.             Next loop1
19.   'remove ------>          gridview1.DataBind()
20.         End If

And try making this change as well:

Expand|Select|Wrap|Line Numbers

1. gridview1.DataSource = mydataset
2. gridview1.DataBind()
3. gridview1.Visible = True
4.  

It may be that it can't find

Expand|Select|Wrap|Line Numbers

1.   gridview1.DataSource = mydataset.Tables("OBCOP200").DefaultView

-Frinny

So just take out the gridview1.databind() in the next loop1 section

Yes and take out the .Tables("...").DefaultView from:
I have a feeling you're looking up a table in your data set that doesn't exist...

Using Response.Write() is discouraged if you have controls on the page as using it can cause unknown/undesired results.
You should use an ASP:Label or ASP:Panel and write the text inside those instead.

Also, there a few things that could cause no data to be displayed:

• Configurable display options for gridview are set to hide data
• Cycling through the DataTable with that lookp is marking the data "read" and the gridview sees that (very unlikely)
• Nameing the DataTable with a TableName is causing some confusion and the gridview is only getting to look at an empty table because of it.
• Also, I would have to check, but try taking out the ".DefaultView", since gridviews want a table not a view. (I always just use the Table)

You can use the DataAdapter to populate a DataTable directly rather then a DataSet if you wanted.

Using Response.Write() is discouraged if you have controls on the page as using it can cause unknown/undesired results.
You should use an ASP:Label or ASP:Panel and write the text inside those instead.

Also, there a few things that could cause no data to be displayed:

• Configurable display options for gridview are set to hide data
• Cycling through the DataTable with that lookp is marking the data "read" and the gridview sees that (very unlikely)
• Nameing the DataTable with a TableName is causing some confusion and the gridview is only getting to look at an empty table because of it.
• Also, I would have to check, but try taking out the ".DefaultView", since gridviews want a table not a view. (I always just use the Table)

You can use the DataAdapter to populate a DataTable directly rather then a DataSet if you wanted.

I thought that the Response.Write bit was for debugging purposes....
Am I wrong here???

i did that and it still displays but not in gridview. It shows that I have three rows in the part where if numrows and on down . When I debug it it shows system. dataset where the fill command is and then it shows mydataset.Tables = {System.Data.DataTableCollection} at gvResults = (where the datatable is)
then it has the number of rows in if then and then it has the number that i typed inside the text box also in the else then it through the loop 23 times before displaying it. and then finally it shows at gridview1.DataSource = Nothing
after the if statements ends when its highlighted then after highlightended is gone is shows mydataset = {System.Data.DataSet}

so does that mean anything to you

Yes and take out the .Tables("...").DefaultView from:

Expand|Select|Wrap|Line Numbers

1. gridview1.DataSource = mydataset.Tables("OBCOP200").DefaultView
2.  

I have a feeling you're looking up a table in your data set that doesn't exist...

the response write is for debugging but if I take that out nothing shows up

I thought that the Response.Write bit was for debugging purposes....
Am I wrong here???

Wel their are certain numbers that has alot of pages so I was going to do sorting and paging. Can a panel do that?

I thought that the Response.Write bit was for debugging purposes....
Am I wrong here???

From what I've read, Response.Write() just injects whatever you put into the current section of the buffer. Which could be inside one of your html elements.
I thought it was supposed to work similar to javascripts' Document.Write(), but I've ehard of it doing funny things with the sending buffer from people.

I thought that the Response.Write bit was for debugging purposes....
Am I wrong here???

Wel their are certain numbers that has alot of pages so I was going to do sorting and paging. Can a panel do that?

No no, gridview is the right object for displaying your data, it's the strings used in Response.Write() that should go into some temporary ASP:Label or other text-displaying control.

the response write is for debugging but if I take that out nothing shows up

Well we know that you have filled your DataSet correctly...and that it's just a matter of getting that data to show in your GridView.

Take a look at MSDN's GridView.DataBind Method


The other thing I would try would be:
When ever I'm dealing with GridViews I end up looking them up on MSDN...it's been a while since I've used them.

From what I've read, Response.Write() just injects whatever you put into the current section of the buffer. Which could be inside one of your html elements.
I thought it was supposed to work similar to javascripts' Document.Write(), but I've ehard of it doing funny things with the sending buffer from people.

Response.Write does do funny things.
I sometimes use it when I'm lazy and just want to debug something quickly..but where the output ends up could end up before your html for the page.

You should use a label or something to write debugging stuff...just some of us are lazy ;)

i did that and it still displays but not in gridview. It shows that I have three rows in the part where if numrows and on down . When I debug it it shows system. dataset where the fill command is and then it shows mydataset.Tables = {System.Data.DataTableCollection} at gvResults = (where the datatable is)
then it has the number of rows in if then and then it has the number that i typed inside the text box also in the else then it through the loop 23 times before displaying it. and then finally it shows at gridview1.DataSource = Nothing
after the if statements ends when its highlighted then after highlightended is gone is shows mydataset = {System.Data.DataSet}

so does that mean anything to you

When you are debugging...you will move from line to line....the line of code is not executed until you move to the next line in debugging.

That is why the DataSource is nothing when its highlighted...and then is set when it's moved to the next line.

Please remember that you are not setting the DataSource of the GridView in your loop....you set it afterwards....

when i do the debug it still says nothing in the gridview where it states gridview1.datasource = new data.dataview(gvResults)

Well we know that you have filled your DataSet correctly...and that it's just a matter of getting that data to show in your GridView.

Take a look at MSDN's GridView.DataBind Method


The other thing I would try would be:

Expand|Select|Wrap|Line Numbers

1.    1.
2.       Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
3.               Dim myconnection As OdbcConnection
4.               Dim myCommand As OdbcDataAdapter
5.               Dim mydataset As New DataSet
6.               Dim gvResults As DataTable
7.               Dim loop1 As Integer
8.               Dim numrows As Integer
9.               Dim mysql As String
10.               Dim Order As Integer
11.               Order = CInt(txtOrderNumber.Text)
12.               mysql = "select  line#, ordno, quano, quana, quans, c2rdt, unitm, prdno, actsp  from rmsfiles2.obcop200 where ordno = " & Order
13.               myconnection = New OdbcConnection("DRIVER=Client Access ODBC Driver (32-bit);UID=ODBC;PWD=XXXXXX;System=xxx.xxx.xxx.xxx")
14.               myCommand = New OdbcDataAdapter(mysql, myconnection)     
15.               myCommand.Fill(mydataset, "OBCOP200")
16.  
17.               gvResults = New DataTable
18.               gvResults = mydataset.Tables(0)
19.               numrows = gvResults.Rows.Count
20.  
21.               If numrows = 0 Then
22.                   txtOrderNumber.Text = "Order#" & txtOrderNumber.Text & " invalid order number"
23.  
24.               Else
25.                   txtOrderNumber.Text = ""
26.            gridview1.DataSource = new Data.DataView(gvResults) 'mydataset.Tables("OBCOP200").DefaultView
27.               gridview1.DataBind()
28.               gridview1.Visible = True
29.  
30.            End If

When ever I'm dealing with GridViews I end up looking them up on MSDN...it's been a while since I've used them.

I suggest following the example from MSDN only instead of using the Microsoft SQL Database code, use your AS400 database code:

when i do the debug it still says nothing in the gridview where it states gridview1.datasource = new data.dataview(gvResults)

Do I need to make an app code then within a dataset with my data that I need because right now the getdata is underlined. Also How do I call the function into the submit button?

How do I call the function inside the button click and do I need to make app code with dataset in it

Do I need to make an app code then within a dataset with my data that I need because right now the getdata is underlined.

No you don't...
The reason GetData is underlined is because you probably didn't create that function.

In the example the GetData gets the DataSet and returns it.
Did you create this Function?

You do not need to make another VB file to hold this code....if that's what you're asking.

Could you please post what your code looks like now?

Also How do I call the function into the submit button?

It's the same sort of thing...
In the Sub that handles the button click you create a data source for the GridView and then Bind the GridView to that data source.

page load code
button code
here is my function code:

No you don't...
The reason GetData is underlined is because you probably didn't create that function.

In the example the GetData gets the DataSet and returns it.
Did you create this Function?

You do not need to make another VB file to hold this code....if that's what you're asking.

Could you please post what your code looks like now?



It's the same sort of thing...
In the Sub that handles the button click you create a data source for the GridView and then Bind the GridView to that data source.

This part right here is underlined like its wrong
If (mydataset > 0) Then

No you don't...
The reason GetData is underlined is because you probably didn't create that function.

In the example the GetData gets the DataSet and returns it.
Did you create this Function?

You do not need to make another VB file to hold this code....if that's what you're asking.

Could you please post what your code looks like now?



It's the same sort of thing...
In the Sub that handles the button click you create a data source for the GridView and then Bind the GridView to that data source.

This part right here is underlined like its wrong
If (mydataset > 0) Then

yes that is wrong. .

you have to check the rows count to be > 0

it would be

If (mydataset.tables(0).rows.count > 0) then


hope this helps.

samir

Now its says under the function getData code is the order = cint(txtOrderNumber.text) is invalidcastexception was unhandled by user code and conversion from string to type integer is not valid

What should I do here?

There is no need to grab the DataSet in the Page Load method because your user has probably not supplied an OrderNumber until they hit the button....

This is probably why you're getting that exception about casting...you're probably trying to cast an empty string into an integer.


The whole point to making the GetData function is so that you can get the DataSet from anywhere in code and not have to retype everything again.


Why do you have a Return on line 28 in this section of code?

I'm going to repeat myself here but...the whole point to the GetData Function is so that you don't have to retype the call to the database to get the DataSet.

I think you should change your GetData function to:

Function GetData(ByVal mysql As String, ByVal myOrderNumber As Integer)

This way you can check to make sure that the user entered an order number before trying to use it in the database call.

This is just a reminder: Please do not post the IP and Password to your database. This is sensitive information that should not be publicly shared. I have edited it out, but please don't post this information...this is for the safety of your own computer :)

It still doesn't display anything. Here is all my code is aspx.vb part

I've cleaned up your code so that its easier to follow.
Try this and tell me if it works...if it doesn't repost your exact code and we'll have another look.

Oh I see an error...you're not using the myOrderNumber parameter in your search......The code should be:

Guess what it still don't work here is my code again

Guess what it still don't work here is my code again

Are you getting any messages in your txtOrderNumber text box?

Could you please start using [ code] tags?

All you do is type: [ code=vbnet] then paste your code and then type [ /code]
(Please note that I left a space between the [ and the word "code" (or /code)..you have to remove the space to make the code tags work properly).

That'll save me from editing your posts :)
Also there is a comment in your code that contains your IP and Password still....you might want to fix this.

I'm going to look into reasons why this isn't working for you...get back to me about the messages :)

-Frinny

I keep wondering if it has something to do with your DataSet.
Why don't we try using a DataView again?

I've used the following GetData function with my own GridView and it works fine...this should work for you too!

Ok thanks. The number that I typed in the textbox stays their after I hit the submit button. No messages or data is nowhere on that page.

Ok thanks. The number that I typed in the textbox stays their after I hit the submit button. No messages or data is nowhere on that page.

Strange.
I would have expected it to have changed.
Using a Label to display error messages instead of your text box that you use for your input is a good idea :)

Did you try that code with the DataView yet?

So should I replace first name with ordno(factory order) and last name with quano(quantity)

So should I replace first name with ordno(factory order) and last name with quano(quantity)

Expand|Select|Wrap|Line Numbers

1.  
2. Function GetData(ByVal myOrderNumber As Integer) As Data.DataView
3.         Dim dr As Data.DataRow
4.         Dim dt As New Data.DataTable 
5.  
6.             dt.Columns.Add(New Data.DataColumn("First Name", GetType(String)))
7.             dt.Columns.Add(New Data.DataColumn("Last Name", GetType(String)))
8.  
9.             dr = dt.NewRow
10.             dr("First Name") = "first row, first name"
11.             dr("Last Name") = "first row, last name"
12.  
13.             dt.Rows.Add(dr)
14.  
15.             dr = dt.NewRow
16.             dr("First Name") = "second row, first name"
17.             dr("Last Name") = "second row, last name"
18.  
19.             dt.Rows.Add(dr)
20.  
21.         Dim dv As New Data.DataView(dt)
22.         Return dv
23.     End Function
24.  

Just see if this works first...if you get something to appear then try entering other things :)

I don't get anything still no data

How would I use a label for error messages and where do I put the code at

Strange.
I would have expected it to have changed.
Using a Label to display error messages instead of your text box that you use for your input is a good idea :)

Did you try that code with the DataView yet?

How would I use a label for error messages and where do I put the code at

In the Desgin View for your ASPX page:

• Drag a Label object onto it
• Click on the Label and in its properties set it's a name identifying it (eg: lbl_error)

Then when ever you want to display a message in the label, you set it the same way you do your TextBox...

Eg.
Just remember to clear the label every time a page request is made (in your page load set it's text to "") so that you aren't redisplaying old error messages.

Could you please post the ASP code for your GridView for me.
You will find this code in the Source View for you ASPX page...
(post it in [code =html] code tags).

I'm looking for something like the following:

I did this in page load lbl_error.Text = ""
and submit. Is this right lbl_error.Text = "Please supply a valid number"

This of course is in the aspx page

I did this in page load lbl_error.Text = ""
and submit. Is this right lbl_error.Text = "Please supply a valid number"

This of course is in the aspx page...

If you don't supply a number in the txtOrderNumber TextBox and you click the button, then yes you should be getting this message.

The reason you are getting this is because of this section of code:

In this section of code, you are attempting to convert the value found in the txtOrderNumber TextBox into an Integer value. If there is a problem, then the value in the txtOrderNumber Text box was not a number and an exception is thrown. The exception is caught in the Catch portion and the "Please supply a number" message is displayed.

How do I call the function inside the button click and do I need to make app code with dataset in it

I just realized that you do not know how to call a function!
I'm sorry I glanced over this question before.

First of all, a function returns something and a sub does not.

To call a sub or function (a method) from anywhere else in code you simply type its name.

For example say I have a sub called mySub:
And say I want to call this sub from my button click Sub...all I would do is:
If I were to call a Function on the other hand, I'd need to store it's output somewhere. So I need to create a variable in the button click Sub that matches the type that the Function returns and then call the Function...

For Example:
One other thing about Subs and Functions is that you can pass values into them using parameters. Parameters are passed into Subs or Functions through the () part of the Sub or Function..

Private Function MyFunction(ByVal x As Integer) As Integer

(the bolded part is where the parameter is passed in)

A parameter is simply a variable passed into a Sub or Function that is used for some sort of processing within that function....

This is an example of calling a function that expects a paramter:
Does this make sense?

Thats ok. I kind understand. How do I do mine though. As time goes by their will be alot of order numbers so I'm not for sure how to do it.
Here is all my code again.
rry I glanced over this question before.

Also don't I have to have my connection string, data adapter, command and my sql statement somewhere in the code where it knows where to go ?

Also don't I have to have my connection string, data adapter, command and my sql statement somewhere in the code where it knows where to go ?

Eventually you will have to connect to the database to retrieve the data from there and display it in the GridView.

Right now that is not working for you.
You don't seem to be able to have anything appear in your GridView ever....
I was suggesting going right down to a level that I know works and then work your way back up to connecting to the database and displaying the data.

I just wanted to see if your GridView was able to display Any data.
So I sent you a function that should have displayed 2 rows of data the GridView.

Are you saying that you didn't actually try this?
If you have tried it and the GridView showed nothing still...
I'd be concerned with the way your project is set up.
It sounds like the project itself is configured incorrectly and might be the cause to your GridView problem......

But I didn't want to suggest this until we tried something basic.
Like just displaying 2 hard coded rows in the GridView....this way I'd be able to tell if it was as database problem...or a problem with the project.


I'd strongly suggest trying this before we jump to any conclusions.
The following is what I think your code should look like while we are trying this out (this way we can easily start putting your database stuff back in):
Try this if you haven't already....
Get back to me with the results.

-Frinny

Ok I try it. Nothing comes up when I do a number however when I type in name it comes up with please supply a valid number. What should we do