hii all!!
i am getting the following error-
implict conversion from data type varchar to data type money....USE CONVERT function to run this query...
i want to insert a textbox value(textbox7) to database...
i m attaching the code also...
PLZ HELP!!!!
String rep = textBox6.Text.ToString().Trim();
OleDbConnection con = new OleDbConnection("provider=sqloledb;server=.;user id=sa;password=;database=Project;");
//OleDbDataReader dr;
OleDbCommand comm;
str = "insert into AllPrograms values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + richTextBox1.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + " ')";
con.Open();
comm = new OleDbCommand(str, con);
comm.ExecuteNonQuery();
MessageBox.Show("Record inserted successfully", "Data Entry Information");