//连接数据库: <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] 下一页 [C语言系列]NET 中C#的switch语句的语法 [系统软件]托拽Explore中的文件到VB.net的窗口 [系统软件]Boost库在XP+Visual C++.net中的安装 [常用软件]新配色面板:Paint.Net3.0RC1官方下载 [常用软件]用内建的“Net Meeting”聊天 [VB.NET程序]Henry的VB.NET之旅(三)—共享成员 [VB.NET程序]Henry的VB.NET之旅(二)—构造与析构 [VB.NET程序]Henry的VB.NET之旅(一)—失踪的窗体 [VB.NET程序]在托盘上显示Balloon Tooltip(VB.NET) [VB.NET程序]Henry手记-VB.NET中动态加载Treeview节点(二)
|