ASP中调用SQL字段,C#

来源：百度知道 编辑：UC知道 时间：2024/06/18 06:38:00
表里有id，name，password三个字段，我要实现登录。id用不到，控件有Label1，name_text，pw_text，login_button，SqlDataSource1。怎么整合啊？
我原先在login_button_Click里写得
if(name_text!="select name from member")
Label1.text=“不存在”
if(pw_text!="select password from member where name='name_text.text'")
Label1.text=“密码不对”

后来发现完全不是那么回事~没学过C，还请各位多指点~

写的什么玩意儿。

SqlConnection con = new SqlConnection(@"server=.;database=DA;uid=sa;pwd=;");
string sql = "select count(*) from member where name = '张三' and pwd = 'zhangsan'";
SqlCommand cmd = new SqlCommand(sql, con);

int i = Convert.ToInt32(cmd.ExecuteScalar());
if(i == 0)
//密码错误或用户名不正确
else
//正确

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

//登陆最好还是用类来实现，本来我是用三层架构写的，现在为了方便我整合一下，并附上详细注释
namespace WebApplication1
{
public partial class _Default : System.Web.UI.Page
{
public class Member
{
private int _ID;