关闭

SQL_搜索语句

69人阅读 评论(0) 收藏 举报

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.Data.SqlClient;

 

//登录搜寻匹配例子

string cmdtext1 = "select * from Staff where s_logname='" + this.tname.Text +"' and s_password='" + this.tpass.Text + "'";  //Staff库,s_logname&s_password数据Design Name;

                SqlConnection con =new SqlConnection("Server=localhost;database=qcwx;uid=sa;pwd=sasasa"); //创建连接

                con.Open();

                SqlCommand cmd =new SqlCommand(cmdtext1, con);

                try

                {

                    SqlDataReader dr = cmd.ExecuteReader();

                    if (dr.Read())

                    {

 

                        MessageBox.Show("登录成功!");

                        sqlconn.Close();

                        Response.Redirect("user/Usermb.aspx");

 

                    }

                    else

                    {

                        MessageBox.Show("用户名或密码错误");

                        dr.Close();

                        con.Close();

                    }

                }

                catch (Exception err)

                {

                    Response.Write(err);

                }

 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:2195次
    • 积分:82
    • 等级:
    • 排名:千里之外
    • 原创:8篇
    • 转载:0篇
    • 译文:0篇
    • 评论:0条
    文章分类
    文章存档