conversion from varchar to datatype money

[shikhachaudhary30]

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");

[DeMan]

This code looks to me a little like Java, but you mention D/bases.....
Could you please clarify to help us point you in the right direction.....