private void Button1_Click(object sender, System.EventArgs e)
{
SqlConnection con =new SqlConnection();
con.ConnectionString="uid=sa;server=(local);database=ffzp;pwd=;";
SqlCommand com=new SqlCommand();
com.CommandText="select *from admin where id=@id and pass=@pass ";
//'"+this.TextBox1.Text+"'";
com.Connection=con;
SqlParameter ap=new SqlParameter("@id",SqlDbType.VarChar,50);
ap.Value=this.TextBox1.Text;
SqlParameter ap1=new SqlParameter("@pass",SqlDbType.VarChar,50);
ap1.Value=this.TextBox2.Text;
com.Parameters.Add(ap);
com.Parameters.Add(ap1);
con.Open();
com.ExecuteNonQuery();

SqlDataReader sqlDr = com.ExecuteReader();

if(sqlDr.Read())
{
if (sqlDr.GetString(0)==ap.Value.ToString() && sqlDr.GetString(1)==ap1.Value.ToString())
{ this.Response.Redirect("admin_Edit.aspx");}

}
con.Close();
this.Response.Redirect("admin_Error.aspx");

}


自己写的一个登陆界面大家帮忙看下呀 有什么问题 告诉我呀
邮箱gzf0306@163.com


问题肯定是有的 现在5。1写个论坛 大家要是谁有好点原代码的话 一起发给我呀！
也不知道自己写的出来写不出来
不过也没什么老师回讲的 好有10几周呢！

private void Login_Load(object sender, System.EventArgs e)//获取用户名列表
{
this.AcceptButton=this.btnLogin ;//每次按回车进行确认
txt_Sa.Items.Clear();
string sql;
sql="select Adm_Name from Administrators";
SqlConnection myConn = new SqlConnection("workstation id=JWYABC;packet size=4096;user id=sa;initial catalog=fist1;persist security info=False");
SqlCommand myCommand=new SqlCommand(sql,myConn);
myConn.Open ();
SqlDataReader reader=myCommand.ExecuteReader();
while(reader.Read())
{
txt_Sa.Items.Add(reader.GetValue(0));
}
reader.Close();
myConn.Close();
}
private void btnLogin_Click_1(object sender, System.EventArgs e)
{
string sql;
sql="select * from administrators where Adm_Name='"+ txt_Sa.Text.Trim() +"' and Adm_Pwd='"+ txt_Pwd.Text.Trim() +"'";
SqlConnection myConn = new SqlConnection("workstation id=JWYABC;packet size=4096;user id=sa;initial catalog=fist1;persist security info=False");
SqlCommand myCommand=new SqlCommand(sql,myConn);

myConn.Open ();

int count=Convert.ToInt32(myCommand.ExecuteScalar());

if(count>0)
{
this.Close();
}
else
{
MessageBox.Show("您输入的帐号或密码有误，请重新登录！");
}
}

这个是在winform里面写的代码 你看看吧

有完整的代码提供吗??

或者程序

如果要在跳转页面时加个链接目标该怎么写?

我不懂winform?

Form F2=new Form();
F2.Show();

顶楼上！

sql="select * from administrators where Adm_Name='"+ txt_Sa.Text.Trim() +"' and Adm_Pwd='"+ txt_Pwd.Text.Trim() +"'";
这句对吗？sql后面的=是不是应该换成（）啊。