No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
 | [CODE]" how can i remove this exception ?.....Data type mismatch in criteria expression."; [/CODE] [CODE]"here is attechment of code.";[/CODE] [CODE] " con.Open(); OleDbCommand com = new OleDbCommand("INSERT INTO grn(GRNID,PO,REMARKS,VENDERSID,STATUS,DELEVERYDATE,GRNAMMOUNT)Values(@GRNID,@PO,@REMARKS,@VENDERSID,@STATUS,@DELEVERYDATE,@GRNAMMOUNT)", con); com.Parameters.AddWithValue("@GRNID", textBox1.Text); com.Parameters.AddWithValue("@PO", comboBox2.Text); com.Parameters.AddWithValue("@REMARKS", textBox3.Text); com.Parameters.AddWithValue("@VENDERSID", textBox8.Text); com.Parameters.AddWithValue("@STATUS", textBox6.Text); com.Parameters.AddWithValue("@DELEVERYDATE", dateTimePicker2.Text); com.Parameters.AddWithValue("@GRNAMMOUNT", textBox7.Text); com.ExecuteNonQuery(); MessageBox.Show("Your Record is inserted successfully..."); … |
| | plz tell me .....how can i put the textboxes values of form 1...itni form2 textboxes at load time.....? |