query

I am making an app .. in which there's few table the tables named Month and Expense are having 1 to many realtionship....
when ever I write this query


qry = "INSERT INTO EXPENSE values('" + tb_ID.Text + dtp_Edate.Text + "',#" + dtp_Edate.Value.ToString + "#," + tb_Amount.Text + ", '" + tb_Description.Text + "')" ... the prog shows error ,,, like sometimes ,,, that the values don't match or some times error in INSERT into ....

aaah !NEEd vb.net code.... I don't have too experience ...
Topic archived. No new replies allowed.