ÇÔ¸Õ¡ÒèѴ¡ÒÃâ«Å٪ѹͧ¤ì»ÃСͺÀÒÉÒµèÒ§ æ ã¹ Visual c#

¤ÇÒÁµéͧ¡ÒÃ

• ˹Ö觢ͧÃкº»¯ÔºÑµÔ¡ÒõèÍ仹Õé:
  • Microsoft Windows 2000 Professional (ËÃ×Íà«ÔÃì¿àÇÍÃì)
  • Microsoft Windows XP Professional ´éÇÂ.NET Framework ·ÕèµÔ´µÑé§
  • Microsoft Windows Server 2003
• Microsoft Visual Studio .NET ËÃ×Í Microsoft Visual Studio 2005
• Microsoft SQL Server ÃØè¹ 7.0 ËÃ×ÍÃØè¹ãËÁè¡ÇèÒ ´éÇ Northwind °Ò¹¢éÍÁÙÅ

• ÊÔ觷ÕèÊ׺·Í´¡ÒÃãªé§Ò¹
• Ẻ¿ÍÃìÁ windows
• ado.net

¨Ñ´¡ÒÃâ«Å٪ѹ¡ÒÃÊèǹ»ÃСͺ¢Í§ÀÒÉÒµèÒ§ æ

• â»Ãá¡ÃÁ»ÃÐÂØ¡µì Windows c# áÊ´§¼Å·ÕèãªéÇÔ¸Õ¡ÒÃ㹤ÅÒÊ·ÕèÊͧâ¤Ã§¡ÒÃÍ×è¹
• â¤Ã§¡ÒáÒà Visual Basic .NET ËÃ×ÍäźÃÒÃÕ 2005 ¢Í§ Visual Basic ·Õèà¢éÒ¶Ö§°Ò¹¢éÍÁÙÅ NorthWind áÅÐÊ觡ÅѺ¤èÒà»ç¹ªØ´¢éÍÁÙÅ
• äźÃÒ Visual c# ¤ÅÒÃÕâ¤Ã§¡Ò÷ÕèÁÕÇÔ¸Õ¡Ò÷Õ軯ԺѵԡÒÃArrayListʵÃÔ§·ÕèÇѵ¶ØáÅСÅѺ string à´ÕÂǹÑ蹤×Í concatenated â´ÂãªéÍÔ¹Êáµ¹«ì¢Í§¡ÒÃStringBuilder¤ÅÒÊ·Õè

1. ¤ÅÔ¡àÃÔèÁ¡Ò÷ӧҹªÕéä»·Õèâ»Ãá¡ÃÁáÅéÇ ªÕéä»ÂѧÍÂèÒ§ã´ÍÂèҧ˹Öè§Microsoft Visual Studio .NET(ÊÓËÃѺ Visual Studio .NET 2002),Microsoft Visual Studio .NET 2003(ÊÓËÃѺ Microsoft Visual Studio .NET 2003), ËÃ×ÍMicrosoft Visual Studio 2005(ÊÓËÃѺ Microsoft Visual Studio 2005)
2. ¤ÅÔ¡Microsoft Visual Studio .NETËÃ×ÍMicrosoft Visual Studio 2005.
3. ¤ÅÔ¡â¤Ã§¡ÒÃãËÁèáÅéÇ ¤ÅÔ¡áÊ´§â¤Ã§¡Òà c#
   
   ËÁÒÂà˵Ø:ã¹ Visual Studio 2005 ¤ÅÔ¡visual c#.
4. ÀÒÂãµéáÁèẺ¤ÅÔ¡á;ÅÔपѹ¢Í§ windows.
5. 㹡Òê×èÍ:¿ÔÅ´ì ª¹Ô´HowToMultiCompáÅéÇ ¤ÅÔ¡µ¡Å§.
6. àÁ×èÍÁÕÊÃéÒ§â¤Ã§¡Òà µÃǨÊͺãËéá¹èã¨ÇèÒ Explorer â«Å٪ѹ¡ÒÃÁͧàËç¹ä´é ¶éÒÁͧäÁèàËç¹ Explorer â«Å٪ѹ ¡´ CTRL + ALT + L
   
   ¢³Ð¹Õé¤Ø³ÊÒÁÒöàªÅÅì¢Í§á;ÅÔपѹ¢Í§ Visual c# Windows Forms 㹡ÒÃá¡é䢪×èÍ HowToMultiComp

1. ¤ÅÔ¡¢ÇÒã¹ Explorer â«Å٪ѹÇÔ¸Õ¡ÒÃá¡é䢻ѭËÒ 'HowToMultiComp'ªÕéä»·ÕèaddáÅéÇ ¤ÅÔ¡â¤Ã§¡ÒÃãËÁè.
2. ¤ÅÔ¡â¤Ã§¡Òà visual Basic.
   
   ËÁÒÂà˵Ø:ã¹ Visual Studio 2005 ¤ÅÔ¡visual Basic.
3. ÀÒÂãµéáÁèẺ¤ÅÔ¡äźÃÒÃÕ¤ÅÒÊ.
4. 㹡Òê×èÍ:¡Åèͧ ª¹Ô´NWClassLibáÅéÇ ¤ÅÔ¡µ¡Å§.
   
   Visual Basic .NET ËÃ×ÍäźÃÒÃÕ¤ÅÒÊ 2005 ¢Í§ Visual Basic ¶Ù¡à¾ÔèÁà¢éÒä»ã¹¡ÒÃá¡é䢻ѭËÒ
   
   Class1.vb¢³Ð¹Õéà»Ô´ÍÂÙèã¹µÑÇá¡éä¢Ë¹éÒµèÒ§
5. à¾ÔèÁÊͧ¹Óà¢éÒdirectives ·Õè´éÒ¹º¹à¾×èÍà¢éÒ shorthand ¨Ø´áÊ´§ÃдѺªÑé¹ã¹ namespaces ·ÕèµèÍ仹Õé:

   Imports System.Data
   Imports System.Data.SqlClient

6. àÁ×è͵éͧ¡ÒÃÊÃéÒ§ áÅСÃÍ¡¢éÍÁÙÅẺªØ´¢éÍÁÙÅÁÕ¢éÍÁÙŨҡµÒÃÒ§¼ÅÔµÀѳ±ì Northwind à¾ÔèÁ·ÕèÇÔ¸Õ¡ÒõèÍ仹ÕéClass1(¤Ø³ÍÒ¨µéͧ¡ÒûÃѺ»ÃاʵÃÔ§¡ÒÃàª×èÍÁµè͡Ѻ¤ÍÁ¾ÔÇàµÍÃì¢Í§¤Ø³):

   Public Shared Function GetProducts() As DataSet
   	Dim ds As New DataSet()
   	Dim sqlDS As New SqlDataAdapter("select * from products", New SqlConnection("server=<network address of instance of SQL Server>;database=northwind;integrated security=sspi"))
   	sqlDS.Fill(ds)
   	return ds
   End Function
   

1. ¤ÅÔ¡¢ÇÒã¹ Explorer â«Å٪ѹÇÔ¸Õ¡ÒÃá¡é䢻ѭËÒ 'HowToMultiComp'ªÕéä»·ÕèaddáÅéÇ ¤ÅÔ¡â¤Ã§¡ÒÃãËÁè.
2. ¤ÅÔ¡áÊ´§â¤Ã§¡Òà c#.
   
   ËÁÒÂà˵Ø:ã¹ Visual Studio 2005 ¤ÅÔ¡visual c#.
3. ÀÒÂãµéáÁèẺ¤ÅÔ¡äźÃÒÃÕ¤ÅÒÊ.
4. 㹡Òê×èÍ:¡Åèͧ ª¹Ô´SBClassLibáÅéÇ ¤ÅÔ¡µ¡Å§.
   
   à¾ÔèÁäź Visual c# ¤ÅÒÃÒÃÕà¾×èÍ¡ÒÃá¡é䢻ѭËÒ
   
   Class1.cs¢³Ð¹Õéà»Ô´ÍÂÙèã¹Ë¹éÒµèÒ§µÑÇá¡éä¢
5. à¾ÔèÁµèÍ仹Õé¡ÒÃãªédirectives ´éÒ¹º¹¢Í§µÑÇÍÂèÒ§¢Í§ÃËÑÊ Class1.cs à¢éÒ shorthand dot áÊ´§¡ÒÃà¢éÒ¶Ö§ÃдѺªÑé¹ã¹¹Ñé¹System.Textnamespace áÅÐSystem.Collectionsnamespace:

   using System.Text;
   using System.Collections;

6. à¾ÔèÁÃËÑʵèÍ仹Õé㹤ÅÒÊÒ¸ÒóРClass1«Öè§ãªéÍÔ¹Êáµ¹«ì¢Í§¡ÒÃStringBuilder¤ÅÒʢͧ¡Òà concatenate ʵÃÔ§·Õèà´ÕÂÇ·ÕèÁÕÍÂÙè㹡ÒÃArrayList:

   public static String BuildString(ArrayList arlStrings)
   {
   	StringBuilder sb = new StringBuilder();
   	
   	foreach(String s in arlStrings)
   	{
   			sb.Append(s);
   			sb.Append(", ");
   	}
   	return sb.ToString();
   }

1. àÁ×è͵éͧ¡ÒÃà¾ÔèÁ¡ÒÃÍéÒ§ÍÔ§ä»Âѧ¤ÍÁâ¾à¹¹µì¢Í§äźÃÒÃÕ¤ÅÒÊÊͧ ´Óà¹Ô¹¡ÒôѧµèÍ仹Õé:
   1. ¤ÅÔ¡¢ÇÒã¹ Explorer â«Å٪ѹÍéÒ§ÍÔ§:ÀÒÂãµéHowToMultiCompáÅéÇ ¤ÅÔ¡à¾ÔèÁ¡ÒÃÍéÒ§ÍÔ§.
   2. ÀÒÂãµéâ¤Ã§¡Òá´ ¤éÒ§äÇéctrl¤ÅÔ¡¤ÕÂìNWClassLibáÅéÇ ¤ÅÔ¡SBClassLib.
   3. ÁÕâ¤Ã§¡Ò÷Ñé§àÅ×Í¡ ¤ÅÔ¡àÅ×Í¡.
   4. àÁ×èÍâ¤Ã§¡Ò÷Ñé§Êͧ»ÃÒ¡¯ã¹¹Ñ鹤ÍÁâ¾à¹¹µì·ÕèàÅ×Í¡¡Åèͧ ¤ÅÔ¡µ¡Å§.
      
      â¤Ã§¡ÒÃã¹¢³Ð¹ÕéÍÂÙèÀÒÂãµé¡ÒÃÍéÒ§ÍÔ§ÊÓËÃѺá;ÅÔपѹ¢Í§Ë¹éÒµèÒ§
2. Form1.cs ¶Ù¡à»Ô´ã¹ÁØÁÁͧÍ͡Ẻ ¶éÒ Form1.cs 㹡ÒäÅÔ¡Êͧ¤ÃÑ駷ÕèäÁèä´éà»Ô´Form1.csã¹â«Å٪ѹ Explorer
3. ¡´ CTRL + ALT + X à¾×èÍà»Ô´¡Åèͧà¤Ã×èͧÁ×Í áÅéÇ ¤ÅÔ¡Windows Forms.
4. ÅÒ¡»ØèÁŧº¹áºº¿ÍÃìÁ áÅШҡ¹Ñé¹ ¡´ F4 à¾×èÍà¢éҶ֧˹éҤسÊÁºÑµÔÊÓËÃѺ»ØèÁ
5. ¡ÒÃà»ÅÕè¹á»Å§¹Ñé¹¢éͤÇÒÁµÑ駤èҤسÊÁºÑµÔáÊ´§¼ÅÔµÀѳ±ì.
6. à¾ÔèÁ»ØèÁÍ×è¹ áÅÐà»ÅÕè¹á»Å§áÅéÇ ¹Õé¢éͤÇÒÁ¤Ø³ÊÁºÑµÔ¡ÒÃÊÃéҧʵÃÔ§¡ÒÃ.
7. ÅÒ¡µÑÇDataGrid¤Çº¤ØÁŧº¹áºº¿ÍÃìÁ áÅлÅèÍÂäÇé´éÒ¹ÅèÒ§¢Í§»ØèÁ »ÃѺ¢¹Ò´DataGrid¤Çº¤ØÁ¡ÒÃà¾×èÍãËéâ»Ãá¡ÃÁ¡ÃÍ¡¢éÍÁÙž×é¹·Õè·ÕèàÅ×Í¡º¹áºº¿ÍÃìÁ
8. ¤ÅÔ¡Êͧ¤ÃÑé§áÊ´§¼ÅÔµÀѳ±ì. visual Studio .NET ÊÃéÒ§â´ÂÍѵâ¹ÁѵÔà»ç¹¤ÅÔ¡µÑǨѴ¡ÒÃà˵ءÒóì
9. à¾ÔèÁÃËÑʵèÍ仹Õé㹡ÒäÅÔ¡µÑǨѴ¡ÒÃà˵ءÒóì:

   dataGrid1.DataSource = NWClassLib.Class1.GetProducts().Tables[0];

   ÃËÑʹÕéµÑ駤èÒ¹ÕéáËÅ觢éÍÁÙŤسÊÁºÑµÔ¹ÕéDataGrid仪ش¢éÍÁÙÅ·Õè¶Ù¡Ê觡ÅѺâ´ÂGetProductsÇÔ¸Õ¡ÒÃã¹äźÃÒÃÕ¤ÅÒÊ
10. àÁ×è͵éͧ¡ÒÃÊÃéÒ§à»ç¹ÇÔ¹Ò·Õ¤ÅÔ¡µÑǨѴ¡ÒÃà˵ءÒÃ³ì ¤ÅÔ¡Êͧ¤ÃÑé§ÊÃéҧʵÃÔ§¡ÒÃ.
11. ãªéà¹×éÍËҢͧáµèÅÐà«ÅÅìã¹á¶Çáá¢Í§ DataGrid ËÁÒ¶֧à«ÅÅì 7 ÃËÑʵèÍ仹ÕéáÅéÇ à¾ÔèÁà¹×éÍËÒä»ÂѧArrayList. ¡Ãкǹ¡ÒÃArrayList¨Ò¡¹Ñé¹Ê觼èÒ¹ä»ÂѧSBClassLibraryÇÔ¸Õ «Öè§Ê觡ÅѺ¤èÒÊÒÂÍÑ¡¢ÃзÕè»ÃÒ¡¯ã¹µÑÇMessageBox¿Ñ§¡ìªÑ¹ ÍÔ¹Êáµ¹«ì¢Í§¤ÅÒäÁè¨Óà»ç¹ à¹×èͧ¨Ò¡ÇÔ¸Õ¡Òö١»ÃСÒÈ¡è͹˹éÒ¹Õé â´Âãªé¤ÓÊӤѭẺ¤§·Õè
    
    à¾ÔèÁÃËÑʵèÍ仹Õé令ÅÔ¡µÑǨѴ¡ÒÃà˵ءÒóì:

    ArrayList arl = new ArrayList();
    for(int i = 0; i <= 8; i++)
    	arl.Add(dataGrid1[0, i].ToString());
    MessageBox.Show(SBClassLib.Class1.BuildString(arl));

ÃÒ¡ÒâͧÃËÑÊ¡Ò÷ÓãËéàÊÃç¨ÊÁºÙóì

ÃËÑÊ (Class1.vb) ·ÕèÃÒ¡ÒÃãËéàÊÃç¨ÊÁºÙóì

Imports System.Data
Imports System.Data.SqlClient

Public Class Class1
    Public Shared Function GetProducts() As DataSet
        Dim ds As New DataSet()
        Dim sqlDS As New SqlDataAdapter("select * from products", New SqlConnection("server=<network address of instance of SQL Server>;database=northwind;uid=sa"))
        sqlDS.Fill(ds)
        Return ds
    End Function
End Class

ÃËÑÊ (Class1.cs) ·ÕèÃÒ¡ÒÃãËéàÊÃç¨ÊÁºÙóì

using System;
using System.Text;
using System.Collections;

namespace SBClassLib
{
	public class Class1
	{
		public Class1()
		{
			
		}

		public static String BuildString(ArrayList arlStrings)
		{
			StringBuilder sb = new StringBuilder();

			foreach(String s in arlStrings)
			{
				sb.Append(s);
				sb.Append(", ");
			}
			return sb.ToString();
		}
	}
}

ÃËÑÊ (Form1.cs) ·ÕèÃÒ¡ÒÃãËéàÊÃç¨ÊÁºÙóì

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

namespace HowToMultiComp
{
	
	public class Form1 : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.DataGrid dataGrid1;
		
		private System.ComponentModel.Container components = null;

		public Form1()
		{
			InitializeComponent();
		}

		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		private void InitializeComponent()
		{
			this.button1 = new System.Windows.Forms.Button();
			this.button2 = new System.Windows.Forms.Button();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.SuspendLayout();
			// 
			// button1
			// 
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(104, 23);
			this.button1.TabIndex = 0;
			this.button1.Text = "Show Products";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(136, 0);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(96, 23);
			this.button2.TabIndex = 1;
			this.button2.Text = "Build String";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// dataGrid1
			// 
			this.dataGrid1.DataMember = "";
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(0, 24);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(296, 256);
			this.dataGrid1.TabIndex = 2;
			// 
			// Form1
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
			this.ClientSize = new System.Drawing.Size(292, 273);
			this.Controls.AddRange(new System.Windows.Forms.Control[] {
																		  this.dataGrid1,
																		  this.button2,
																		  this.button1});
			this.Name = "Form1";
			this.Text = "Form1";
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.ResumeLayout(false);

		}

		[STAThread]
		static void Main() 
		{
			Application.Run(new Form1());
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			dataGrid1.DataSource = NWClassLib.Class1.GetProducts().Tables[0];
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			ArrayList arl = new ArrayList();
			for(int i = 0; i <= 8; i++)
				arl.Add(dataGrid1[0, i].ToString());
			MessageBox.Show(SBClassLib.Class1.BuildString(arl));
		}
	}
}

µÃǨÊͺ·ÓÇèÒ §Ò¹

1. ¡´ F5 à¾×èÍàÃÕ¡ãªéâ»Ãá¡ÃÁ»ÃÐÂØ¡µìã¹âËÁ´¡ÒõÃǨá¡é¨Ø´º¡¾Ãèͧ
2. àÁ×èÍ»ÃÒ¡¯ã¹áºº¿ÍÃìÁ ¤ÅÔ¡àÃÕ¡´Ù¼ÅÔµÀѳ±ì.
   
   ¡Ãкǹ¡ÒÃDataGridáÊ´§¼ÅÔµÀѳ±ì·Ñé§ËÁ´·ÕèÍÂÙè¨Ò¡µÒÃÒ§¼ÅÔµÀѳ±ì Northwind
3. ¤ÅÔ¡ÊÃéҧʵÃÔ§¡ÒÃ.
   
   ¡Åèͧ¢éͤÇÒÁ»ÃÒ¡¯¢Öé¹áÅÐáÊ´§à¹×éÍËҢͧà«ÅÅì¢Í§á¶Çáá concatenated ¼èÒ¹à«ÅÅì´éÇ´Ѫ¹Õ 7 (zero-based)
4. ¡´ SHIFT + F5 à¾×èÍËÂØ´¡Òôպѡ áÅСÅѺä»Âѧ Visual Studio .NET

¡ÒÃá¡é䢻ѭËÒ

¡ÅѺ仴éÒ¹º¹ | ãËé¢éÍàʹÍá¹Ð