Pragadheesh
In the zone
hi,
i developed a window application(a aregistration form) and tried to store the details in a database. i used ms access. here is the method for the "submit" button that would store the details in the database. my database name is Registration and table name is Registration
private void btnRegister_Click(object sender, EventArgs e)
{
string strConnection =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\NewReg\\Registration.mdb";
OleDbConnection con = new OleDbConnection(strConnection);
string strQuery =
"select * from Registration";
OleDbCommand aCommand1 = new OleDbCommand(strQuery, con);
OleDbDataAdapter adp = new OleDbDataAdapter(aCommand1);
con.Open();
adp.SelectCommand = aCommand1;
DataSet ds = new DataSet();
adp.Fill(ds, "Registration");
DataRow drow = ds.Tables[0].NewRow();
drow[0] = txtName.Text;
drow[1] = int.Parse(txtAge.Text);
drow[2] = txtGender.Text;
drow[3] = txtPassword.Text;
drow[4] = int.Parse(txtContact.Text);
drow[5] = txtMail.Text;
ds.Tables[0].Rows.Add(drow);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adp);
adp.UpdateCommand = builder.GetUpdateCommand();
adp.Update(ds);
con.Close();
}
but i get exceptions stating "syntax insert into exception". why such an exception? help plz.
also i'm not much familiar with MS connectivity using C#. any sites or links from which i can learn more about it..
i developed a window application(a aregistration form) and tried to store the details in a database. i used ms access. here is the method for the "submit" button that would store the details in the database. my database name is Registration and table name is Registration
private void btnRegister_Click(object sender, EventArgs e)
{
string strConnection =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\NewReg\\Registration.mdb";
OleDbConnection con = new OleDbConnection(strConnection);
string strQuery =
"select * from Registration";
OleDbCommand aCommand1 = new OleDbCommand(strQuery, con);
OleDbDataAdapter adp = new OleDbDataAdapter(aCommand1);
con.Open();
adp.SelectCommand = aCommand1;
DataSet ds = new DataSet();
adp.Fill(ds, "Registration");
DataRow drow = ds.Tables[0].NewRow();
drow[0] = txtName.Text;
drow[1] = int.Parse(txtAge.Text);
drow[2] = txtGender.Text;
drow[3] = txtPassword.Text;
drow[4] = int.Parse(txtContact.Text);
drow[5] = txtMail.Text;
ds.Tables[0].Rows.Add(drow);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adp);
adp.UpdateCommand = builder.GetUpdateCommand();
adp.Update(ds);
con.Close();
}
but i get exceptions stating "syntax insert into exception". why such an exception? help plz.
also i'm not much familiar with MS connectivity using C#. any sites or links from which i can learn more about it..