|
//连接数据库:
<appSettings>
<add key="sqllink" value="server=yfq-001;uid=ADM;pwd=sdadm;database=DBMT50"></add>
</appSettings>
//登录
string connstr=System.Configuration.ConfigurationSettings.AppSettings["sqllink"];
SqlConnection conn=new SqlConnection(connstr);
conn.Open();
string sql="select count(*) as icount from sysoper where logname=''''"+this.usrname.Text+"''''";
SqlCommand comm=new SqlCommand(sql,conn);
SqlDataReader dr1=comm.ExecuteReader();
dr1.Read();
string count=dr1["icount"].ToString();
dr1.Close();
if(count!="0")
{
sql="select * from sys where logname=''''"+this.usrname.Text+"''''";
SqlCommand comm1=new SqlCommand(sql,conn);
SqlDataReader dr=comm1.ExecuteReader();
dr.Read();
string drpwd=dr["logpass"].ToString();
dr.Close();
if(drpwd==this.usrpwd.Text)
{
this.Session["logid"]=this.usrname.Text.Trim();
if(dr["PLCName"].ToString()=="")
{
this.Session["level"]="1";
}
if(dr["PLCName"].ToString()!="")
{
this.Session["level"]="2";
this.Session["plcname"]=dr["PLCName"].ToString();
}
this.Response.Redirect("main.aspx");
}
else
{
this.Response.Write("<script>alert(''''登录密码错误！'''')</script>");
}
}
if(count=="0")
{
this.Response.Write("<script>alert(''''没有这个用户！'''')</script>");
}
//框架的使用
<HTML>
<HEAD>
<TITLE>xxxxx</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>
<frameset rows="60,*" cols="*" border="0" frameSpacing="0" frameBorder="0">
<frame name="topFrame" src="top.aspx" scrolling="no" noresize>
<frameset style="CURSOR: w-resize" border="0" frameSpacing="12" frameBorder="yes" cols="143,74%">
<frame name="leftFrame" borderColor="#99ccff" src="left.aspx">
<frame name="mainFrame" src="bottom.htm">
</frameset>
</frameset>
</HTML>
//treeview的使用
<iewc:TreeNode NavigateUrl="aa/bb.aspx" Text="设置" Target="mainFrame"></iewc:TreeNode>
//DataGrid的应用
//动态添加列
BoundColumn column1=new BoundColumn();
column1.HeaderText="用户";
column1.DataField="UsrName";
column1.HeaderStyle.Wrap=false;
column1.ItemStyle.Wrap=false;
column1.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
column1.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(column1); HyperLinkColumn linkcolumn=new HyperLinkColumn();
linkcolumn.HeaderText="帐号";
linkcolumn.DataNavigateUrlField="actid";
linkcolumn.DataTextField="actid";
//linkcolumn.DataNavigateUrlFormatString="bak.aspx?actid={0}";
linkcolumn.DataNavigateUrlFormatString="javascript:varwin=window.open(''''bak.aspx?id={0}'''');window.close()";
linkcolumn.HeaderStyle.Wrap=false;
linkcolumn.ItemStyle.Wrap=false;
linkcolumn.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
linkcolumn.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(linkcolumn); HyperLinkColumn linkcolumn1=new HyperLinkColumn();
linkcolumn1.DataNavigateUrlField="actid";
linkcolumn1.HeaderText="修改";
linkcolumn1.Text="修改";
linkcolumn1.DataNavigateUrlFormatString="edit_usr.aspx?actid={0}";
linkcolumn1.HeaderStyle.Wrap=false;
linkcolumn1.ItemStyle.Wrap=false;
linkcolumn1.Visible=true;
linkcolumn1.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
linkcolumn1.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(linkcolumn1); HyperLinkColumn linkcolumn2=new HyperLinkColumn();
linkcolumn2.DataNavigateUrlField="actid";
linkcolumn2.HeaderText="删除";
linkcolumn2.Text="删除";
linkcolumn2.DataNavigateUrlFormatString="del.aspx?actid={0}";
linkcolumn2.HeaderStyle.Wrap=false;
linkcolumn2.ItemStyle.Wrap=false;
linkcolumn2.Visible=true;
linkcolumn2.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
linkcolumn2.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(linkcolumn2); string connstr=System.Configuration.ConfigurationSettings.AppSettings["sqllink"];
SqlConnection conn=new SqlConnection(connstr);
conn.Open();
string sql="select * from usract";
SqlDataAdapter dr=new SqlDataAdapter(sql,conn);
DataSet ds=new DataSet();
dr.Fill(ds,"usract");
this.DataGrid1.DataSource=ds.Tables["usr"].DefaultView;
this.DataGrid1.DataBind();
this.record.Text="共" + ds.Tables["usr"].Rows.Count.ToString() + "条";
this.pagenow.Text="第" +(this.DataGrid1.CurrentPageIndex + 1).ToString() +"/";
this.pagetotal.Text=this.DataGrid1.PageCount.ToString ()+"页";
this.DropDownList1.Items.Clear();
for(int i=1;i<=this.DataGrid1.PageCount;i++)
{
this.DropDownList1.Items.Add(i.ToString());
}
this.DropDownList1.Items[(this.DataGrid1.CurrentPageIndex)].Selected=true;
this.DropDownList1.SelectedItem.Text =(this.DataGrid1 .CurrentPageIndex+1).ToString();
//默认分页
public void NavigateToPage(object sender, System.EventArgs e)
{
string PageInfo = ((LinkButton)sender).CommandName;
switch (PageInfo)
{
case "第一页":
DataGrid1.CurrentPageIndex = 0;
break;
case "上一页":
if (DataGrid1.CurrentPageIndex > 0)
DataGrid1.CurrentPageIndex -= 1;
break;
case "下一页":
if (DataGrid1.CurrentPageIndex < (DataGrid1.PageCount - 1))
DataGrid1.CurrentPageIndex += 1;
break;
case "最后一页":
DataGrid1.CurrentPageIndex = (DataGrid1.PageCount - 1);
break;
}
this.linkdb();
}
//跳页
this.DataGrid1.CurrentPageIndex=Convert.ToInt32(this.DropDownList1.SelectedItem.Text)-1;
this.linkdb();
//分页条
<TABLE id="Table2" cellSpacing="0" cellPadding="0" width="512" align="left" border="0" runat="server" style="WIDTH: 512px; HEIGHT: 22px">
<TR>
<TD noWrap>
<p align="center">
<asp:label id="Label1" runat="server" ForeColor="White">每页显示20条记录</asp:label></p>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
<asp:label id="record" runat="server" ForeColor="White">Label</asp:label>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
<asp:label id="pagenow" runat="server" ForeColor="White">Label</asp:label>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
<asp:label id="pagetotal" runat="server" ForeColor="White">Label</asp:label>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
asp:linkbutton id="btnFirstPage" onclick="NavigateToPage" runat="server" ForeColor="White" CommandName="第一页">首页 </asp:linkbutton>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
<asp:linkbutton id="btnPreviousPage" onclick="NavigateToPage" runat="server" ForeColor="White" CommandName="上一页">上一页 </asp:linkbutton>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
<asp:linkbutton id="btnNextPage" onclick="NavigateToPage" runat="server" ForeColor="White" CommandName="下一页">下一页 </asp:linkbutton>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
<asp:linkbutton id="btnLastPage" onclick="NavigateToPage" runat="server" ForeColor="White" CommandName="最后一页">末页 </asp:linkbutton>
</TD>
<TD noWrap width="5"></TD>
<TD noWrap>
<asp:label id="Label2" runat="server" ForeColor="White" Width="54px">跳转到</asp:label>
</TD>
<TD noWrap width="5"></TD>
<T [1] [2] 下一页 | 
