i've a code that's inserting but it's not dumping into the database!!!!
private void buttonX1_Click(object sender, EventArgs e)
{
if (textBoxX1.Text != "" && textBoxX2.Text != "" && textBoxX3.Text != "" && textBoxX4.Text!= "" && textBoxX5.Text!= "" && textBoxX6.Text!= "" && textBoxX7.Text!= "" && textBoxX8.Text!= "")
{
string s = "Insert Into t1 Values('" + textBoxX1.Text + "','" + textBoxX2.Text + "','" + textBoxX3.Text + "','" + textBoxX4.Text + "','" + textBoxX5.Text + "','" + textBoxX6.Text + "','" + textBoxX7.Text + "','" + textBoxX8.Text + "')";
con.Open();
cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd = new OleDbCommand(s,con);
cmd.ExecuteNonQuery();
MessageBox.Show("Inserted");
textBoxX1.Text = "";
textBoxX2.Text = "";
textBoxX3.Text = "";
textBoxX4.Text = "";
textBoxX5.Text = "";
textBoxX6.Text = "";
textBoxX7.Text = "";
textBoxX8.Text = "";
con.Close();
}
else
{
MessageBox.Show("enter all the fields");
}
}