strb.Append(" INSERT INTO PR_JOB_APP_STATUS_DET " & _ " (ID,PR_JOB_APP_STATUS_ID,PR_EMPLOYEE_MASTER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,EMAIL_ID, " & _ " Mobile_No,FILE_PATH,JOB_APP_STATUS,STATUS_DATE,REMARKS) " & _ " VALUES ( " & _ Trim(t_Id) & "," & _ (hdnJobStatID.Value) & "," & _ Trim(t_EmpMasterID) & ",'" & _ Trim(t_First_Name) & "','" & _ Trim(t_Middle_Name) & "','" & _ Trim(t_Last_Name) & "','" & _ Trim(t_Email) & "','" & _ Trim(t_Mobile_No) & "','" & _ Trim(t_File_Path) & "','" & _ Trim(RadISR.SelectedValue) & "'," & _ RsmartUtl.UDSysDate() & ",'" & _ Trim(txtRemarks.Text) & "'" & "); ") If strb.ToString <> "BEGIN" Then 'strb.Append(" END; ") MyCmd.Transaction = MyTrans MyCmd.CommandText = strb.ToString MyConn = New OleDbConnection("User Id=erponnet;Password=erponnet;Data Source=RSMARTDEVDB;Provider=OraOLEDB.Oracle") MyConn.Open() MyCmd.Connection = MyConn MyCmd.ExecuteNonQuery() MyConn.Close() 'MyCmd = New OleDbCommand(strb.ToString(), MyConn) 'MyCmd.Transaction = MyTrans 'MyCmd.ExecuteNonQuery() 'MyTrans.Commit() End If
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)