Click here to Skip to main content
15,896,111 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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());
Posted
Updated 15-Mar-17 20:02pm

1 solution

use like
parameters[7] = new SqlParameter("@CreateDate", System.Data.SqlDbType.DateTime);
            parameters[7].Value=System.DateTime.Now;
 
Share this answer
 
Comments
Member 13059491 16-Mar-17 4:46am    
public DateTime Create_Date Is required or not
madhav_jain 16-Mar-17 5:19am    
Its not required...
Member 13059491 16-Mar-17 5:48am    
kk thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900