<%@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>
解决方案 »
- 【根据dropdownlist的selectIndex或SelectValue的改变,更改gridview的ObjectDataSource绑定】的问题
- 十万火急!!!!
- e.item.Cells[n]的索引问题! 未助.
- 网页中播放视频的问题
- 刚开发完成的网站 6300.ccou.cn 大家感觉如何 帮忙评评
- asp.net2.0 地址重写
- 如何在WEB下点击按钮执行本地文件
- 请问,在asp.net中连接sql server 的账号密码是放在哪里?
- 各位大老幫幫手啦﹗
- .NET空间被删除,极度郁闷~,内容将全部转移到http://xml.sz.luohuedu.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不存在或访问被拒绝……