Hello,
I am facing the error in image pls help me to resolve the issue. following is the code in which I am facing the problem
Code:ConnDB() sqL = "INSERT INTO supplier_payments (sup_id,billno,paid_amount,cdate,balance,description) VALUES (@sid,@billno,@payamnt,@date,@balance,@desc)" cmd.Parameters.AddWithValue("@sid", supDGV.SelectedCells(0).Value) cmd.Parameters.AddWithValue("@billno", txtbillno.Text) cmd.Parameters.AddWithValue("@payamnt", txtPayAmount.Text) cmd.Parameters.AddWithValue("@date", Date.Now()) cmd.Parameters.AddWithValue("@balance", balance) cmd.Parameters.AddWithValue("@desc", "Balance Paid") cmd = New MySqlCommand(sqL, conn) Dim count As Integer = cmd.ExecuteNonQuery()
Thanks in advance.




Reply With Quote
