C#.Net Windows Forms+ MS Access database insert

Jan 31 2008 6:18 AM
    hello friends,

OleDbConnection con = new OleDbConnection(@"provider= Microsoft.Jet.OLEDb.4.0; Data Source = D:\My Documents\Visual Studio 2005\Projects\db2.mdb");
           
OleDbCommand command = new OleDbCommand("Insert into tbl_client(fname,lname,address) VALUES('" + text_customer_fname + "', '" + text_customer_lname + "','" + text_customer_address + "')", con);
            con.Open();
            command.ExecuteNonQuery();

what i sthe problem with this code . it says datatype missmatch


Answers (3)