some error are below
STORE PROCEDURE
ALTER PROCEDURE seller_insert
{
@User_Name nvarchar(20),
@Password nvarchar(30),
@First_Name nvarchar(20),
@Last_Name nvarchar(20),
@Address nvarchar(50),
@Gender nvarchar(10),
@Dob nvarchar(10),
@E_Mail nvarchar(30),
@Store_Name nvarchar(50),
@StoreWebSite nvarchar(50),
@Postal_No nvarchar(50)
}
AS
insert into tbl_RegSeller(User_Name,Password,First_Name,Last_Name,Address,Gender,Dob,E_Mail,Store_Name,StoreWebSite,Postal_No) Values(@User_Name,@Password,@First_Name,@Last_Name,@Address,@Gender,@Dob,@E_Mail,@Store_Name,@StoreWebSite,@Postal_No)
RETURN
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public class SELLERREGBAL
{
SELLERREGDAL dal = new SELLERREGDAL();
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
public SELLERREGBAL()
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["shop"].ConnectionString);
}
public void insert(SELLERREGDAL dal)
(
con.open();
cmd = new SqlConnection("Seller_insert",con);
cmd.commandtype = CommandType.Storedprocedure;
cmd.Parameters.AddWithValue("@User_Name", dal.User_Name);
cmd.Parameters.AddWithValue("@Password", dal.Password);
cmd.Parameters.AddWithValue("@First_Name", dal.First_Name);
cmd.Parameters.AddWithValue("@Last_Name", dal.Last_Name);
cmd.Parameters.AddWithValue("@Address", dal.Address);
cmd.Parameters.AddWithValue("@Gender", dal.Gender);
cmd.Parameters.AddWithValue("@Dob", dal.Dob);
cmd.Parameters.AddWithValue("@E_Mail", dal.E_Mail);
cmd.Parameters.AddWithValue("@Store_Name", dal.Store_Name);
cmd.Parameters.AddWithValue("@StoreWebSite", dal.StoreWebSite);
cmd.Parameters.AddWithValue("@Postal_No", dal.Postal_No);
cmd.ExecuteNonQuery();
con.Close();
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
public class SELLERREGDAL
{
public SELLERREGDAL()
{
}
public int seller_id ( get; set; )
public string User_Name (get; set; )
public string password (get; set; )
public string First_Name (get; set; )
public string Last_Name (get; set; )
public string Address (get; set; )
public string Gender (get; set; )
public string Dob (get; set; )
public string E_Mail (get; set; )
public string Store_Name (get; set; )
public string Storewebsite (get; set; )
public string Postal_No (get; set; )
}