⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 select.aspx.cs

📁 主要功能： 1、 包括顾客信息、货品信息、定单信息的管理。 2、 按月统计销售业绩。 3、 报表设计。 4、 系统维护。
💻 CS
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

namespace jd
{
	/// <summary>
	/// WebForm5 的摘要说明。
	/// </summary>
	public class WebForm5 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink HyperLink6;
		protected System.Web.UI.WebControls.HyperLink HyperLink5;
		protected System.Web.UI.WebControls.HyperLink HyperLink4;
		protected System.Web.UI.WebControls.HyperLink HyperLink3;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.Image Image3;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Image Image23;
		protected System.Web.UI.WebControls.Panel Panel4;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Image Image2;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Image Image4;
		protected System.Web.UI.WebControls.Panel Panel2;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.HyperLink HyperLink10;
		protected System.Web.UI.WebControls.HyperLink HyperLink9;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.HtmlControls.HtmlTable Table1;
		protected System.Web.UI.WebControls.Panel Panel3;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.LinkButton LinkButton2;
		protected System.Web.UI.WebControls.LinkButton LinkButton3;
		protected System.Web.UI.WebControls.LinkButton LinkButton4;
		protected System.Web.UI.WebControls.LinkButton LinkButton5;
		protected System.Web.UI.WebControls.LinkButton LinkButton6;
		protected System.Web.UI.WebControls.LinkButton LinkButton7;
		protected System.Web.UI.WebControls.LinkButton LinkButton8;
		protected System.Web.UI.WebControls.Panel Panel5;
		protected System.Web.UI.WebControls.LinkButton LinkButton13;
		protected System.Web.UI.WebControls.LinkButton LinkButton14;
		protected System.Web.UI.WebControls.Panel Panel6;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label12;
		protected System.Web.UI.WebControls.Label Label13;
		protected System.Web.UI.WebControls.Label Label15;
		protected System.Web.UI.WebControls.Label Label17;
		protected System.Web.UI.WebControls.Label Label19;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Panel P1;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.WebControls.Label Label21;
		protected System.Web.UI.WebControls.Label Label23;
		protected System.Web.UI.WebControls.Label Label25;
		protected System.Web.UI.WebControls.Label Label27;
		protected System.Web.UI.WebControls.Label Label29;
		protected System.Web.UI.WebControls.Label Label31;
		protected System.Web.UI.WebControls.Panel P2;
		protected System.Web.UI.WebControls.Button Button7;
		protected System.Web.UI.WebControls.Button Button8;
		protected System.Web.UI.WebControls.Button Button9;
		protected System.Web.UI.WebControls.Label Label33;
		protected System.Web.UI.WebControls.Label Label35;
		protected System.Web.UI.WebControls.Label Label37;
		protected System.Web.UI.WebControls.Label Label39;
		protected System.Web.UI.WebControls.Label Label41;
		protected System.Web.UI.WebControls.Label Label43;
		protected System.Web.UI.WebControls.Panel P3;
		protected System.Web.UI.WebControls.Label H1;
		protected System.Web.UI.WebControls.Label H2;
		protected System.Web.UI.WebControls.Label H3;
		protected System.Web.UI.WebControls.Label H4;
		protected System.Web.UI.WebControls.Label H5;
		protected System.Web.UI.WebControls.Label H6;
		protected System.Web.UI.WebControls.Label H13;
		protected System.Web.UI.WebControls.Label H14;
		protected System.Web.UI.WebControls.Label H15;
		protected System.Web.UI.WebControls.Label H16;
		protected System.Web.UI.WebControls.Label H17;
		protected System.Web.UI.WebControls.Label H18;
		protected System.Web.UI.WebControls.Label H7;
		protected System.Web.UI.WebControls.Label H8;
		protected System.Web.UI.WebControls.Label H9;
		protected System.Web.UI.WebControls.Label H10;
		protected System.Web.UI.WebControls.Label H11;
		protected System.Web.UI.WebControls.Label H12;
		protected System.Web.UI.WebControls.TextBox T13;
		protected System.Web.UI.WebControls.TextBox T14;
		protected System.Web.UI.WebControls.TextBox T15;
		protected System.Web.UI.WebControls.TextBox T16;
		protected System.Web.UI.WebControls.TextBox T17;
		protected System.Web.UI.WebControls.TextBox T18;
		protected System.Web.UI.WebControls.TextBox T7;
		protected System.Web.UI.WebControls.TextBox T8;
		protected System.Web.UI.WebControls.TextBox T9;
		protected System.Web.UI.WebControls.TextBox T10;
		protected System.Web.UI.WebControls.TextBox T11;
		protected System.Web.UI.WebControls.TextBox T12;
		protected System.Web.UI.WebControls.TextBox T1;
		protected System.Web.UI.WebControls.TextBox T2;
		protected System.Web.UI.WebControls.TextBox T3;
		protected System.Web.UI.WebControls.TextBox T4;
		protected System.Web.UI.WebControls.TextBox T5;
		protected System.Web.UI.WebControls.TextBox T6;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.TextBox TextBox6;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.Label Label14;
		protected System.Web.UI.WebControls.Label Label16;
		protected System.Web.UI.WebControls.Label Label18;
		protected System.Web.UI.WebControls.Label Label20;
		protected System.Web.UI.WebControls.Label Label22;
		protected System.Web.UI.WebControls.Label Label24;
		protected System.Web.UI.WebControls.Label LL;
		protected System.Web.UI.WebControls.DropDownList DD;
		protected System.Web.UI.WebControls.Label Label26;
		protected System.Web.UI.WebControls.DropDownList DD1;
		protected System.Web.UI.WebControls.Panel Pa;
		protected System.Web.UI.WebControls.Panel Pa1;
		protected System.Web.UI.WebControls.DropDownList PP1;
		protected System.Web.UI.WebControls.Label Label11;
		protected System.Web.UI.WebControls.DropDownList PP;
		protected System.Web.UI.WebControls.Label Label28;
		protected System.Web.UI.WebControls.Panel Pa2;
		protected System.Web.UI.WebControls.Label Label30;
		protected System.Web.UI.WebControls.Label Label32;
		protected System.Web.UI.WebControls.Label Label34;
		protected System.Web.UI.WebControls.Label Label36;
		protected System.Web.UI.WebControls.Label Label38;
		protected System.Web.UI.WebControls.Label Label40;
		protected System.Web.UI.WebControls.Label Label42;
		protected System.Web.UI.WebControls.TextBox TextBox12;
		protected System.Web.UI.WebControls.TextBox TextBox9;
		protected System.Web.UI.WebControls.TextBox TextBox11;
		protected System.Web.UI.WebControls.TextBox TextBox8;
		protected System.Web.UI.WebControls.TextBox TextBox10;
		protected System.Web.UI.WebControls.TextBox TextBox7;
		protected System.Web.UI.WebControls.DropDownList QQ1;
		protected System.Web.UI.WebControls.Label Label44;
		protected System.Web.UI.WebControls.DropDownList QQ;
		protected System.Web.UI.WebControls.Label Label45;
		protected System.Web.UI.WebControls.Label Label46;
		protected System.Web.UI.WebControls.Label Label47;
		protected System.Web.UI.WebControls.Label Label48;
		protected System.Web.UI.WebControls.Label Label49;
		protected System.Web.UI.WebControls.Label Label50;
		protected System.Web.UI.WebControls.Label Label51;
		protected System.Web.UI.WebControls.Label Label52;
		protected System.Web.UI.WebControls.TextBox TextBox18;
		protected System.Web.UI.WebControls.TextBox TextBox15;
		protected System.Web.UI.WebControls.TextBox TextBox17;
		protected System.Web.UI.WebControls.TextBox TextBox14;
		protected System.Web.UI.WebControls.TextBox TextBox16;
		protected System.Web.UI.WebControls.TextBox TextBox13;
		protected System.Web.UI.WebControls.Button butt9;
		protected System.Web.UI.WebControls.Button butt10;
		protected System.Web.UI.WebControls.Button butt11;
		protected System.Web.UI.WebControls.Button butt12;
		protected System.Web.UI.WebControls.Button butt5;
		protected System.Web.UI.WebControls.Button butt6;
		protected System.Web.UI.WebControls.Button butt7;
		protected System.Web.UI.WebControls.Button butt8;
		protected System.Web.UI.WebControls.Button butt1;
		protected System.Web.UI.WebControls.Button butt2;
		protected System.Web.UI.WebControls.Button butt3;
		protected System.Web.UI.WebControls.Button butt4;
		protected System.Web.UI.WebControls.Button seve1;
		protected System.Web.UI.WebControls.Button seve3;
		protected System.Web.UI.WebControls.Button seve2;
		protected System.Web.UI.WebControls.Label Label53;
		protected System.Web.UI.WebControls.TextBox TB1;
		protected System.Web.UI.WebControls.TextBox TB2;
		protected System.Web.UI.WebControls.Button clear2;
		protected System.Web.UI.WebControls.Panel Paaa;
		protected System.Web.UI.WebControls.Panel Paa;
		protected System.Web.UI.WebControls.Panel Pa3;
		protected System.Web.UI.WebControls.Label Label54;
		protected System.Web.UI.WebControls.Label Label55;
		protected System.Web.UI.WebControls.TextBox TB3;
		protected System.Web.UI.WebControls.Button clear3;
		protected System.Web.UI.HtmlControls.HtmlTableCell TD1;
		protected System.Web.UI.HtmlControls.HtmlTable Table2;
		protected System.Web.UI.HtmlControls.HtmlTable Table4;
		protected System.Web.UI.HtmlControls.HtmlTable Table3;
		protected System.Web.UI.WebControls.Button clear1;
		protected System.Web.UI.WebControls.Panel Panel7;
		protected System.Web.UI.WebControls.Label Label56;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.Label Label57;
		protected System.Web.UI.WebControls.Label Label58;
		protected System.Web.UI.WebControls.Label Label59;
		protected System.Web.UI.WebControls.Label Label60;
		protected System.Web.UI.WebControls.Label Label61;
		protected System.Web.UI.WebControls.Label Label62;
		protected System.Web.UI.WebControls.Label Label63;
		protected System.Web.UI.WebControls.TextBox TT1;
		protected System.Web.UI.WebControls.TextBox TT2;
		protected System.Web.UI.WebControls.Label Label64;
		protected System.Web.UI.WebControls.TextBox TT3;
		protected System.Web.UI.HtmlControls.HtmlTable Table5;
		protected System.Web.UI.WebControls.TextBox TT6;
		protected System.Web.UI.WebControls.TextBox TT7;
		protected System.Web.UI.WebControls.TextBox TT8;
		protected System.Web.UI.WebControls.TextBox TT9;
		protected System.Web.UI.WebControls.TextBox TT4;
		protected System.Web.UI.WebControls.Label Label65;
		protected System.Web.UI.WebControls.TextBox TT5;
		protected System.Web.UI.WebControls.Label Label66;
		protected System.Web.UI.WebControls.TextBox TT10;
		protected System.Web.UI.WebControls.Button Btt5;
		protected System.Web.UI.WebControls.Button Btt4;
		protected System.Web.UI.WebControls.Button Btt3;
		protected System.Web.UI.WebControls.Button Btt2;
		protected System.Web.UI.WebControls.Button Btt1;
		protected System.Web.UI.WebControls.Button Btt6;
		protected System.Web.UI.WebControls.Label Label67;
		protected System.Web.UI.WebControls.Label Label68;
		protected System.Web.UI.WebControls.Label Label69;
		protected System.Web.UI.WebControls.Label Label70;
		protected System.Web.UI.WebControls.Label Label71;
		protected System.Web.UI.WebControls.Label Label72;
		protected System.Web.UI.WebControls.Label Label73;
		protected System.Web.UI.WebControls.Label Label74;
		protected System.Web.UI.WebControls.Label Label75;
		protected System.Web.UI.WebControls.Label Label76;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.Label Label77;
		protected System.Web.UI.WebControls.Panel Panel8;
		protected System.Web.UI.HtmlControls.HtmlTable Table6;
		protected System.Web.UI.WebControls.TextBox TTT10;
		protected System.Web.UI.WebControls.TextBox TTT9;
		protected System.Web.UI.WebControls.TextBox TTT8;
		protected System.Web.UI.WebControls.TextBox TTT7;
		protected System.Web.UI.WebControls.TextBox TTT6;
		protected System.Web.UI.WebControls.TextBox TTT5;
		protected System.Web.UI.WebControls.TextBox TTT4;
		protected System.Web.UI.WebControls.TextBox TTT3;
		protected System.Web.UI.WebControls.TextBox TTT2;
		protected System.Web.UI.WebControls.TextBox TTT1;
		protected System.Web.UI.WebControls.Button Bt6;
		protected System.Web.UI.WebControls.Button Bt5;
		protected System.Web.UI.WebControls.Button Bt4;
		protected System.Web.UI.WebControls.Button Bt3;
		protected System.Web.UI.WebControls.Button Bt2;
		protected System.Web.UI.WebControls.Button Bt1;
		protected System.Web.UI.WebControls.Panel PPP1;
		protected System.Web.UI.WebControls.Panel PPP;
		protected System.Web.UI.WebControls.Label Label78;
		protected System.Web.UI.WebControls.Button G2;
		protected System.Web.UI.WebControls.Button G3;
		protected System.Web.UI.WebControls.Button G4;
		protected System.Web.UI.WebControls.Button G5;
		protected System.Web.UI.WebControls.Button G1;
		protected System.Web.UI.WebControls.TextBox Tex1;
		protected System.Web.UI.WebControls.TextBox Text2;
		protected System.Web.UI.WebControls.Panel Panel9;
		protected System.Web.UI.WebControls.DropDownList DropDownList3;
		protected System.Web.UI.WebControls.Label Label79;
		protected System.Web.UI.WebControls.Label Label80;
		protected System.Web.UI.WebControls.Label Label81;
		protected System.Web.UI.WebControls.Label L1;
		protected System.Web.UI.WebControls.Label L2;
		protected System.Web.UI.WebControls.Button buttonn3;
		protected System.Web.UI.WebControls.Button buttonn1;
		protected System.Web.UI.WebControls.TextBox Box2;
		protected System.Web.UI.WebControls.TextBox Box1;
		protected System.Web.UI.HtmlControls.HtmlTable Table7;
		protected System.Web.UI.WebControls.Panel Panel10;
		protected System.Web.UI.WebControls.Label Label82;
		protected System.Web.UI.WebControls.Label Label83;
		protected System.Web.UI.WebControls.Button butto2;
		protected System.Web.UI.WebControls.Image Image1;	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			this.Table7.Visible=false;//公告表格
			if(this.L2.Text!="")
			{
				this.Panel10.Visible=true;//登陆窗口
				this.Panel9.Visible=false;
			}
			else
			{
				this.Panel9.Visible=true;//登陆对话框
				this.Panel10.Visible=false;
			}
			string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
			OleDbConnection conn=new OleDbConnection(connstr);
			conn.Open();
			string sql1="select * from 家用电器";
			string sql2="select * from 厨房电器";
			string sql3="select * from 其它电器";
			OleDbCommand comm1=new OleDbCommand(sql1,conn);
			OleDbCommand comm2=new OleDbCommand(sql2,conn);
			OleDbCommand comm3=new OleDbCommand(sql3,conn);
			OleDbDataReader mydata1=comm1.ExecuteReader();
			
			while(mydata1.Read())//家用电器
			{
				for(int i=0;i<mydata1.FieldCount;i++)
				{
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -