Ask a Question related to ASP.NET Data Grid Control, Design and Development.
-
Brian Lorraine #1
updating datagrid with JOIN query
When making an editable datagrid, I've gotten pretty good and handling the
function I call in the OnUpdateCommand event. I can update a table easily if
the query in the adapter behind the dataset only queries ONE table. I use the
following code to find the row that's being edited:
Dim r As myDataSet2.TimeTableRow
r = MyDataSet22.TimeTable.FindByTimeID(key)
The problem is, when the adapter uses a query that JOINS two tables, even
when I have the primary key defined in the dataset definition, this
"FINDBYXXXXID" method isn't available anymore? Is there any way to update a
datagrid if more than one tables are linked in the data adapter? If so, is
there something I should subtitute for the above lines of code to single out
the row being edited?
Any help, clues, or links are much appreciated...
->B
Brian Lorraine Guest
-
sql join query
Hi, I have a little problem that's driving me nuts, I'm sure there's a simple solution that I'm overlooking. The problem is this (I'm giving... -
Inner Join Query
Hello Everyone, it's been ages since I posted here, but I just don't get table joins. The background, I am working with an Access db. There are... -
Add another join to a query
I need to add to the SELECT item "C.CATEGORY_ID" to the following query (another join?): Category_id is a column of table "blog_categories" which... -
SQL join query help
I have written a forum and am using the following query to search in it: $query="select topics.tid,f_messages.messid from f_messages left join... -
Query, Join on nearest
Hello, I am in a position where i need to create a query where i must join two tables on the nearest value. Imagine i have 2 tables, tbl_Trade...



Reply With Quote

