Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markyjj
Starting Member
8 Posts |
 Posted - 2008-08-24 : 10:28:58
|
| Can someone please help me with the following problem because I am now at my witts end with this program. I am trying to update a Sql database through a datgrid through a 'Save & Update button' but I get the following exception' Update unable to find TableMapping['MovTable1'] or DataTable 'MovTable1'.I have tried creating a command builder and a Table map but I still get the same exception and I am now in need of help. The code I am using is below. Many thanks//Main Formusing System;using System.Drawing;using System.Collections;using System.ComponentModel;using System.Windows.Forms;using System.Data;using System.Data.SqlClient;namespace MovieBase1{ /// <summary> /// Summary description for Form1. /// </summary> public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.Button button1; private System.Windows.Forms.Button button2; private System.Windows.Forms.Button button3; private System.Windows.Forms.Button button4; private System.Windows.Forms.Button button5; private System.Windows.Forms.Button button6; private System.Windows.Forms.Label label1; /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.Container components = null; public DataSet Movset1 = new DataSet(); public static SqlConnection Mcon = new SqlConnection("workstation id=SHERMAN2;packet size=4096;integrated security=SSPI;data source=\"SH" + "ERMAN2\\SQLEXPRESS\";persist security info=True;initial catalog=MDatabase"); public SqlCommand Movcmd = Mcon.CreateCommand(); private System.Windows.Forms.Button button7; public SqlDataAdapter MovAdapt = new SqlDataAdapter(); public Form1() { // // Required for Windows Form Designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // } /// <summary> /// Clean up any resources being used. /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.button1 = new System.Windows.Forms.Button(); this.button2 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button(); this.button4 = new System.Windows.Forms.Button(); this.button5 = new System.Windows.Forms.Button(); this.button6 = new System.Windows.Forms.Button(); this.label1 = new System.Windows.Forms.Label(); this.button7 = new System.Windows.Forms.Button(); this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(304, 72); this.button1.Name = "button1"; this.button1.TabIndex = 0; this.button1.Text = "Delete Film"; this.button1.Click += new System.EventHandler(this.button1_Click); // // button2 // this.button2.Location = new System.Drawing.Point(328, 120); this.button2.Name = "button2"; this.button2.TabIndex = 1; this.button2.Text = "Current Movie Count"; this.button2.Click += new System.EventHandler(this.button2_Click); // // button3 // this.button3.Location = new System.Drawing.Point(336, 168); this.button3.Name = "button3"; this.button3.TabIndex = 2; this.button3.Text = "Movie List"; this.button3.Click += new System.EventHandler(this.button3_Click); // // button4 // this.button4.Location = new System.Drawing.Point(336, 208); this.button4.Name = "button4"; this.button4.TabIndex = 3; this.button4.Text = "Exit"; this.button4.Click += new System.EventHandler(this.button4_Click); // // button5 // this.button5.Location = new System.Drawing.Point(336, 264); this.button5.Name = "button5"; this.button5.TabIndex = 4; this.button5.Text = "button5"; this.button5.Click += new System.EventHandler(this.button5_Click); // // button6 // this.button6.Location = new System.Drawing.Point(328, 16); this.button6.Name = "button6"; this.button6.TabIndex = 5; this.button6.Text = "Add Film"; this.button6.Click += new System.EventHandler(this.button6_Click); // // label1 // this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.label1.Location = new System.Drawing.Point(32, 16); this.label1.Name = "label1"; this.label1.TabIndex = 6; this.label1.Text = "Movie Base"; // // button7 // this.button7.Location = new System.Drawing.Point(80, 152); this.button7.Name = "button7"; this.button7.Size = new System.Drawing.Size(168, 23); this.button7.TabIndex = 7; this.button7.Text = "button7"; this.button7.Click += new System.EventHandler(this.button7_Click); // // Form1 // this.AccessibleDescription = "public"; this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(432, 366); this.Controls.Add(this.button7); this.Controls.Add(this.label1); this.Controls.Add(this.button6); this.Controls.Add(this.button5); this.Controls.Add(this.button4); this.Controls.Add(this.button3); this.Controls.Add(this.button2); this.Controls.Add(this.button1); this.Name = "Form1"; this.Text = "Form1"; this.ResumeLayout(false); } #endregion /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main() { Application.Run(new Form1()); } private void button6_Click(object sender, System.EventArgs e) { MessageBox.Show("under construction"); } private void button1_Click(object sender, System.EventArgs e) { MessageBox.Show("under construction"); } private void button2_Click(object sender, System.EventArgs e) { MessageBox.Show(" under constructiion "); } private void button3_Click(object sender, System.EventArgs e) { Form3 F3 = new Form3(); Mcon.Open(); SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(MovAdapt); Movcmd.CommandText = "SELECT * FROM MovTable1"; MovAdapt.SelectCommand = Movcmd; MovAdapt.Fill(Movset1, "MovTable1"); F3.dataGrid1.DataSource = Movset1; F3.Show(); } private void button4_Click(object sender, System.EventArgs e) { this.Close(); } private void button5_Click(object sender, System.EventArgs e) { MessageBox.Show("under construction"); } private void button7_Click(object sender, System.EventArgs e) { } }}---------------------//2nd form with Save & Update buttonDataTable MovTable1 = new DataTable(); F1.Movset1.Tables.Add(MovTable1); F1.MovAdapt.TableMappings.Add( "Table", "MovTable1" ); F1.MovAdapt.Update(F1.Movset1,"MovTable1"); Form1.Mcon.Close(); |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
|
|
UNABLE TO FIND TABLEMAPPING!!