WEB开发网
开发学院WEB开发ASP.NET DataGrid实例(简单易懂,无复杂功能,适合初学者... 阅读

DataGrid实例(简单易懂,无复杂功能,适合初学者)

 2006-04-02 17:05:16 来源:WEB开发网   
核心提示:使access数据库,适合初学者,DataGrid实例(简单易懂,无复杂功能,适合初学者),修改连接、查询语句后可直接运行,代码中有注明

使access数据库,适合初学者,修改连接、查询语句后可直接运行,代码中有注明。

  填充DataSet的步骤
    1、使用数据库连接字符串创建数据库连接对象
    2、用SQL查询语句和数据库连接对象创建数据库适配器dataAdapter
    3、使用DataAdapter的Fill 方法填充DataSet


using System;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
//PRofessional C# 2nd的DATAGRID实例
/**////   <summary>
///   This class provides   an example of creating and using a data   grid.
///   </summary>
public class DisplayTabularData : System.Windows.Forms.Form
{
   private System.Windows.Forms.Button retrieveButton;
   private System.Windows.Forms.DataGrid dataGrid;

   /**////   <summary>
   ///   Construct the window.
   ///   </summary>
   ///   <remarks>
   ///   This method   constructs the window by creating both the data   grid and the button.
   ///   </remarks>
   public DisplayTabularData()
   {
     this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
     this.ClientSize = new System.Drawing.Size(464, 253);
     this.Text = "01_DisplayTabularData";
     this.dataGrid = new System.Windows.Forms.DataGrid();
     dataGrid.BeginInit();
     dataGrid.Location = new System.Drawing.Point(8, 8);
     dataGrid.Size = new System.Drawing.Size(448, 208);
     dataGrid.TabIndex = 0;
     dataGrid.Anchor = AnchorStyles.Bottom | AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right;
     this.Controls.Add(this.dataGrid);
     dataGrid.EndInit();
     this.retrieveButton = new System.Windows.Forms.Button();
     retrieveButton.Location = new System.Drawing.Point(384, 224);
     retrieveButton.Size = new System.Drawing.Size(75, 23);
     retrieveButton.TabIndex = 1;
     retrieveButton.Anchor = AnchorStyles.Bottom | AnchorStyles.Right;
     retrieveButton.Text = "Retrieve";
     retrieveButton.Click += new System.EventHandler(this.retrieveButton_Click);
     this.Controls.Add(this.retrieveButton);
   }

   /**////   <summary>
   ///   Retrieve the data
   ///   </summary>
   ///   <param name="sender"> </param>
   ///   <param name="e"> </param>
   protected void retrieveButton_Click(object sender, System.EventArgs e)
   {
     retrieveButton.Enabled = false;

   string source = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Manio\My Documents\PrintManager\program\PrintManageV1\DataBase\PrintDB.mdb";
     string select = "SELECT * FROM MainInfo";

   /**/////////////////////////////////
     //填充DataSet的步骤
     //1、使用数据库连接字符串创建数据库连接对象
     //   2、用SQL查询语句和数据库连接对象创建数据库适配器dataAdapter
     //     3、使用DataAdapter的Fill 方法填充DataSet

   OleDbConnection OleCon = new OleDbConnection(source);

   OleDbDataAdapter da = new OleDbDataAdapter(select,OleCon);

   DataSet ds = new DataSet();

   da.Fill(ds, "MainInfo");

   dataGrid.SetDataBinding(ds, "MainInfo");   //DataGrid的数据绑定,使用DataSet 和 数据库的表名
   }

   /**////   <summary>
   ///   Display   the   application   window
   ///   </summary>
   static void Main()
   {
     Application.Run(new DisplayTabularData());
   }
}

Tags:DataGrid 实例 简单

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接