class1.cs

C#2005 实例源代码

using System;
using System.Data;
using System.Data.SqlClient;

namespace SqlCommand_Create
{
	/// <summary>
	/// 使用SqlCommand实现一个SQL语句
	/// </summary>
	class T
	{
		/// <summary>
		/// 使用SqlCommand实现一个SQL语句
		/// </summary>
		private void CreateSqlCommand()
		{
			//连接数据库
			SqlConnection myCon = new SqlConnection();
			myCon.ConnectionString = "Persist Security Info=False;User id=sa;pwd=sa;database=northwind;server=(local)";
			myCon.Open();

			//使用SqlCommand
			SqlCommand selectCMD = new SqlCommand();
			selectCMD.Connection=myCon;
			selectCMD.CommandText="SELECT top 10 CustomerID, CompanyName FROM Customers";

			//使用修改一行数据，完成非查询的SQL操作
			selectCMD.CommandText="UPDATE Customers SET CompanyName='KFC' WHERE CustomerID = 'ALFKI'";
			int i=selectCMD.ExecuteNonQuery();
			Console.WriteLine("{0}行被修改。",i);	//输出：1行被修改。

			//断开连接
			myCon.Close();		
		}
 
		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			T t=new T();
			t.CreateSqlCommand();
		}
	}
}