c# 读取网络上的access数据库(web)

以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;}}}}}