基本信息
源码名称:c# 读取网络上的access数据库(web)
源码大小:1.25M
文件格式:.zip
开发语言:C#
更新时间:2015-09-30
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300
本次赞助数额为: 2 元×
微信扫码支付:2 元
×
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
源码介绍
以web service形式调用的
以web service形式调用的
using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; namespace MyWebClient { /// <summary> /// Form1 的摘要说明。 /// </summary> public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.Panel panel1; private System.Windows.Forms.TextBox textBox1; private System.Windows.Forms.Label label2; private System.Windows.Forms.ComboBox comboBox1; private System.Windows.Forms.Label label1; private System.Windows.Forms.Button button1; private System.Windows.Forms.DataGrid dataGrid1; /// <summary> /// 必需的设计器变量。 /// </summary> private System.ComponentModel.Container components = null; public Form1() { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); // // TODO: 在 InitializeComponent 调用后添加任何构造函数代码 // } /// <summary> /// 清理所有正在使用的资源。 /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows 窗体设计器生成的代码 /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.panel1 = new System.Windows.Forms.Panel(); this.textBox1 = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.comboBox1 = new System.Windows.Forms.ComboBox(); this.label1 = new System.Windows.Forms.Label(); this.button1 = new System.Windows.Forms.Button(); this.dataGrid1 = new System.Windows.Forms.DataGrid(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.Controls.Add(this.textBox1); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.comboBox1); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.button1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(408, 40); this.panel1.TabIndex = 1; // // textBox1 // this.textBox1.Location = new System.Drawing.Point(256, 8); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(64, 21); this.textBox1.TabIndex = 4; this.textBox1.Text = ""; // // label2 // this.label2.Location = new System.Drawing.Point(184, 16); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(80, 16); this.label2.TabIndex = 3; this.label2.Text = "设置查询值:"; // // comboBox1 // this.comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.comboBox1.Items.AddRange(new object[] { "客户ID", "公司名称", "联系人姓名", "联系人头衔", "地址", "城市", "地区", "邮政编码", "国家", "电话", "传真"}); this.comboBox1.Location = new System.Drawing.Point(96, 8); this.comboBox1.Name = "comboBox1"; this.comboBox1.Size = new System.Drawing.Size(88, 20); this.comboBox1.TabIndex = 2; // // label1 // this.label1.Location = new System.Drawing.Point(8, 16); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(96, 16); this.label1.TabIndex = 1; this.label1.Text = "选择查询条件:"; // // button1 // this.button1.Location = new System.Drawing.Point(328, 8); this.button1.Name = "button1"; this.button1.TabIndex = 0; this.button1.Text = "开始查询"; this.button1.Click = new System.EventHandler(this.button1_Click); // // dataGrid1 // this.dataGrid1.CaptionVisible = false; this.dataGrid1.DataMember = ""; this.dataGrid1.Dock = System.Windows.Forms.DockStyle.Fill; this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Location = new System.Drawing.Point(0, 40); this.dataGrid1.Name = "dataGrid1"; this.dataGrid1.Size = new System.Drawing.Size(408, 254); this.dataGrid1.TabIndex = 3; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.ClientSize = new System.Drawing.Size(408, 294); this.Controls.Add(this.dataGrid1); this.Controls.Add(this.panel1); this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "演示以Web方式查询Access数据库"; this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.ResumeLayout(false); } #endregion /// <summary> /// 应用程序的主入口点。 /// </summary> [STAThread] static void Main() { Application.Run(new Form1()); } private void button1_Click(object sender, System.EventArgs e) {//以Web方式查询 Access数据库 if(this.comboBox1.Text.Length>1&&this.textBox1.Text.Length>1) { localhost.Service1 MyService=new localhost.Service1(); DataSet MySet=new DataSet(); string FieldName=this.comboBox1.Text; string FieldValue=this.textBox1.Text; MySet=MyService.GetCustomerInformation(FieldName,FieldValue); if(MySet!=null) { this.dataGrid1.DataSource=MySet; } } } } }