C#第一步

C#開發環境建立步驟(WindowXP+ sp2,SQLServer2000 )
1,Microsoft® .NET Framework 1.1 版可轉散發套件
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-tw&FamilyID=262d25e3-f589-4842-8157-034d1e7cf3a3
dotnetfx.exe(繁體)

2,下載Microsoft® .NET Framework SDK 1.1
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-tw&FamilyID=9b3a2ca6-3647-4070-9f41-a333c6b9181d
setup.exe

3,下載IDE(免費,多語言)
http://prdownloads.sourceforge.net/sharpdevelop/SharpDevelop_1.0.3.1768_Setup.exe?use_mirror=jaist
SharpDevelop_1.0.3.1768_Setup.exe

4,Tools菜單下邊的Options子菜單,選擇我們的國旗,這下連同幫助全部是漢語了。

5,文件新建工程C#,控制台應用程序.  


例子:
/*
 * Created by SharpDevelop.
 * User: from book
 * Date: 2005/2/24
 *
 * To change this template use Tools | Options | Coding | Edit Standard Headers.
 */
using System;
using System.Data.SqlClient;

namespace MyConsoleApplication
{
 class MainClass
 {
  public static void Main(string[] args)
  {
   try
   {
    //step1 :create a connection obj
    SqlConnection mySqlConnection=new SqlConnection("server=192.168.1.61;database=Northwind;uid=sa;pwd=sa");
   
    //step2: create a sqlcommand obj
    SqlCommand mySqlCommand=mySqlConnection.CreateCommand();
    
    //step3: set the sql
    mySqlCommand.CommandText=
     " SELECT CustomerID,CompanyName,ContactName,Address"+
     " FROM Customers"+
     " WHERE CustomerID='ALFKI'";
    
    //step4:open connection
    mySqlConnection.Open();
    
    //step5:create a SqlDatareader object
    SqlDataReader mySqlDataReader=mySqlCommand.ExecuteReader();
    
    //step6:read th row from sqldatareader
    mySqlDataReader.Read();
    
    //step7:display the colum values
    Console.WriteLine("mySqlDataReader[/"CustomerID/"]="+mySqlDataReader["CustomerID"]);
    Console.WriteLine("mySqlDataReader[/"CompanyName/"]="+mySqlDataReader["CompanyName"]);
    Console.WriteLine("mySqlDataReader[/"ContactName/"]="+mySqlDataReader["ContactName"]);
    Console.WriteLine("mySqlDataReader[/"Address/"]="+mySqlDataReader["AddresS"]);
    
    //step8:close sqldataReader object
    mySqlDataReader.Close();
    
    //step9:close the SqlConnection Object
    mySqlConnection.Close();    
   }
   catch(SqlException e)
   {
    Console.WriteLine("A SqlException was thrown");
    Console.WriteLine("Number="+e.Number);
    Console.WriteLine("Message="+e.Message);
    Console.WriteLine("StackTrace:/n"+e.StackTrace);
   }
  }
 }
}