am making a program where i insert the Value from text-boxes to my Access Database . em just having this Unusual error plz help me out
My Data Base Connectiong Establishment
And here is the Coding of my Button
My Data Base Connectiong Establishment
Code:
private OleDbConnection myCon;
public Form1()
{
InitializeComponent();
string connetionString = null;
OleDbConnection myCon = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Users/Mujahid/Documents/Visual Studio 2008/Projects/ts/ts/ts.accdb");
Code:
private void button2_Click(object sender, EventArgs e)
{
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText="insert into ts(ID,Name)" +"Values ('"+textBox1.Text+"','"+textBox2.Text+"')" ;
cmd.Connection=myCon;
myCon.Open(); --> ERROR COMES OUT FROM HERE
cmd.ExecuteNonQuery();
myCon.Close();
}
Comment