473,387 Members | 1,483 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

update unable to find table mapping or data table

Hi Team,

While am using the below code it was throwing an exception update unable to find table mapping [Customer] or data table customer. Please help me in this regard.

Expand|Select|Wrap|Line Numbers
  1. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  2.         Try
  3.             con.Open()
  4.             param.ParameterName = "@uname"
  5.             param.ParameterName = "@uid"
  6.             param.ParameterName = "@uprod"
  7.             param.ParameterName = "@uprice"
  8.             param.ParameterName = "@udop"
  9.             param.ParameterName = "@utot"
  10.             param.Value = TextBox1.Text
  11.             cmd.Parameters.AddWithValue("@uname", TextBox2.Text)
  12.             cmd.Parameters.AddWithValue("@uid", TextBox1.Text)
  13.             cmd.Parameters.AddWithValue("@uprod", TextBox3.Text)
  14.             cmd.Parameters.AddWithValue("@uprice", TextBox4.Text)
  15.             cmd.Parameters.AddWithValue("@utot", TextBox5.Text)
  16.             'cmd.Parameters.AddWithValue("@uname", datetimepicker1.
  17.             cmd = New SqlCommand("insert into customer(custid,custname,product,price,total)values(@uid,@uname,@uprod,@uprice,@utot)", con)
  18.             da = New SqlDataAdapter(cmd)
  19.             da.Update(ds, "customer")
  20.             MsgBox("inserted...")
  21.  
  22.  
  23.         Catch ex As Exception
  24.             MsgBox(ex.Message.ToString)
  25.         End Try
  26.         con.Close()
May 22 '10 #1
0 1573

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: chris.ciotti | last post by:
Greetings - I'm using an Access front end to a SQL Server (2000) databas­e. Via several steps, I create a temp table and manipulate the data­ in it. I want to update the backend with this...
10
by: mike | last post by:
regards: Where to find tag mapping-table of HTML translated to XHTML1.0 Any positive suggestion is welcome. thank you May goodness be with you all
2
by: G.W. Lucas | last post by:
I apologize if this is a RTFM question, but I have not been able to find a definitive answer elsewhere. Does a "REINDEX TABLE" lock the table while it is working? Can applications write data to...
0
by: Bob | last post by:
Background 1. I create a data table that has one primary key and one unique column with other columns as well 2. I then Bind it to my list countrol setting the DataSource to my table name and...
1
by: xaime | last post by:
Hi all, I have the code below. This is doing what I want, but always has the following exception: Update unable to find TableMapping or Datatable 'mytable' The code I'm using is: Try
0
by: John | last post by:
Hi I am trying to store data returned form a web service into a local access table. The problem is that I am getting an "Update unable to find TableMapping or DataTable 'Table'" error on the...
3
by: Yakimo | last post by:
Hi I am trying to append some records form tmpSource to tmpDest table using datasets Tables tmpSourec and tmpDest are identical. My setup is the following: - daSource - data adapter for...
1
by: pramodrepaka | last post by:
Hello Guys Plz Help me Here is my problem . Unable to retriew the data beteen oracle and vb by using ADODC control i.e if a table consists of Nll values. i am created table...
1
by: corsibu | last post by:
hello , i just wanted to ask if there's anyone who could help me do the following thing : i have an empty temporary table, this table will have a row filled with data grabbed by a querry at this...
7
by: sathyashrayan | last post by:
Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.