Data not showing up in DataGrid

Question

bajanpoet 0 Junior Poster in Training

16 Years Ago

Hi guys! Long time no see!

I'm trying to get a datagrid to work, but although when I run it there is no error, nothing appears on the datagrid. Yet, there seems nothing wrong with my code:

SQL = "select * from upload " & _
                      "where field003 like 'P'+'%'+'" & PONo & "' " & _
                      "and field009 like 'Being received' order by field003"

                'Set up connections
                Dim SQLCommand = New SqlCommand(SQL, conn)
                conn.Open()
                Dim da As SqlDataAdapter = New SqlDataAdapter(SQLCommand)
                Dim ds As New DataSet

                da.Fill(ds, SQL)

                'Attach dataset to datagrid
                dgBlowOut.DataSource = da

Thank you for your help:)

vb.net

3 Contributors
23 Replies
198 Views
1 Week Discussion Span
Latest Post 16 Years Ago Latest Post by bajanpoet

dickersonka 104 Veteran Poster

16 Years Ago

If you are using asp.net you need to use bind

dickersonka 104 Veteran Poster

16 Years Ago

try setting the datamember
The dataset can have multiple tables, when you set the datasource you need to specify which table to use

dickersonka 104 Veteran Poster

16 Years Ago

The dataset table, not the sql table

Dim ds As New DataSet("uploads")

....

 dgBlowOut.DataMember = "uploads"

dickersonka 104 Veteran Poster

16 Years Ago

As long as you are sure the the datasource is correct and you can 'ping' the server then you need to configure the sql server to allow tcp ip connections.

Here's some links to show you how
http://www.datamasker.com/SSE2005_SCM1.htm

http://www.datamasker.com/SSE2005_SAC.htm

dickersonka 104 Veteran Poster

16 Years Ago

Hmmm. Something is up with that. Are you running SQL 2000 and SQL 2005 on that machine then?

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

bajanpoet 0 Junior Poster in Training · Answer 1 · 2008-08-21T20:27:25+00:00

Not using asp.net. I'm creating a small desktop application.

bajanpoet 0 Junior Poster in Training · Answer 2 · 2008-08-21T20:41:25+00:00

Setting the datamember to the name of the table?

dgBlowOut.DataMember = "upload" [\code]

When I added that it gave me an error: 'Child list for field upload cannot be created'[code=VB.NET] dgBlowOut.DataMember = "upload"
[\code]

When I added that it gave me an error: 'Child list for field upload cannot be created'

bajanpoet 0 Junior Poster in Training · Answer 3 · 2008-08-21T21:59:22+00:00

I have also realized that in trying to run this application, after a while this error appears:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this error may be caused by the fact that under the default settings SQL Server does not allow remote connections."

I had never seen this error before this time because when I clicked the View button and it did not change the datagrid, I would have closed it immediately..... it came up after about 4 seconds.

Does this help anyone to assist me?

bajanpoet 0 Junior Poster in Training · Answer 4 · 2008-08-21T22:04:27+00:00

the Dataset is using a raw SQL statement that is being stored in a string variable SQL -

SQL = "select field003 as 'PO #',field009 as 'Status' from upload " & _
                      "where field003 like 'P'+'%'+'" & PONo & "' " & _
                      "and field009 like 'Being received' order by field003"
.....

I don't understand what the dataset table is...

bajanpoet 0 Junior Poster in Training · Answer 5 · 2008-08-21T22:09:39+00:00

One more piece of info: Here's the connection string (As the issue seems to be a connection one.

Public Const ConnectionString = "Data Source=SBIDB2SVR;Initial Catalog=rbeacon;User Id=sbiapps;Password=sbiapps123;" [\code][code=VB.NET]
Public Const ConnectionString = "Data Source=SBIDB2SVR;Initial Catalog=rbeacon;User Id=sbiapps;Password=sbiapps123;"
[\code]

bajanpoet 0 Junior Poster in Training · Answer 6 · 2008-08-22T00:27:06+00:00

ok, I'm a little confused as to why it is talking about SQL Server 2005 in the first place; I'm using SQL Server 2000.... I went looking around for where tcp ip connections are either enabled or disabled - and I found it, but it's already enabled for tcp ip!

bajanpoet 0 Junior Poster in Training · Answer 7 · 2008-08-23T00:39:51+00:00

The server is SQL 2000...I am using Visual Basic 2005 Express to code the application. That's the only 2005 thing on my PC.

bajanpoet 0 Junior Poster in Training · Answer 8 · 2008-08-25T19:53:46+00:00

I have changed the connection string username and password and the connection seems to now be working - but now I'm back to the original issue: I can't get the datagrid populated from records using the SQL SELECT statement.

SQL = "select field003 as 'PO #',field009 as 'Status' from upload " & _
                      "where field003 like 'P'+'%'+'" & PONo & "' " & _
                      "and field009 like 'Being received' order by field003"

   'Set up connections
   Dim SQLCommand = New SqlCommand(SQL, conn)
   conn.Open()
   Dim da As SqlDataAdapter = New SqlDataAdapter(SQLCommand)
   Dim ds As New DataSet

   da.Fill(ds, SQL)

   'Attach dataset to datagrid
   dgBlowOut.DataSource = da

When I run it and enter a valid PO number, no records are displayed, but I can see the records when I run the SQL locally using Query Analyzer on my machine.

dickersonka 104 Veteran Poster · Answer 9 · 2008-08-25T19:59:53+00:00

remember the datamember

Dim ds As New DataSet("uploads")

....

 dgBlowOut.DataMember = "uploads"

bajanpoet 0 Junior Poster in Training · Answer 10 · 2008-08-25T20:07:00+00:00

Ok so now I'm trying to understand the Datamember... is the DataSet("Uploads") the NAME of a Dataset? As in that code creates a dataset with a name?

bajanpoet 0 Junior Poster in Training · Answer 11 · 2008-08-25T20:16:02+00:00

Ok I have created a dataset name Uploads and set the datamember using the code given...

Dim ds As New DataSet("Uploads")
....
dgBlowOut.DataMember = "Uploads"

and now I get this error

"Child list for field Uploads cannot be created."

Ok so now I'm trying to understand the Datamember... is the DataSet("Uploads") the NAME of a Dataset? As in that code creates a dataset with a name?

dickersonka 104 Veteran Poster · Answer 12 · 2008-08-25T20:19:06+00:00

Yes, that is the name of dataset. The problem seems to be that it doesn't know what table to use.
The dataset 'can' have multiple tables, and the datagrid doesn't know what to get its records from.

Check out these links for more clarification.

http://msdn.microsoft.com/en-us/library/system.windows.forms.datagrid.datasource.aspx

http://msdn.microsoft.com/en-us/library/ms810286.aspx

dickersonka 104 Veteran Poster · Answer 13 · 2008-08-25T20:21:19+00:00

You might be able to do it generically and set

dgBlowOut.DataMember = ds.Tables[0].TableName

bajanpoet 0 Junior Poster in Training · Answer 14 · 2008-08-27T20:31:49+00:00

You might be able to do it generically and set
dgBlowOut.DataMember = ds.Tables[0].TableName

When I tried that I got this error: value of type 'System.Data.DataTableConnection' cannot be converted to string.

dickersonka 104 Veteran Poster · Answer 15 · 2008-08-27T20:37:14+00:00

I don't think its DataTableConnection. TableName and DataMember are both string types, make sure you have '.TableName' at the end

bajanpoet 0 Junior Poster in Training · Answer 16 · 2008-08-27T20:43:42+00:00

I don't think its DataTableConnection. TableName and DataMember are both string types, make sure you have '.TableName' at the end

I do. Here's the code I put in:

dgBlowOut.DataMember = ds.Tables[0].TableName

There is a blue line under ds.Tables and another one under [0] Putting my mouse over the ds.Tables gives the 'Value of type ... ' error, putting the mouse under the 0 gives the error 'identifier expected'

destino 0 Newbie Poster · Answer 17 · 2008-08-30T10:34:41+00:00

Hi guys! Long time no see!

I'm trying to get a datagrid to work, but although when I run it there is no error, nothing appears on the datagrid. Yet, there seems nothing wrong with my code:

SQL = "select * from upload " & _
                      "where field003 like 'P'+'%'+'" & PONo & "' " & _
                      "and field009 like 'Being received' order by field003"

                'Set up connections
                Dim SQLCommand = New SqlCommand(SQL, conn)
                conn.Open()
                Dim da As SqlDataAdapter = New SqlDataAdapter(SQLCommand)
                Dim ds As New DataSet

                da.Fill(ds, SQL)

                'Attach dataset to datagrid
                dgBlowOut.DataSource = da

Thank you for your help:)

You say that the app works with no errors but there is no data in the datagrid. Have you considered that your query may not be returning any data. If the underlying data does not match the query. Everything may be working correctly.

Try "SELECT * from upload" as a test. Alternatively run the query in access or enterprise manager

bajanpoet 0 Junior Poster in Training · Answer 18 · 2008-09-02T06:49:57+00:00

You say that the app works with no errors but there is no data in the datagrid. Have you considered that your query may not be returning any data. If the underlying data does not match the query. Everything may be working correctly.
Try "SELECT * from upload" as a test. Alternatively run the query in access or enterprise manager

Thanks for the suggestion, Destino....
It's been working in Query Analyzer - I know the query brings results, as it is a business script that is used to select and delete purchase orders from time to time as requested by the Inventory department. The same script that does not show results in the datagrid shows results when I run it in Query Analyzer with the same input.