i have a stored procedure named insertreg:
DELIMITER $$DROP PROCEDURE IF EXISTS `naukri4u`.`insertreg`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `insertreg`(emailaddress varchar(50),firstname varchar(50),lastname varchar(50),username varchar(50),password varchar(50),conformpassword varchar(50),mobile varchar(50),currentloc varchar(50),prefferedjobloc varchar(50),gender varchar(50),totalexp varchar(50),industry varchar(50),function varchar(50),keyskills varchar(50),highestqual varchar(50),yearofpass varchar(50),institute varchar(50),resumetitle varchar(50),resume varchar(50))
BEGIN
insert into registration(emailaddress,firstname,lastname,username,password,conformpassword,mobile,currentloc,prefferedjobloc,gender,totalexp,industry,function,keyskills,highestqual,yearofpass,institute,resumetitle,resume)
values(emailaddress,firstname,lastname,username,password,conformpassword,mobile,currentloc,prefferedjobloc,gender,totalexp,industry,function,keyskills,highestqual,yearofpass,institute,resumetitle,resume);
END$$DELIMITER ;
i want to submit a regisration form using this stored proc.this registration table have primary key reg_id which auto increments so
i have not taken it in my query.the code i have written is:
public DataSet insert(Common.com_registration objcom_reg)
{
registration reg = new registration();
try
{
DbParameter dbparama0 = DAC.Parameter("emailaddress", objcom_reg.Emailaddress, DbType.String, ParameterDirection.Input);
DbParameter dbparama1 = DAC.Parameter("firstname", objcom_reg.Firstname, DbType.String, ParameterDirection.Input);
DbParameter dbparama2 = DAC.Parameter("lastname", objcom_reg.Lastname, DbType.String, ParameterDirection.Input);
DbParameter dbparama3 = DAC.Parameter("username", objcom_reg.Username, DbType.String, ParameterDirection.Input);
DbParameter dbparama4 = DAC.Parameter("password", objcom_reg.Password, DbType.String, ParameterDirection.Input);
DbParameter dbparama5 = DAC.Parameter("conformpassword", objcom_reg.Conformpassword, DbType.String, ParameterDirection.Input);
DbParameter dbparama6 = DAC.Parameter("mobile", objcom_reg.Mobile, DbType.String, ParameterDirection.Input);
DbParameter dbparama7 = DAC.Parameter("currentloc", objcom_reg.Currentlocation, DbType.String, ParameterDirection.Input);
DbParameter dbparama8 = DAC.Parameter("prefferedjobloc", objcom_reg.Prefferedjobloc, DbType.String, ParameterDirection.Input);
DbParameter dbparama9 = DAC.Parameter("gender", objcom_reg.Gender, DbType.String, ParameterDirection.Input);
DbParameter dbparama10 = DAC.Parameter("totalexp", objcom_reg.Totalexp, DbType.String, ParameterDirection.Input);
DbParameter dbparama11= DAC.Parameter("industry", objcom_reg.Industry, DbType.String, ParameterDirection.Input);
DbParameter dbparama12= DAC.Parameter("function", objcom_reg.Function, DbType.String, ParameterDirection.Input);
DbParameter dbparama13= DAC.Parameter("keyskills", objcom_reg.Keyskills, DbType.String, ParameterDirection.Input);
DbParameter dbparama14= DAC.Parameter("highestqual", objcom_reg.Highestqual, DbType.String, ParameterDirection.Input);
DbParameter dbparama15= DAC.Parameter("yearofpass", objcom_reg.Yearofpassing, DbType.String, ParameterDirection.Input);
DbParameter dbparama16= DAC.Parameter("institute", objcom_reg.Institute, DbType.String, ParameterDirection.Input);
DbParameter dbparama17= DAC.Parameter("resumetitle", objcom_reg.Resumetitle, DbType.String, ParameterDirection.Input);
DbParameter dbparama18= DAC.Parameter("resume", objcom_reg.Resume, DbType.String, ParameterDirection.Input);
DbParameter[] dbparamcoll = new DbParameter[] {dbparama0,dbparama1,dbparama2,dbparama3,dbparama4,dbparama5,dbparama6,dbparama7,dbparama8,dbparama9,dbparama10,dbparama11,
dbparama12,dbparama13,dbparama14,dbparama15,dbparama16,dbparama17,dbparama18};
DbParameter dbParam0 = DAC.Parameter("v_userid", objcom_reg.Emailaddress, DbType.String, ParameterDirection.Input);
DbParameter dbParam1 = DAC.Parameter("v_headline", objcom_reg.Emailaddress, DbType.String, ParameterDirection.Input);
DbParameter[] dbParamColl = new DbParameter[] { dbParam0, dbParam1 };
return DAC.SelectDS("insertreg", dbparamcoll);
}
catch(Exception exp)
{
throw exp;
}
i am passing a object which is initialized with all the values from my registration form.i am calling this insert function
at my registratin form.hope now u r clear with my prob.
modified on Monday, November 29, 2010 6:59 AM
|