Comments by Adesh Saroha

Adesh Saroha 30-May-14 6:29am View

how to write condition to pass null value if iam not inserting anything

Adesh Saroha 30-May-14 6:19am View

strSql = "insert into ItemMaster(" & _
" ITEM_CODE," & _
" ITEM_NAME," & _
" DRAWING_NO," & _
" WEIGHT_CAST," & _
" WEIGHT_FINISH," & _
" CROSSING_COUNT," & _
" catID" & _
" )" & _
" values(" & _
"'" & Replace(txtItemCode.Text, "'", "''") & "'," & _
"'" & Replace(txtItemName.Text, "'", "''") & "'," & _
"'" & Replace(txtDrawingNo.Text, "'", "''") & "'," & _
"'" & Replace(txtStWeightCst.Text, "'", "''") & "'," & _
"'" & Replace(txtStWeightFin.Text, "'", "''") & "'," & _
"'" & Replace(txtNoOfCross.Text, "'", "''") & "'," & _
"'" & IIf(cboItemCategoty.SelectedIndex = -1, "", cboItemCategoty.SelectedValue) & "'" & _
")" actually i am writing this code as like this vb

Adesh Saroha 23-Apr-14 6:06am View

cmd.Parameters.AddWithValue("@Password", Pass.Text);changed but error remains

Comments by Adesh Saroha (Top 3 by date)