Refresh Datagrid

I'm struglling to find info on refreshing a datagrid, I'm using Sql server,
the datagrid is based on several tables, when changes have been made to the
data (NOT DONE WITHIN THE DATAGRID ITSELF - only used for viewing and
selecting purposes) I want to be able to refresh the datagrid with the added
records, I've tried various methods with no success, begiining to wonder if
the onmly way of doing it is to run teh query again and then set the
datasource = to same again or is there a more convenient way?

To make it more clearer this is the main part of the code I used to get the
original data, any suggestion greatly appreciated

gConnection = New SqlClient.SqlConnection(gConnString)
sSQL = "Select j.id as ID," & _
"j.description as Description," & _
"e.name as Employee,tp.description as Priority, " & _
"tj.description as Status," & _
"CONVERT(CHAR(11),datelogged,106) as DateLogged ," & _
"j.notes as Notes from Jobs j " & _
"inner join Employees e on e.id = j.employeeid " & _
"inner join Type_JobStatus tj on tj.id = j.status " & _
"inner join Type_Priority tp on tp.id = j.priorityid" & _
" order by j.id"
Dim da As SqlClient.SqlDataAdapter = New _
SqlClient.SqlDataAdapter(sSQL, _
gConnection)

da.Fill(ds, "Jobs")

dgJobs.DataSource = ds.Tables("Jobs")
dgJobs.SetDataBinding(ds, "Jobs")

Have got it working the way I want now with the following addition
I had to change the scope of the datasource and datadapter to get this to
work, hope this may be helpful to somebody.

Private Sub Refresh Data
ds.Clear()
da.Fill(ds, "Jobs")
dgJobs.DataSource = ds.Tables("Jobs")

End Sub

If anybody else knows of a neater way of doing this then that would be great
however.


"vbdotnetmania" wrote:

 > I'm struglling to find info on refreshing a datagrid, I'm using Sql server,
 > the datagrid is based on several tables, when changes have been made to the
 > data (NOT DONE WITHIN THE DATAGRID ITSELF - only used for viewing and
 > selecting purposes) I want to be able to refresh the datagrid with the added
 > records, I've tried various methods with no success, begiining to wonder if
 > the onmly way of doing it is to run teh query again and then set the
 > datasource = to same again or is there a more convenient way?
 >
 > To make it more clearer this is the main part of the code I used to get the
 > original data, any suggestion greatly appreciated
 >
 > gConnection = New SqlClient.SqlConnection(gConnString)
 > sSQL = "Select j.id as ID," & _
 > "j.description as Description," & _
 > "e.name as Employee,tp.description as Priority, " & _
 > "tj.description as Status," & _
 > "CONVERT(CHAR(11),datelogged,106) as DateLogged ," & _
 > "j.notes as Notes from Jobs j " & _
 > "inner join Employees e on e.id = j.employeeid " & _
 > "inner join Type_JobStatus tj on tj.id = j.status " & _
 > "inner join Type_Priority tp on tp.id = j.priorityid" & _
 > " order by j.id"
 > Dim da As SqlClient.SqlDataAdapter = New _
 > SqlClient.SqlDataAdapter(sSQL, _
 > gConnection)
 >
 > da.Fill(ds, "Jobs")
 >
 > dgJobs.DataSource = ds.Tables("Jobs")
 > dgJobs.SetDataBinding(ds, "Jobs")<!-- ~MESSAGE_AFTER~ -->