Click here to Skip to main content
15,910,009 members

Comments by Rajalakshmi Raji (Top 2 by date)

Rajalakshmi Raji 9-Apr-24 11:21am View    
objCmd.Parameters.AddWithValue("@OnlineAccess", onlineaccess);
objCmd.Parameters.AddWithValue("@ContactId", ContactId);
objCmd.Parameters.AddWithValue("@uid", uid);
objCmd.Parameters.AddWithValue("@UserType", UserType);
objCmd.Parameters.AddWithValue("@OnlineAccessOld", oldonlineaccess);
objCmd.Parameters.AddWithValue("@OldEmail", oldemail);
objCmd.Parameters.AddWithValue("@Microsite",MicrositeId);
objCmd.Parameters.AddWithValue("@UserName", UserName);
objCmd.Parameters.AddWithValue("@OldUserName", OldUserName);
objCmd.Parameters.AddWithValue("@Password", Password);
objCmd.Parameters.AddWithValue("@UserNameFlag", UserNameFlag);
objCmd.CommandText = "ADR_spInsertCustomerContact";
objCmd.ExecuteNonQuery().ToString();
pValue = objCmd.Parameters["@ErrMessage"].Value.ToString() + "-" + objCmd.Parameters["@RHdrID"].Value.ToString();

//transaction.Commit();

//}
//catch (Exception Ex)
//{
// //transaction.Rollback();
// APACommonLib.ExceptionHandle.HandleException(Ex); throw Ex;
//}
//finally
//{
// objConn.Close();
//}
objConn.Close();
return pValue;
}. This is my code in this I pass parameters like groupid declared string datatype to this function but in sp I declare groupid as a parameter as int is this a issue or not
Rajalakshmi Raji 9-Apr-24 11:17am View    
Conversion failed when converting the varchar value 'GroupId:' to data type int. 1 CUS |
Conversion failed when converting the varchar value 'GroupId:' to data type int. 1 CUS this is my issue