<%@Page Language="C#"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<%@ Register TagPrefix="Deapart" TagName="connect" Src="..\global\connect_string.ascx" %><html><head>
<title>用户登陆</title>
<object id=closes type="application/x-oleobject"
classid="clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11">
<param name="Command" value="Close"></object>
</head>
<body>
<Deapart:connect id='ConStr' runat='Server'/>
<div id='outError' runat='Server'></div>
<div id='outResult' runat='Server'>
</div>
</body>
</html><!---------------------------------------------------------------------------------------------------->
<script Language="C#" runat="Server"> void Page_Load(Object sender, EventArgs e)
{
String SQLConn = ConStr.SQLCon;
String strSQL= "Select LogName,LogPass,IsAdmin,uLevel from UserLog where LogName='"+ Request.Form["name"]+"' and LogPass='"+Request.Form["pass"]+"' and IsAdmin='1'"; try
{
//连接数据库
SqlConnection objConnect = new SqlConnection(SQLConn);
objConnect.Open();
SqlCommand objCommand = new SqlCommand(strSQL,objConnect);
SqlDataReader objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read())
{
Session["UserName"] = objDataReader.GetString(0);
Session["UserLevel"] = objDataReader.GetByte(3); outResult.InnerHtml="<script language=JavaScript>";
outResult.InnerHtml+="window.open('adminmanager.htm','','FullScreen=1,toolbar=0');";
outResult.InnerHtml+="window.opener.location.reload(true);";
outResult.InnerHtml+="window.focus();";
outResult.InnerHtml+="closes.Click();<";
outResult.InnerHtml+="/script>";
}
else {
outResult.InnerHtml="用户名或密码有误 !!<br><br>如果您不是管理员,<br>请到“用户登陆”处登陆 !";
} objDataReader.Close();
objConnect.Close();
}
catch (Exception objError)
{
//显示错误细节
outError.InnerHtml = "<b>* Error while accessing data</b>.<br />"
+ objError.Message + "<br />" + objError.Source;
return; // 然后停止执行
}
}
</script>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<%@ Register TagPrefix="Deapart" TagName="connect" Src="..\global\connect_string.ascx" %><html><head>
<title>用户登陆</title>
<object id=closes type="application/x-oleobject"
classid="clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11">
<param name="Command" value="Close"></object>
</head>
<body>
<Deapart:connect id='ConStr' runat='Server'/>
<div id='outError' runat='Server'></div>
<div id='outResult' runat='Server'>
</div>
</body>
</html><!---------------------------------------------------------------------------------------------------->
<script Language="C#" runat="Server"> void Page_Load(Object sender, EventArgs e)
{
String SQLConn = ConStr.SQLCon;
String strSQL= "Select LogName,LogPass,IsAdmin,uLevel from UserLog where LogName='"+ Request.Form["name"]+"' and LogPass='"+Request.Form["pass"]+"' and IsAdmin='1'"; try
{
//连接数据库
SqlConnection objConnect = new SqlConnection(SQLConn);
objConnect.Open();
SqlCommand objCommand = new SqlCommand(strSQL,objConnect);
SqlDataReader objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read())
{
Session["UserName"] = objDataReader.GetString(0);
Session["UserLevel"] = objDataReader.GetByte(3); outResult.InnerHtml="<script language=JavaScript>";
outResult.InnerHtml+="window.open('adminmanager.htm','','FullScreen=1,toolbar=0');";
outResult.InnerHtml+="window.opener.location.reload(true);";
outResult.InnerHtml+="window.focus();";
outResult.InnerHtml+="closes.Click();<";
outResult.InnerHtml+="/script>";
}
else {
outResult.InnerHtml="用户名或密码有误 !!<br><br>如果您不是管理员,<br>请到“用户登陆”处登陆 !";
} objDataReader.Close();
objConnect.Close();
}
catch (Exception objError)
{
//显示错误细节
outError.InnerHtml = "<b>* Error while accessing data</b>.<br />"
+ objError.Message + "<br />" + objError.Source;
return; // 然后停止执行
}
}
</script>
解决方案 »
- 大家帮忙啊 类型转换 PowerBuilder的date类型怎么用C#转?
- web页面中内嵌WORD(VS2008装OfficeControl.ocx)
- 用户上传了过大文件如何处理?
- c# winform 从mysql怎样取得数据库的全部表名,绑定到ComboBox1,再取得特定表的全部列,放到textBox1里。
- 框架滚动条显示问题
- 这个人才网,我做了一半,传到了空间上,大家看看还有没有必要做下去》》》
- 请问在asp.net中怎么样实现打印功能
- 怎样连接MYSQL的数据库???
- 关于刷新的问题!
- asp.net入门,有什么书可以推荐吗?
- 如何得到正在编辑状态的一个列的值
- 一个超级简单的问题呵呵~~关于form的runat属性~~~怎么解决?
<%@Control Language="C#"%><script language="C#" runat="server"> public string SQLCon
{
get {return ConfigurationSettings.AppSettings["7thDeSql"];}
} </script>
webconfig:<configuration>
<appSettings>
<add key="7thDeSql" value="server=localhost; database=7thDe; Uid=sa;pwd=" />
</appSettings></configuration>
using System.Data.SqlClientSqlConnection myConn=new SqlConnection(connStr);
SqlCommand myCmd=newSqlCommand("select * from mytalbe",myConn);
SqlDataAdapter myAd=new SqlDataAdapter();
SqlDataAdapter.SelectCommand=myCmd;
DataSet myds=new DataSet();
myAd.Fill(myDs);this.DataGrid1.DataSource=myds;
this.DataGrid1.DataBind();
启动osql查询工具时提示 sql server不存在或访问被拒绝……