我在该用户regstr中有一个登录表单作为新登录名，我该怎么做 [英] i have one login form in that user regstr as new login how can i do that

问题描述

这是我的代码，当我想单击链接按钮来注册新的我想打开注册表格时

我试图但没有得到这是我的代码.........


使用系统；
使用System.Collections.Generic;
使用System.Linq;
使用System.Web;
使用System.Web.UI;
使用System.Web.UI.WebControls;
使用System.Data.SqlClient;
使用System.Configuration;
使用System.Data;

公共局部类Default2:System.Web.UI.Page
{


SqlConnection con =新的SqlConnection("..............;初始目录= EmployeeDB;集成安全性= True");


受保护的void Page_Load(对象发送者，EventArgs e)
{

}

受保护的无效btnlogin_Click(对象发送者，EventArgs e)
{
con.Open();
SqlCommand cmd =新的SqlCommand(从用户名= @用户名和密码= @ Password的信息中选择*"，等等);
cmd.Parameters.AddWithValue("@ Username"，TextBox1.Text);
cmd.Parameters.AddWithValue("@ Password"，TextBox2.Text);
SqlDataAdapter广告=新的SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
如果(dt.Rows.Count> 0)
{
会话[用户名"] = TextBox1.Text;

Response.Redirect("Default3.aspx");
}
其他
{
Label3.Visible = true;
Label3.Text =无效的用户名和密码.... !!!";

}

}
受保护的void LinkBut​​ton1_Click(对象发送者，EventArgs e)
{
Response.Redirect("Default5.aspx");
}
}

this is my code when i want click linkbutton to register new i want to open register form

iam trying but not getting this is my code............


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class Default2 : System.Web.UI.Page
{


SqlConnection con = new SqlConnection("..............;Initial Catalog=EmployeeDB;Integrated Security=True");


protected void Page_Load(object sender, EventArgs e)
{

}

protected void btnlogin_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from information where Username=@Username and Password=@Password", con);
cmd.Parameters.AddWithValue("@Username", TextBox1.Text);
cmd.Parameters.AddWithValue("@Password", TextBox2.Text);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
Session["Username"] = TextBox1.Text;

Response.Redirect("Default3.aspx");
}
else
{
Label3.Visible = true;
Label3.Text = "Invalid username&password....!!!";

}

}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Response.Redirect("Default5.aspx");
}
}

推荐答案

hi，

protected void btnlogin_Click(object sender, EventArgs e)
    {
//stored proc is prefered .
      string statment =string.Format("select * from information where Username={0} and Password={1}",TextBox1.Text  ,TextBox2.Text)
      SqlCommand cmd = new SqlCommand(statment, con);
      cmd.CommandType = CommandType.Text;

        SqlDataAdapter ad = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        ad.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            Session["Username"] = TextBox1.Text;

            Response.Redirect("Default3.aspx");
        }
        else
        {
            Label3.Visible = true;
            Label3.Text = "Invalid username&password....!!!";

        }

    }

这篇关于我在该用户regstr中有一个登录表单作为新登录名，我该怎么做的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！