string connstr = (new DBConnStr()).Connstr;
OleDbConnection conn = new OleDbConnection(connstr);
DataSet ds = new DataSet();;
OleDbDataAdapter da;
try
{
conn.Open();
string select = "SELECT ID, LogonName, Power FROM User where LogonName='Admin' " ;
Response.Write(select + "<hr>") ; da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand(select,conn);
da.Fill(ds,"User");
if (ds.Tables["User"].Rows.Count != 0 )
{
if ( name == "游客")
return ds.Tables["User"].Rows[3].ToString();
else
{
if (pwd == ds.Tables["User"].Rows[2].ToString())
return ds.Tables["User"].Rows[3].ToString();
else
{
Response.Write("您输入的注册名或者密码错误,请重新输入 ... ");
return "";
}
}
conn.Close();
}
}
catch (System.Exception ie)
{
Response.Write("程序错误,请检查数据库连接 ... Logon.aspx.cs <br>"
+ ie.Message.ToString() );
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
OleDbConnection conn = new OleDbConnection(connstr);
DataSet ds = new DataSet();;
OleDbDataAdapter da;
try
{
conn.Open();
string select = "SELECT ID, LogonName, Power FROM User where LogonName='Admin' " ;
Response.Write(select + "<hr>") ; da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand(select,conn);
da.Fill(ds,"User");
if (ds.Tables["User"].Rows.Count != 0 )
{
if ( name == "游客")
return ds.Tables["User"].Rows[3].ToString();
else
{
if (pwd == ds.Tables["User"].Rows[2].ToString())
return ds.Tables["User"].Rows[3].ToString();
else
{
Response.Write("您输入的注册名或者密码错误,请重新输入 ... ");
return "";
}
}
conn.Close();
}
}
catch (System.Exception ie)
{
Response.Write("程序错误,请检查数据库连接 ... Logon.aspx.cs <br>"
+ ie.Message.ToString() );
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
解决方案 »
- Page.ClientScript.RegisterStartupScript
- 安装.netframeword3.5后的问题
- 关于使用window.close()方法关闭游览器窗口
- gridview控件中有一按钮列,想实现点击后取出所在行的某列的内容该怎么办?
- 大家是否知道支持.net2.0的URLRewriter
- 有什么办法让xml自动生成xsl文件?或者在写(xmltextwriter)xml文件的时候产生xsl?
- 怎么处理DataGrid模板列里的TextBox翻页后值被清空的问题?
- 打印动态页面的问题
- 动态加载用户控件的布局问题
- PDFBOX修改PDF
- WEB上显示透明.gif的问题,请高手出手相救
- 【【【 求一种好的解决方案!!! 】】】
SELECT ID, LogonName, Power FROM User where LogonName='Admin'
--------------------------------------------------------------------------------
程序错误,请检查数据库连接 ... Logon.aspx.cs
FROM 子句语法错误。
string select = "SELECT ID, LogonName, Power FROM User where LogonName='Admin' " ;
select * from user where logonName ='Admin'这一句也不行
da.SelectCommand.ExecuteNonQuery ()
连接字符串不可能错误, 因为这一句都是对的
上CSDN问问就行了,呵呵