asp.net中的LOgin页面，c＃，数据来自多个表 [英] LOgin page in asp.net,c# with data coming from multiple tables

问题描述

你好frndz我对asp .net的新内容



i我在asp .net中创建一个登录页面，c＃与MS-ACCESS数据库



i我有用户名，代码，密码texbox



divisioncode，sba和unitmaster下拉列表，这个下拉列表的数据来自三个不同的桌子



i有编写的代码，但它不起作用我粘贴我的c＃代码下面plz帮我frndz



和我也想使用会话概念，并希望在下一页显示用户ID，单位代码，分区代码，登录日期和登录年份作为标签

Hello frndz i m new to asp .net

i am creating an login page in asp .net ,c# with MS-ACCESS database

i am having username,empcode,password texboxes

divisioncode,sba,and unitmaster dropdown list, data for this dropdown list comes from three different tables

i have written code but it does not work i pasting my c# code below plz help me frndz

and i also want to use session concept and want to display userid,unitcode ,divisioncode ,login date ,and login year as label in next page

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
        populatedd1();
        populatedd2();
        populatedd3();
    }
    public void populatedd1()
    {
        dddivision.Items.Add(new ListItem("-Select-", ""));
        dddivision.AppendDataBoundItems = true;

        OleDbConnection con1 = new OleDbConnection(ConfigurationManager.ConnectionStrings["vhgroupconnection"].ConnectionString);
        string query = "SELECT division_id FROM division_master";
        OleDbCommand cmd1 = new OleDbCommand();
        cmd1.CommandType = CommandType.Text;
        cmd1.CommandText = query;
        cmd1.Connection = con1;

        con1.Open();
        dddivision.DataSource = cmd1.ExecuteReader();
        dddivision.DataTextField = "division_id";
        dddivision.DataValueField = "division_id";
        dddivision.DataBind();

        cmd1.Connection.Close();
        cmd1.Connection.Dispose();

    }
    public void populatedd2()
    {
        ddunitcode.Items.Add(new ListItem("-Select-", ""));
        ddunitcode.AppendDataBoundItems = true;

        OleDbConnection con2 = new OleDbConnection(ConfigurationManager.ConnectionStrings["vhgroupconnection"].ConnectionString);
        string query1 = "SELECT unitcode FROM unit_master";
        OleDbCommand cmd2 = new OleDbCommand();
        cmd2.CommandType = CommandType.Text;
        cmd2.CommandText = query1;
        cmd2.Connection = con2;

        con2.Open();
        ddunitcode.DataSource = cmd2.ExecuteReader();
        ddunitcode.DataTextField = "unitcode";
        ddunitcode.DataValueField = "unitcode";
        ddunitcode.DataBind();

        cmd2.Connection.Close();
        cmd2.Connection.Dispose();

    }
    public void populatedd3()
    {
        ddsba.Items.Add(new ListItem("-Select-", ""));
        ddsba.AppendDataBoundItems = true;

        OleDbConnection con3 = new OleDbConnection(ConfigurationManager.ConnectionStrings["vhgroupconnection"].ConnectionString);
        string query2 = "SELECT pc_code FROM sba_master";
        OleDbCommand cmd3 = new OleDbCommand();
        cmd3.CommandType = CommandType.Text;
        cmd3.CommandText = query2;
        cmd3.Connection = con3;

        con3.Open();
        ddsba.DataSource = cmd3.ExecuteReader();
        ddsba.DataTextField = "pc_code";
        ddsba.DataValueField = "pc_code";
        ddsba.DataBind();

        cmd3.Connection.Close();
        cmd3.Connection.Dispose();

    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            string div = dddivision.SelectedValue.ToString();
            string unit = ddunitcode.SelectedValue.ToString();
            string sba = ddsba.SelectedValue.ToString();
            OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["vhgroupconnection"].ConnectionString);
            string query = "SELECT user_id,passwd,dm.division_id,u.unitcode,sm.pc_code,empcode from register,division_master dm,unit_master u,sba_master sm ";
            int resilt = 0;
            using (con)
            {
                con.Open();
                using (OleDbCommand cmd = new OleDbCommand(query, con))
                {
                    cmd.Parameters.AddWithValue("user_id", txtuserid.Text);
                    cmd.Parameters.AddWithValue("passwd", txtpass.Text);
                    cmd.Parameters.AddWithValue("empcode", txtemp.Text);
                    cmd.Parameters.AddWithValue("division_id", div);
                    cmd.Parameters.AddWithValue("unitcode", unit);
                    cmd.Parameters.AddWithValue("pc_code", sba);

                 
                    resilt = (int)cmd.ExecuteScalar();


                }
                con.Close();
            }
            if (resilt > 0)
            {
                Response.Redirect("Home.aspx");
            }
            else
            {
                Response.Redirect("Error.aspx");
            }
        }
        catch (Exception ex)
        {
            Response.Write("Error In An Application :" + ex.StackTrace + ex.Message);
        }
    }
    protected void reset_Click(object sender, EventArgs e)
    {

    }

    protected void txtuserid_TextChanged(object sender, EventArgs e)
    {
        try
        {
            OleDbConnection myConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["vhgroupconnection"].ConnectionString);
           

            string qw = "select empcode from user_master where user_id = '" + txtuserid.Text + "'";

            
            OleDbCommand com = new OleDbCommand();
            com.Connection = myConn;
            
            com.CommandType = CommandType.Text;
            com.CommandText = qw;
            com.Connection = myConn;
            myConn.Open();

            txtemp.Text = com.ExecuteScalar().ToString();

            myConn.Close();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
}

推荐答案

而不是重新发明轮子，是否有你没有使用会员资格 [ ^ ] - 它非常容易使用，提供良好的安全性，并且可以通过进行非常简单的扩展。

实施自定义会员提供者

[ ^ ]

Rather than re-invent the wheel, is there a good reason why you aren''t using Membership[^] - it is very easy to use, provides good security, and can be extended very simply by
Implementing a custom Membership Provider
[^]

这篇关于asp.net中的LOgin页面，c＃，数据来自多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！