Updating DataGrid

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I have two grids on a form. Contacts and Notes. For
each contact there can be many notes.

When I click on a contact (which is bound to the contact
table) I want to fill the notes grid and I use the
following code:

Dim cmdstring As String = "Select [date], [time],
endtime, [desc], con_id from Notes where con_id = '" &
Label3.Text & "'"
Dim da As New SqlClient.SqlDataAdapter

Dim ds As New DataSet

Dim daNotes1 As New SqlClient.SqlDataAdapter
(cmdstring, Me.SqlConnection2)
daNotes1.Fill(ds, "Notes")

Me.DG_Notes.DataSource = daNotes1
Me.DG_Notes.DataMember = "Notes"



But when I run the code I get an "unhandled error" on the
daNotes1.Fill line.

I took the cmdstring and put it into SQL Enterprise
manager and ran the query. Data was returned. Why is
this not filling the grid?

Any help would be appreciated.

Thanks

Gary
 
Hi Gary

I would suspect whether Me.SqlConnection2 is established or not

Bin Song, MC

----- Gary wrote: ----

I have two grids on a form. Contacts and Notes. For
each contact there can be many notes

When I click on a contact (which is bound to the contact
table) I want to fill the notes grid and I use the
following code

Dim cmdstring As String = "Select [date], [time],
endtime, [desc], con_id from Notes where con_id = '" &
Label3.Text & "'
Dim da As New SqlClient.SqlDataAdapte

Dim ds As New DataSe

Dim daNotes1 As New SqlClient.SqlDataAdapte
(cmdstring, Me.SqlConnection2
daNotes1.Fill(ds, "Notes"

Me.DG_Notes.DataSource = daNotes
Me.DG_Notes.DataMember = "Notes



But when I run the code I get an "unhandled error" on the
daNotes1.Fill line

I took the cmdstring and put it into SQL Enterprise
manager and ran the query. Data was returned. Why is
this not filling the grid

Any help would be appreciated

Thank

Gar
 
Hi Bin,

I just verified the connection to SqlConnection2 and it
works. I did a "Test Connection" and everything is OK.

Thanks

Gary
 
Hi Gary

Did you hand-coded the SqlConnection or created by drag and drop? Are you creating a windows app or web app? And where is your SQL Server, local or on the network

Bin Song, MCP


----- Gary wrote: ----

Hi Bin

I just verified the connection to SqlConnection2 and it
works. I did a "Test Connection" and everything is OK

Thank

Gar

-----Original Message----
Hi Gary
I would suspect whether Me.SqlConnection2 is established or not
Bin Song, MC
----- Gary wrote: ----
I have two grids on a form. Contacts and Notes.
Click to expand...
For
each contact there can be many notes
When I click on a contact (which is bound to the
Click to expand...
contact
table) I want to fill the notes grid and I use the
following code
Dim cmdstring As String = "Select [date], [time],
Click to expand...
endtime, [desc], con_id from Notes where con_id = '" &> Label3.Text & "'
Dim da As New SqlClient.SqlDataAdapte
Dim ds As New DataSe
Dim daNotes1 As New SqlClient.SqlDataAdapte
Click to expand...
(cmdstring, Me.SqlConnection2
daNotes1.Fill(ds, "Notes"
Me.DG_Notes.DataSource = daNotes
Click to expand...
Me.DG_Notes.DataMember = "Notes on the
daNotes1.Fill line
I took the cmdstring and put it into SQL Enterprise
Click to expand...
manager and ran the query. Data was returned. Why is
this not filling the grid
Any help would be appreciated
Thank
Gar
Click to expand...
Click to expand...
 
Bin,

I did some more checking and the SqlConnection was
created by drag and drop. AFter playing around I found
that the database owner was not "sa" but "sa" was in the
connection string so I replaced it. Now it gets further
but stops on the following line:

Me.DG_Notes.DataSource = daNotes1

The error I now get is :complex databinding accepts as a
data source either an Ilist or IListSource.

What am I doing wrong?


Thanks,

Gary
-----Original Message-----
Hi Gary,

Did you hand-coded the SqlConnection or created by drag
Click to expand...
and drop? Are you creating a windows app or web app? And
where is your SQL Server, local or on the network?
Bin Song, MCP


----- Gary wrote: -----

Hi Bin,

I just verified the connection to SqlConnection2 and it
works. I did a "Test Connection" and everything is OK.
Thanks

Gary


-----Original Message-----
Hi Gary,
Click to expand...
established
or not. Notes.
For
each contact there can be many notes.
Click to expand...
the
contact
table) I want to fill the notes grid and I use the
following code:
Dim cmdstring As String = "Select [date],
Click to expand...
[time],
endtime, [desc], con_id from Notes where
Click to expand...
con_id
= '" &> Label3.Text & "'"
Dim da As New SqlClient.SqlDataAdapter SqlClient.SqlDataAdapter
(cmdstring, Me.SqlConnection2)
daNotes1.Fill(ds, "Notes")
Me.DG_Notes.DataMember = "Notes"
Click to expand...
an "unhandled error"
on the
daNotes1.Fill line. Enterprise
manager and ran the query. Data was
Click to expand...
returned. Why
is
this not filling the grid?
Click to expand...
.
Click to expand...
 
You cannot bind to a DataAdapter only descendants of Ilist or IListSource. A
DataSet/DataTable is what you want to set the DataSource to here:

Me.DG_Notes.DataSource = ds.NOTES;

Bin,

I did some more checking and the SqlConnection was
created by drag and drop. AFter playing around I found
that the database owner was not "sa" but "sa" was in the
connection string so I replaced it. Now it gets further
but stops on the following line:

Me.DG_Notes.DataSource = daNotes1

The error I now get is :complex databinding accepts as a
data source either an Ilist or IListSource.

What am I doing wrong?


Thanks,

Gary
-----Original Message-----
Hi Gary,

Did you hand-coded the SqlConnection or created by drag
Click to expand...
and drop? Are you creating a windows app or web app? And
where is your SQL Server, local or on the network?
Bin Song, MCP


----- Gary wrote: -----

Hi Bin,

I just verified the connection to SqlConnection2 and it
works. I did a "Test Connection" and everything is OK.
Thanks

Gary


-----Original Message-----
Hi Gary,
I would suspect whether Me.SqlConnection2 is
Click to expand...
established
or not.
Bin Song, MCP
----- Gary wrote: -----
I have two grids on a form. Contacts and
Click to expand...
Notes.
For
each contact there can be many notes.
When I click on a contact (which is bound to
Click to expand...
the
contact
table) I want to fill the notes grid and I use the
following code:
Dim cmdstring As String = "Select [date], [time],
endtime, [desc], con_id from Notes where
Click to expand...
con_id
= '" &> Label3.Text & "'"
Dim da As New SqlClient.SqlDataAdapter
Dim ds As New DataSet
Dim daNotes1 As New SqlClient.SqlDataAdapter
(cmdstring, Me.SqlConnection2)
daNotes1.Fill(ds, "Notes")
Me.DG_Notes.DataSource = daNotes1
Me.DG_Notes.DataMember = "Notes"
But when I run the code I get
Click to expand...
an "unhandled error"
on the
daNotes1.Fill line.
I took the cmdstring and put it into SQL Enterprise
manager and ran the query. Data was
Click to expand...
returned. Why
is
this not filling the grid?
Any help would be appreciated.
Thanks
Gary
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top