|
I've also problems with MySQL and updating two tables (parent / child relation) error: #23000Column 'products_id' cannot be null. hmmm..
|
|
|
|
|
Thank you for the article - I've been searching for ages to find an article on inserting relational data.....
Cheers,
Tim
|
|
|
|
|
I have managed to replicate the functionality of the model in VB.Net except for the Event Handler Code. The code I have is listed here:
Friend WithEvents oOrdersDataAdapter As OleDb.OleDbDataAdapter
Private Sub OrdersDataAdapter_OnRowUpdate(ByVal sender As System.Object, ByVal e As OleDb.OleDbRowUpdatedEventArgs) Handles oOrdersDataAdapter
Dim oCmd As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT @@IDENTITY", e.Command.Connection)
e.Row("OrderId") = oCmd.ExecuteScalar()
e.Row.AcceptChanges()
End Sub
However, I cannot find the equivalence in VB.Net to the C# statement
'oOrdersDataAdapter.RowUpdated += new OleDbRowUpdatedEventHandler(OrdersDataAdapter_OnRowUpdate)
Any Thoughts?
|
|
|
|
|
Hi Jerry, thanks for your reply !
There are two ways you can accomplish this.
1) Since you declare the DataAdapter in a class scope, you can use the Handles clause after the function, but don't forget to inform the event you want to handle (I notice that it doesn't appear in your example). Here is the correct implementation
Private Sub OrdersDataAdapter_OnRowUpdate(ByVal sender As System.Object, ByVal e As OleDb.OleDbRowUpdatedEventArgs) Handles oOrdersDataAdapter.RowUpdated
2) You can use the AddHandler clause, passing the event and the handling function as a parameter. Here is an example:
AddHandler(oDA.RowUpdated, AddressOf OrdersDataAdapter_OnRowUpdate)
Hope this helps !
cheers,
Maurício Ritter
Mauricio Ritter - Brazil
MSN: mauricioritter(atsign)hotmail.com
English is not my native language so, if you find any spelling erros in my posts, please let me know.
|
|
|
|
|
This is an excellent article and has helped me overcome a serious problem I had been facing.
I have a question about a problem that I am having. I am using SQL with the SELECT command approach, but I have multiple nested data. IE.
NewDataSet
Table1
Table1ID
Data
Table2
Table2ID
Table1ID
Data
Table3
Table3ID
Table2ID
Data
When I attempt an update where table2 creates new record, none of the items in table 3 get created due to a missing ID from table2. However, there is no problem with table2. I was under the impression that the update calls AcceptChanges as the last step in performing an update via the DataAdapter. However, I never get the ID for Table2ID. Any ideas what I'm doing wrong?
|
|
|
|
|
I Had a simalar situation, I found that the event handler needed modifing.
I found that the the command "Select @@identity" only works when an insert into table command command is issued, but on an update command it returns "0"
I changed the code to that shown below
private void OnRowUpdated(object sender, OleDbRowUpdatedEventArgs e)
{
if(e.Command == this.oleDbInsertCommand1)
{
OleDbCommand cmd = new OleDbCommand("SELECT @@IDENTITY",
e.Command.Connection) ;
e.Row["TrnNumber"] = cmd.ExecuteScalar() ;
e.Row.AcceptChanges() ;
}
}
I used a visual studio generated class whisc created seperate commands for insert, delete and update.
|
|
|
|
|
Well written and very information. Also, your English is very good! Better than a lot of native English speakers that I know
This space for rent!
My Blog
|
|
|
|
|
I haven't tried the code yet, but is there going to be any concurrency issue during INSERT's? In particular, selecting @@IDENTITY happens after INSERT statement, and it isn't wrapped inside a transaction (meaning more INSERT statements could have been executed by other clients before the event handler is invoked and @@IDENTITY is retrieved):
static void OrdersDataAdapter_OnRowUpdate(object sender,
OleDbRowUpdatedEventArgs e)
{
OleDbCommand oCmd = new OleDbCommand("SELECT @@IDENTITY"
e.Command.Connection);
e.Row["OrderId"] = oCmd.ExecuteScalar();
e.Row.AcceptChanges();
}
Anyone has anything to say in this regards?
Norman Fung
|
|
|
|
|
norm wrote:
meaning more INSERT statements could have been executed by other clients before the event handler is invoked and @@IDENTITY is retrieved):
There is no such a risk, because the @@IDENTITY property have a Connection scope, it shows the last IDENTITY used in your connection, not in other connections.
Mauricio Ritter - Brazil
MSN: mauricioritter(atsign)hotmail.com
English is not my native language so, if you find any spelling erros in my posts, please let me know.
|
|
|
|
|
What if there's connection pooling (ASO.NET kind)?
Norman Fung
|
|
|
|
|
norm wrote:
What if there's connection pooling (ASO.NET kind)?
In ASP.NET you'll only release the connection back to the pool when you call the Close method. Since you don't close the connection between the INSERT and the @@IDENTITY, you wont run in any concurrency issues.
Mauricio Ritter - Brazil
MSN: mauricioritter(atsign)hotmail.com
English is not my native language so, if you find any spelling erros in my posts, please let me know.
|
|
|
|
|
Ok.
But there is still risk:
if You have trigger on table, and trigger inserts rows into other table with identity column...
You wil get wrong (last) @@IDENTITY number !!
|
|
|
|
|
In SQL Server use
SELECT @OrderId=SCOPE_IDENTITY()
Instead
|
|
|
|
|
Hi,
Nice article but how about inserting relational data from an xml file?
|
|
|
|
|
Great code example and well documented.
Thank you very much for taking the time to illustrate both Access 2000/2002 and SQL Server examples.
It was exactly what I was looking for.
|
|
|
|
|
string strSQL = "SELECT USERID FROM TBUSERS WHERE USERNAME='" + strReportTo + "'";
OdbcCommand myCommand = new OdbcCommand(strSQL, myConnection); myConnection.Close();
I need to get the values of USERID and put it in a string.
Please help
|
|
|
|
|
I have to import a table with telefone numbers from database a into database b. Ofcourse I don't need to import the existing ones. Therefore I have to use a sql insert witch compares the data of database a with database b.
It's no problem at all when you use twot tables in obe database. You just use the command and the executenonquery.
But how do you implement this on a dataset.
Who can help me?
|
|
|
|
|
thanks! please help me:how to search in dataset and dataAdaper.
|
|
|
|
|
|
I have a similar setup in my own project as described in this article. I have a foreign key relationship between my two tables. I am getting the following error message:
Unhandled Exception: System.Data.SqlClient.SqlException: INSERT statement conflicted with COLUMN FOR
EIGN KEY constraint 'FK_ServiceAmounts_Services'. The conflict occurred in database 'finApp', table
'Services', column 'ID'.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
Thanks in advance for the help!
|
|
|
|
|
Try to disable the constraints in the dataset by setting the EnableConstraints option to false, before you send the changes to the database. After the update, you can re-enable it using the same property.
Mauricio Ritter - Brazil
Sonorking now: 100.13560 MRitter
English is not my native language so, if you find any spelling erros in my posts, please let me know.
|
|
|
|
|
I know nothing someone place help.
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace Project_Two
{
///
/// Summary description for Form1.
///
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Label FIRSTNAMELabel;
private System.Windows.Forms.Label LastNameLabel;
private System.Windows.Forms.Label ADDRESSLABEL;
private System.Windows.Forms.Label CITYLABEL;
private System.Windows.Forms.Label STATELABEL;
private System.Windows.Forms.Label ZIPLABEL;
private System.Windows.Forms.Label EMAILLABEL;
private System.Windows.Forms.Label HMPHONELABEL;
private System.Windows.Forms.Label CELLPHONELabel;
private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
private System.Data.OleDb.OleDbConnection oleDbConnection1;
private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
private Project_Two.DataSet1 dataSet11;
private System.Windows.Forms.Button FORWARDButton;
private System.Windows.Forms.Button BackButton;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button ADDButton;
private System.Windows.Forms.Button DeleteButton;
private System.Windows.Forms.Button EditButton;
private System.Windows.Forms.Button SaveButton;
private System.Windows.Forms.Button LastButton;
private System.Windows.Forms.Button FirstButton;
private System.Windows.Forms.Button SearchButton;
private System.Windows.Forms.TextBox AddressText;
private System.Windows.Forms.TextBox CityText;
private System.Windows.Forms.TextBox StateText;
private System.Windows.Forms.TextBox ZipcodeText;
private System.Windows.Forms.TextBox EmailText;
private System.Windows.Forms.TextBox HomeNumberText;
private System.Windows.Forms.TextBox CellphoneText;
private System.Windows.Forms.TextBox FirstNameTxt;
private System.Windows.Forms.TextBox LastNameText;
///
/// Required designer variable.
///
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
///
/// Clean up any resources being used.
///
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.FIRSTNAMELabel = new System.Windows.Forms.Label();
this.LastNameLabel = new System.Windows.Forms.Label();
this.ADDRESSLABEL = new System.Windows.Forms.Label();
this.AddressText = new System.Windows.Forms.TextBox();
this.dataSet11 = new Project_Two.DataSet1();
this.CITYLABEL = new System.Windows.Forms.Label();
this.CityText = new System.Windows.Forms.TextBox();
this.STATELABEL = new System.Windows.Forms.Label();
this.StateText = new System.Windows.Forms.TextBox();
this.ZIPLABEL = new System.Windows.Forms.Label();
this.ZipcodeText = new System.Windows.Forms.TextBox();
this.EMAILLABEL = new System.Windows.Forms.Label();
this.EmailText = new System.Windows.Forms.TextBox();
this.HMPHONELABEL = new System.Windows.Forms.Label();
this.HomeNumberText = new System.Windows.Forms.TextBox();
this.CELLPHONELabel = new System.Windows.Forms.Label();
this.CellphoneText = new System.Windows.Forms.TextBox();
this.FORWARDButton = new System.Windows.Forms.Button();
this.ADDButton = new System.Windows.Forms.Button();
this.BackButton = new System.Windows.Forms.Button();
this.EditButton = new System.Windows.Forms.Button();
this.DeleteButton = new System.Windows.Forms.Button();
this.FirstNameTxt = new System.Windows.Forms.TextBox();
this.LastNameText = new System.Windows.Forms.TextBox();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
this.label1 = new System.Windows.Forms.Label();
this.FirstButton = new System.Windows.Forms.Button();
this.LastButton = new System.Windows.Forms.Button();
this.SaveButton = new System.Windows.Forms.Button();
this.SearchButton = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// FIRSTNAMELabel
//
this.FIRSTNAMELabel.Location = new System.Drawing.Point(40, 88);
this.FIRSTNAMELabel.Name = "FIRSTNAMELabel";
this.FIRSTNAMELabel.Size = new System.Drawing.Size(96, 24);
this.FIRSTNAMELabel.TabIndex = 1;
this.FIRSTNAMELabel.Text = "FIRST NAME";
//
// LastNameLabel
//
this.LastNameLabel.Location = new System.Drawing.Point(40, 128);
this.LastNameLabel.Name = "LastNameLabel";
this.LastNameLabel.Size = new System.Drawing.Size(80, 24);
this.LastNameLabel.TabIndex = 2;
this.LastNameLabel.Text = "LAST NAME";
//
// ADDRESSLABEL
//
this.ADDRESSLABEL.Location = new System.Drawing.Point(40, 160);
this.ADDRESSLABEL.Name = "ADDRESSLABEL";
this.ADDRESSLABEL.Size = new System.Drawing.Size(72, 24);
this.ADDRESSLABEL.TabIndex = 4;
this.ADDRESSLABEL.Text = "ADDRESS";
//
// AddressText
//
this.AddressText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Address"));
this.AddressText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.AddressText.Location = new System.Drawing.Point(184, 160);
this.AddressText.Name = "AddressText";
this.AddressText.Size = new System.Drawing.Size(160, 26);
this.AddressText.TabIndex = 5;
this.AddressText.Text = "";
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");
//
// CITYLABEL
//
this.CITYLABEL.Location = new System.Drawing.Point(40, 192);
this.CITYLABEL.Name = "CITYLABEL";
this.CITYLABEL.Size = new System.Drawing.Size(64, 24);
this.CITYLABEL.TabIndex = 6;
this.CITYLABEL.Text = "CITY";
//
// CityText
//
this.CityText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.City"));
this.CityText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.CityText.Location = new System.Drawing.Point(184, 192);
this.CityText.Name = "CityText";
this.CityText.Size = new System.Drawing.Size(160, 26);
this.CityText.TabIndex = 7;
this.CityText.Text = "";
//
// STATELABEL
//
this.STATELABEL.Location = new System.Drawing.Point(40, 232);
this.STATELABEL.Name = "STATELABEL";
this.STATELABEL.Size = new System.Drawing.Size(64, 24);
this.STATELABEL.TabIndex = 8;
this.STATELABEL.Text = "STATE";
//
// StateText
//
this.StateText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.State"));
this.StateText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.StateText.Location = new System.Drawing.Point(184, 224);
this.StateText.Name = "StateText";
this.StateText.Size = new System.Drawing.Size(56, 26);
this.StateText.TabIndex = 9;
this.StateText.Text = "";
//
// ZIPLABEL
//
this.ZIPLABEL.Location = new System.Drawing.Point(32, 272);
this.ZIPLABEL.Name = "ZIPLABEL";
this.ZIPLABEL.Size = new System.Drawing.Size(64, 24);
this.ZIPLABEL.TabIndex = 10;
this.ZIPLABEL.Text = "ZIP CODE";
//
// ZipcodeText
//
this.ZipcodeText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Zip"));
this.ZipcodeText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.ZipcodeText.Location = new System.Drawing.Point(184, 264);
this.ZipcodeText.Name = "ZipcodeText";
this.ZipcodeText.Size = new System.Drawing.Size(104, 26);
this.ZipcodeText.TabIndex = 11;
this.ZipcodeText.Text = "";
//
// EMAILLABEL
//
this.EMAILLABEL.Location = new System.Drawing.Point(32, 304);
this.EMAILLABEL.Name = "EMAILLABEL";
this.EMAILLABEL.Size = new System.Drawing.Size(72, 24);
this.EMAILLABEL.TabIndex = 12;
this.EMAILLABEL.Text = "E-MAIL ID#";
//
// EmailText
//
this.EmailText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.E-Mail ID#"));
this.EmailText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.EmailText.Location = new System.Drawing.Point(184, 304);
this.EmailText.Name = "EmailText";
this.EmailText.Size = new System.Drawing.Size(160, 26);
this.EmailText.TabIndex = 13;
this.EmailText.Text = "";
//
// HMPHONELABEL
//
this.HMPHONELABEL.Location = new System.Drawing.Point(32, 344);
this.HMPHONELABEL.Name = "HMPHONELABEL";
this.HMPHONELABEL.Size = new System.Drawing.Size(56, 24);
this.HMPHONELABEL.TabIndex = 14;
this.HMPHONELABEL.Text = "HOME#";
//
// HomeNumberText
//
this.HomeNumberText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Home Phone #"));
this.HomeNumberText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.HomeNumberText.Location = new System.Drawing.Point(184, 336);
this.HomeNumberText.Name = "HomeNumberText";
this.HomeNumberText.Size = new System.Drawing.Size(160, 26);
this.HomeNumberText.TabIndex = 15;
this.HomeNumberText.Text = "";
//
// CELLPHONELabel
//
this.CELLPHONELabel.Location = new System.Drawing.Point(32, 376);
this.CELLPHONELabel.Name = "CELLPHONELabel";
this.CELLPHONELabel.Size = new System.Drawing.Size(88, 24);
this.CELLPHONELabel.TabIndex = 16;
this.CELLPHONELabel.Text = "CELLPHONE#";
//
// CellphoneText
//
this.CellphoneText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Cell Phone #"));
this.CellphoneText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.CellphoneText.Location = new System.Drawing.Point(184, 368);
this.CellphoneText.Name = "CellphoneText";
this.CellphoneText.Size = new System.Drawing.Size(160, 26);
this.CellphoneText.TabIndex = 17;
this.CellphoneText.Text = "";
//
// FORWARDButton
//
this.FORWARDButton.Location = new System.Drawing.Point(240, 424);
this.FORWARDButton.Name = "FORWARDButton";
this.FORWARDButton.Size = new System.Drawing.Size(72, 40);
this.FORWARDButton.TabIndex = 20;
this.FORWARDButton.Text = "&FORWARD";
this.FORWARDButton.Click += new System.EventHandler(this.FORWARDButton_Click);
//
// ADDButton
//
this.ADDButton.Location = new System.Drawing.Point(488, 88);
this.ADDButton.Name = "ADDButton";
this.ADDButton.Size = new System.Drawing.Size(112, 48);
this.ADDButton.TabIndex = 21;
this.ADDButton.Text = "&ADD NEW RECORD";
this.ADDButton.Click += new System.EventHandler(this.ADDButton_Click);
//
// BackButton
//
this.BackButton.Location = new System.Drawing.Point(152, 424);
this.BackButton.Name = "BackButton";
this.BackButton.Size = new System.Drawing.Size(72, 40);
this.BackButton.TabIndex = 22;
this.BackButton.Text = "&GO BACK";
this.BackButton.Click += new System.EventHandler(this.BackButton_Click);
//
// EditButton
//
this.EditButton.Location = new System.Drawing.Point(480, 144);
this.EditButton.Name = "EditButton";
this.EditButton.Size = new System.Drawing.Size(120, 56);
this.EditButton.TabIndex = 23;
this.EditButton.Text = "&EDIT RECORD";
this.EditButton.Click += new System.EventHandler(this.Edit_Click);
//
// DeleteButton
//
this.DeleteButton.Location = new System.Drawing.Point(480, 208);
this.DeleteButton.Name = "DeleteButton";
this.DeleteButton.Size = new System.Drawing.Size(120, 56);
this.DeleteButton.TabIndex = 24;
this.DeleteButton.Text = "&DELETE RECORD";
//
// FirstNameTxt
//
this.FirstNameTxt.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.First name"));
this.FirstNameTxt.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.FirstNameTxt.Location = new System.Drawing.Point(184, 88);
this.FirstNameTxt.Name = "FirstNameTxt";
this.FirstNameTxt.Size = new System.Drawing.Size(160, 26);
this.FirstNameTxt.TabIndex = 0;
this.FirstNameTxt.Text = "";
//
// LastNameText
//
this.LastNameText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Last name"));
this.LastNameText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.LastNameText.Location = new System.Drawing.Point(184, 128);
this.LastNameText.Name = "LastNameText";
this.LastNameText.Size = new System.Drawing.Size(160, 26);
this.LastNameText.TabIndex = 3;
this.LastNameText.Text = "";
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Table1", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Address", "Address"),
new System.Data.Common.DataColumnMapping("Cell Phone #", "Cell Phone #"),
new System.Data.Common.DataColumnMapping("City", "City"),
new System.Data.Common.DataColumnMapping("E-Mail ID#", "E-Mail ID#"),
new System.Data.Common.DataColumnMapping("First name", "First name"),
new System.Data.Common.DataColumnMapping("Home Phone #", "Home Phone #"),
new System.Data.Common.DataColumnMapping("Id#", "Id#"),
new System.Data.Common.DataColumnMapping("Last name", "Last name"),
new System.Data.Common.DataColumnMapping("State", "State"),
new System.Data.Common.DataColumnMapping("Zip", "Zip")})});
this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = @"DELETE FROM Table1 WHERE ([Id#] = ?) AND (Address = ? OR ? IS NULL AND Address IS NULL) AND ([Cell Phone #] = ? OR ? IS NULL AND [Cell Phone #] IS NULL) AND (City = ? OR ? IS NULL AND City IS NULL) AND ([E-Mail ID#] = ? OR ? IS NULL AND [E-Mail ID#] IS NULL) AND ([First name] = ? OR ? IS NULL AND [First name] IS NULL) AND ([Home Phone #] = ? OR ? IS NULL AND [Home Phone #] IS NULL) AND ([Last name] = ? OR ? IS NULL AND [Last name] IS NULL) AND (State = ? OR ? IS NULL AND State IS NULL) AND (Zip = ? OR ? IS NULL AND Zip IS NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Id_", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Id#", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Address", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Address1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Cell_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Cell_Phone__1", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_City", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_City1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_E_Mail_ID_", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_E_Mail_ID_1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_First_name", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_First_name1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Home_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Home_Phone__1", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Last_name", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Last_name1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_State", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_State1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Zip", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Zip1", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""C:\ITFN2314\Project Two for ITFN2314.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO Table1(Address, [Cell Phone #], City, [E-Mail ID#], [First name], [Ho" +
"me Phone #], [Last name], State, Zip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Address", System.Data.OleDb.OleDbType.VarWChar, 50, "Address"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Cell_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, "Cell Phone #"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("City", System.Data.OleDb.OleDbType.VarWChar, 50, "City"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("E_Mail_ID_", System.Data.OleDb.OleDbType.VarWChar, 50, "E-Mail ID#"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("First_name", System.Data.OleDb.OleDbType.VarWChar, 50, "First name"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Home_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, "Home Phone #"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Last_name", System.Data.OleDb.OleDbType.VarWChar, 50, "Last name"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("State", System.Data.OleDb.OleDbType.VarWChar, 50, "State"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Zip", System.Data.OleDb.OleDbType.VarWChar, 5, "Zip"));
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT Address, [Cell Phone #], City, [E-Mail ID#], [First name], [Home Phone #]," +
" [Id#], [Last name], State, Zip FROM Table1";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = @"UPDATE Table1 SET Address = ?, [Cell Phone #] = ?, City = ?, [E-Mail ID#] = ?, [First name] = ?, [Home Phone #] = ?, [Last name] = ?, State = ?, Zip = ? WHERE ([Id#] = ?) AND (Address = ? OR ? IS NULL AND Address IS NULL) AND ([Cell Phone #] = ? OR ? IS NULL AND [Cell Phone #] IS NULL) AND (City = ? OR ? IS NULL AND City IS NULL) AND ([E-Mail ID#] = ? OR ? IS NULL AND [E-Mail ID#] IS NULL) AND ([First name] = ? OR ? IS NULL AND [First name] IS NULL) AND ([Home Phone #] = ? OR ? IS NULL AND [Home Phone #] IS NULL) AND ([Last name] = ? OR ? IS NULL AND [Last name] IS NULL) AND (State = ? OR ? IS NULL AND State IS NULL) AND (Zip = ? OR ? IS NULL AND Zip IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Address", System.Data.OleDb.OleDbType.VarWChar, 50, "Address"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Cell_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, "Cell Phone #"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("City", System.Data.OleDb.OleDbType.VarWChar, 50, "City"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("E_Mail_ID_", System.Data.OleDb.OleDbType.VarWChar, 50, "E-Mail ID#"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("First_name", System.Data.OleDb.OleDbType.VarWChar, 50, "First name"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Home_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, "Home Phone #"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Last_name", System.Data.OleDb.OleDbType.VarWChar, 50, "Last name"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("State", System.Data.OleDb.OleDbType.VarWChar, 50, "State"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Zip", System.Data.OleDb.OleDbType.VarWChar, 5, "Zip"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Id_", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Id#", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Address", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Address1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Cell_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Cell_Phone__1", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_City", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_City1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_E_Mail_ID_", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_E_Mail_ID_1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_First_name", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_First_name1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Home_Phone__", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Home_Phone__1", System.Data.OleDb.OleDbType.VarWChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Last_name", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Last_name1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_State", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_State1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Zip", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Zip1", System.Data.OleDb.OleDbType.VarWChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));
//
// label1
//
this.label1.Font = new System.Drawing.Font("Monotype Corsiva", 15.75F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.label1.Location = new System.Drawing.Point(304, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(168, 24);
this.label1.TabIndex = 25;
this.label1.Text = "CONTACT LIST";
//
// FirstButton
//
this.FirstButton.Location = new System.Drawing.Point(64, 424);
this.FirstButton.Name = "FirstButton";
this.FirstButton.Size = new System.Drawing.Size(75, 40);
this.FirstButton.TabIndex = 26;
this.FirstButton.Text = "&FIRST";
this.FirstButton.Click += new System.EventHandler(this.FirstButton_Click);
//
// LastButton
//
this.LastButton.Location = new System.Drawing.Point(328, 424);
this.LastButton.Name = "LastButton";
this.LastButton.Size = new System.Drawing.Size(75, 40);
this.LastButton.TabIndex = 27;
this.LastButton.Text = "&LAST";
this.LastButton.Click += new System.EventHandler(this.LastButton_Click);
//
// SaveButton
//
this.SaveButton.Location = new System.Drawing.Point(480, 88);
this.SaveButton.Name = "SaveButton";
this.SaveButton.Size = new System.Drawing.Size(120, 48);
this.SaveButton.TabIndex = 28;
this.SaveButton.Text = "&SAVE RECORD";
this.SaveButton.Visible = false;
this.SaveButton.Click += new System.EventHandler(this.SaveButton_Click);
//
// SearchButton
//
this.SearchButton.Location = new System.Drawing.Point(480, 272);
this.SearchButton.Name = "SearchButton";
this.SearchButton.Size = new System.Drawing.Size(120, 48);
this.SearchButton.TabIndex = 29;
this.SearchButton.Text = "&SEARCH";
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.BackColor = System.Drawing.Color.LightSkyBlue;
this.ClientSize = new System.Drawing.Size(776, 526);
this.Controls.Add(this.SearchButton);
this.Controls.Add(this.SaveButton);
this.Controls.Add(this.LastButton);
this.Controls.Add(this.FirstButton);
this.Controls.Add(this.label1);
this.Controls.Add(this.DeleteButton);
this.Controls.Add(this.EditButton);
this.Controls.Add(this.BackButton);
this.Controls.Add(this.ADDButton);
this.Controls.Add(this.FORWARDButton);
this.Controls.Add(this.CellphoneText);
this.Controls.Add(this.HomeNumberText);
this.Controls.Add(this.EmailText);
this.Controls.Add(this.ZipcodeText);
this.Controls.Add(this.StateText);
this.Controls.Add(this.CityText);
this.Controls.Add(this.AddressText);
this.Controls.Add(this.FirstNameTxt);
this.Controls.Add(this.LastNameText);
this.Controls.Add(this.CELLPHONELabel);
this.Controls.Add(this.HMPHONELABEL);
this.Controls.Add(this.EMAILLABEL);
this.Controls.Add(this.ZIPLABEL);
this.Controls.Add(this.STATELABEL);
this.Controls.Add(this.CITYLABEL);
this.Controls.Add(this.ADDRESSLABEL);
this.Controls.Add(this.LastNameLabel);
this.Controls.Add(this.FIRSTNAMELabel);
this.ForeColor = System.Drawing.Color.MediumBlue;
this.Name = "Form1";
this.Text = "Project Two";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
}
#endregion
///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void Form1_Load(object sender, System.EventArgs e)
{
oleDbConnection1.Open();
oleDbDataAdapter1.Fill(dataSet11);
oleDbConnection1.Close();
}
private void FORWARDButton_Click(object sender, System.EventArgs e)
{
this.BindingContext[dataSet11, "Table1"].Position += 1;
}
private void BackButton_Click(object sender, System.EventArgs e)
{
this.BindingContext[dataSet11, "Table1"].Position -=1;
}
private void oleDbConnection1_InfoMessage(object sender, System.Data.OleDb.OleDbInfoMessageEventArgs e)
{
}
private void ADDButton_Click(object sender, System.EventArgs e)
{
this.BindingContext[dataSet11, "Table1"].AddNew();
ADDButton.Visible = false;
SaveButton.Visible = true;
}
private void SaveButton_Click(object sender, System.EventArgs e)
{
ADDButton.Visible = true;
SaveButton.Visible = false;
System.Data.OleDb.OleDbCommand cmd;
cmd = new System.Data.OleDb.OleDbCommand ("Insert INTO Table1 (ID#, First name, Last name, Address, City,State,Zip Code,e-mail ID#,Home Phone#, Cellphone#) Values ('', FirstNameTxt, LastNameText, AddressText, CityText, ZipcodeText, EmailText,HomeNumberText,CellphoneText) ");
oleDbConnection1.Open();
oleDbDataAdapter1.Update(dataSet11);
oleDbConnection1.Close();
}
private void Edit_Click(object sender, System.EventArgs e)
{
}
private void LastButton_Click(object sender, System.EventArgs e)
{
this.BindingContext[dataSet11, "Table1"].Position = this.BindingContext[dataSet11, "Table1"].Count-1;
}
private void FirstButton_Click(object sender, System.EventArgs e)
{
this.BindingContext[dataSet11, "Table1"].Position = 0;
}
}
}
|
|
|
|
|
|
unhandled exception of type System.DAta.SQLClient.SQLException
on oOrderDetailsDataAdapter.Update(oDS, "OrderDetails");
I'm unable to update OrderDetails.
I probably miss somthing durong my database creation.
Does the OrderId column inOrderDetails is IDENTITY to?
Kevin
|
|
|
|
|
Yeah... you probably need to mark the OrderDetails column as IDENTITY.
hope this helps
|
|
|
|
|