注册表格数据输入和输入数据库中的条目 [英] Regstration form data enter & entry in the data base

问题描述

一些错误低于

存储过程

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;

/// <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();

   }
}

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; )

 }

推荐答案

永远不要以明文形式存储密码-这是主要的安全风险.这里有一些有关如何执行此操作的信息:密码存储:操作方法. [^ ]

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.[^]

这篇关于注册表格数据输入和输入数据库中的条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！