query

[sheheryar]

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 ...

[Bazzy]

http://www.cplusplus.com/articles/how_to_ask/
http://catb.org/~esr/faqs/smart-questions.html