Click here to Skip to main content
15,886,664 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
some error are below

STORE PROCEDURE
SQL
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




C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// Summary description for SELLERREGBAL
/// </summary>
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();

   }
}

C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
/// Summary description for SELLERREGDAL
/// </summary>
public class SELLERREGDAL
{
    public SELLERREGDAL()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    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; )

 }
Posted
Updated 1-Mar-12 21:28pm
v2
Comments
Sudip Saha 2-Mar-12 2:53am    
What is your Question Here, are u getting any error here .. which error you are getting
Anuja Pawar Indore 2-Mar-12 3:29am    
Added proper code block

1 solution

Never store passwords in clear text - it is a major security risk. There is some information on how to do it here: Password Storage: How to do it.[^]
 
Share this answer
 

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