"A.J" <ajay.bi***@gmail.com> wrote in message
news:1141545477.837838.304060@i39g2000cwa.googlegroups.com...
> ###########################################################################
>
>
> private void btnAdd_Click(object sender, System.EventArgs e)
> {
> OleDbConnection con = new OleDbConnection(str);
> con.Open();
>                 string qry = "select * from t_contact";
> OleDbDataAdapter da = new OleDbDataAdapter(qry,con);
> DataSet ds = new DataSet();
> da.Fill(ds,"t_contact");
> DataTable dt = new DataTable();
> dt = ds.Tables["t_contact"];
> DataRow dr ;
> dr = dt.NewRow();
> dr["FirstName"] = txtFirstName.Text;
> dr["LastName"] = txtLastName.Text;
> dr["E-Mail"] = txtEMail.Text;
> dr["PhoneNumber"] = txtPhoneNumber.Text;
> ds.Tables["t_contact"].Rows.Add(dr);
> textBox2.Text = ds.GetXml();
> da.Update(ds,"t_contact");
> }
> ###########################################################################
> __________________________________________________________
> here e-mail is the primary key.Unable to insert record in the database.
> __________________________________________________________
> The error coming is :
> System.Data.OleDb.OleDbException: Syntax error in INSERT INTO
> statement.
>   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
> DataTableMapping tableMapping)
>   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
> srcTable)
>   at Contact_new.Form1.btnAdd_Click(Object sender, EventArgs e) in
> c:\documents and settings\administrator\my documents\visual studio
> projects\projects\contact_new\form1.cs:line 234
>