hi, i have written this insert query for inserting data in database : "insert into leavemaster (leave_code,lea ve_desc,leave_t ype, leave_days, leave_valid_mon th, leave_amount, effective_date, max_limit, leave_num, maintain_bal, leave_encash, leave_fq, encash_limit, encash_fq, carry_frwd, negative_bal, max_encash_bal, leave_limit, holiday_lv, weekoff_lv, del_flag" & _
"values (@leave_code, @leave_desc, @leave_type, @leave_days, @leave_valid_mo nth, @leave_amount, @effective_date , @max_limit, @leave_num, @maintain_bal, @leave_encash, @leave_fq, @encash_limit, @encash_fq, @carry_frwd, @negative_bal, @max_encash_bal , @leave_limit, @holiday_lv, @weekoff_lv, @del_flag)"
and then have passed parameters like:
Dim leave_codeParam As New OleDbParameter( "@leave_cod e", OleDbType.VarCh ar, 3)
leave_codeParam .Value = txtLeave_code.T ext
cmd.Parameters. Add(leave_codeP aram)
for each fields of database table..
but syntax error in insert into statemtent is coming still.. can any experts pl help me out...
"values (@leave_code, @leave_desc, @leave_type, @leave_days, @leave_valid_mo nth, @leave_amount, @effective_date , @max_limit, @leave_num, @maintain_bal, @leave_encash, @leave_fq, @encash_limit, @encash_fq, @carry_frwd, @negative_bal, @max_encash_bal , @leave_limit, @holiday_lv, @weekoff_lv, @del_flag)"
and then have passed parameters like:
Dim leave_codeParam As New OleDbParameter( "@leave_cod e", OleDbType.VarCh ar, 3)
leave_codeParam .Value = txtLeave_code.T ext
cmd.Parameters. Add(leave_codeP aram)
for each fields of database table..
but syntax error in insert into statemtent is coming still.. can any experts pl help me out...
Comment