store procedure sql server coding
insert into dbo.Registration(Cust_Name,Address,EmailID,Contact_No,Username,Password,Pincode,Create_Date) values
(@CustomerName,@CustomerAddress,@CustomerEmailID,@CustomerPhoneNo,@Username,@Password,@Pincode,GETDATE())
c# coding
public class shopping
{
public string CustomerName;
public string CustomerEmailID;
public string CustomerPhoneNo;
public string CustomerAddress;
public string Username;
public string Password;
public string ConfirmPassword;
public int Pincode;
public DateTime CreateDate;
public void Registration()
{
SqlParameter[] parameters = new SqlParameter[8];
parameters[0] = DataLayer.DataAccess.AddParameter("@CustomerName", CustomerName, System.Data.SqlDbType.NVarChar, 50);
parameters[1] = DataLayer.DataAccess.AddParameter("@CustomerEmailID", CustomerEmailID, System.Data.SqlDbType.NVarChar, 50);
parameters[2] = DataLayer.DataAccess.AddParameter("@CustomerPhoneNo", CustomerPhoneNo, System.Data.SqlDbType.VarChar, 50);
parameters[3] = DataLayer.DataAccess.AddParameter("@CustomerAddress", CustomerAddress, System.Data.SqlDbType.NVarChar, 50);
parameters[4] = DataLayer.DataAccess.AddParameter("@Username", Username, System.Data.SqlDbType.NVarChar, 50);
parameters[5] = DataLayer.DataAccess.AddParameter("@Password", Password, System.Data.SqlDbType.NVarChar, 50);
parameters[6] = DataLayer.DataAccess.AddParameter("@Pincode",Pincode, System.Data.SqlDbType.Int,10);
parameters[7] = DataLayer.DataAccess.AddParameter("@CreateDate",CreateDate, System.DateTime.Now.ToShortDateString());
DataTable dt = DataLayer.DataAccess.ExecutedByProcedure("Sp_AddCustomers", parameters);
}
What I have tried:
System.Data.SqlDbType.Int,10);
parameters[7] = DataLayer.DataAccess.AddParameter("@CreateDate",CreateDate, System.DateTime.Now.ToShortDateString());