Hello everybody, I would like to know if someone can help me with a DataSet.
In my case the select command that fills the DataSet is a view (sql2000)
that contains 10 tables, I have defined the SQLDataAdapter as follows:
Dim SqlAdapter As New SqlDataAdapter("SELECT * FROM vw_DG_PERSONAS", SqlCon)
En evento Load del Frm tengo esto:
SqlCon.ConnectionString = "Server=" & Svr & _
";Database=dgcontrol;uid=" & Usr & ";pwd=" & Psw & ";"
SqlAdapter.Fill(DsPersonas, "vw_DG_PERSONAS")
SqlCon.Close()
DataGrid1.DataSource = DsPersonas
DataGrid1.DataMember = "tbl_per_personas"
My problem is that the window has a DataGrid that shows the view, and I
modify the data, then I want to save the changes to the SQL DB, so
I do the following:
SqlAdapter.Update(DsPersonas), and here this error occurs:
(Update can not find TableMApping('Table') o DataTable 'Table')
Please i someone can help me on working with DataSet, just tell me, Thanks. 2 1994
Well, I think Adapters update tables and not dataset so maybe you would need
to specify the table in the database to update.
"Fabian" <kj***@dd.com> wrote in message
news:u4**************@TK2MSFTNGP11.phx.gbl... Hello everybody, I would like to know if someone can help me with a
DataSet. In my case the select command that fills the DataSet is a view (sql2000) that contains 10 tables, I have defined the SQLDataAdapter as follows: Dim SqlAdapter As New SqlDataAdapter("SELECT * FROM vw_DG_PERSONAS",
SqlCon)
En evento Load del Frm tengo esto: SqlCon.ConnectionString = "Server=" & Svr & _ ";Database=dgcontrol;uid=" & Usr & ";pwd=" & Psw & ";" SqlAdapter.Fill(DsPersonas, "vw_DG_PERSONAS") SqlCon.Close() DataGrid1.DataSource = DsPersonas DataGrid1.DataMember = "tbl_per_personas"
My problem is that the window has a DataGrid that shows the view, and I modify the data, then I want to save the changes to the SQL DB, so I do the following:
SqlAdapter.Update(DsPersonas), and here this error occurs: (Update can not find TableMApping('Table') o DataTable 'Table')
Please i someone can help me on working with DataSet, just tell me,
Thanks.
Fabian,
SqlAdapter.Update(DsPersonas, "Table") -or-
SqlAdapter.Update(DsPersonas, <index of table>)
Hope this helps.
Brad
"Fabian" <kj***@dd.com> wrote in message
news:u4**************@TK2MSFTNGP11.phx.gbl... Hello everybody, I would like to know if someone can help me with a
DataSet. In my case the select command that fills the DataSet is a view (sql2000) that contains 10 tables, I have defined the SQLDataAdapter as follows: Dim SqlAdapter As New SqlDataAdapter("SELECT * FROM vw_DG_PERSONAS",
SqlCon)
En evento Load del Frm tengo esto: SqlCon.ConnectionString = "Server=" & Svr & _ ";Database=dgcontrol;uid=" & Usr & ";pwd=" & Psw & ";" SqlAdapter.Fill(DsPersonas, "vw_DG_PERSONAS") SqlCon.Close() DataGrid1.DataSource = DsPersonas DataGrid1.DataMember = "tbl_per_personas"
My problem is that the window has a DataGrid that shows the view, and I modify the data, then I want to save the changes to the SQL DB, so I do the following:
SqlAdapter.Update(DsPersonas), and here this error occurs: (Update can not find TableMApping('Table') o DataTable 'Table')
Please i someone can help me on working with DataSet, just tell me,
Thanks.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bill C. |
last post by:
Hi,
I've got a simple console app that just reads an XML file into a DataSet
then prints out a description of each table in the DataSet, including
column names and row values for each column. ...
|
by: Jeronimo Bertran |
last post by:
Hi,
I have an xml file that encapsulates a dataset definition within a set
of tags (<dataset>)... here is an example
<?xml version="1.0" encoding="utf-16"?>
<dataset>
<MyTable>...
|
by: Mike |
last post by:
I need to expand the DataSet class by inheriting from it and adding
functions that work on the data in the tables. However, since I can't
upcast how can I get my base DataSet object assigned an...
|
by: JJ |
last post by:
Hi,
I need to pass a dataset to another win form along with a SqldataAdapter.
I don't want to recreate the SqlDataAdapter again either. So to pass to
another Win form in my windows form app, do...
|
by: Jason |
last post by:
I am having problems understanding how to access a datasource only
once, fill a single dataset, and then reference that dataset multiple
times through different user controls(ascx) found on the...
|
by: John Holmes |
last post by:
I have a web interface where the user types in ID's one at a time. After an
ID is typed in, a button is clicked and the button click event has code that
does a query and returns a data reader and...
|
by: JIM.H. |
last post by:
Hello,
Can I send a dataset as a parameter into stored procedure and import data to
a table in the stored procedure?
Thanks,
Jim.
|
by: Geoff Jones |
last post by:
Hi
Can anybody help me with the following, hopefully simple, question?
I have a table which I've connected to a dataset. I wish to add a new column
to the beginning of the table
and to fill...
|
by: Arne |
last post by:
How do I pass a dataset to a webservices? I need to submit a shoppingcart
from a pocket PC to a webservice.
What is the right datatype?
II have tried dataset as a datatype, but I can't get it to...
|
by: matt |
last post by:
hello,
i have a web app that allows users to query our oracle db and produce a
dataset of report data. they then have the option to serialize this
data and store it in the database. later, then...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |