Visual C# 2005ÖÐÈçºÎʹÓÃÊý¾ÝÃüÁîÖ´ÐÐTransact-SQLÓï¾ä

private void CH6_DemoForm003_Load(object sender, EventArgs e)
{
...ª±ª±ª±
try
{  
// ½¨Á¢Á¬½Ó¡£
using (SqlConnection con = 
new SqlConnection(connectStringBuilder.ConnectionString))
{
// ½¨Á¢Êý¾ÝÃüÁî¶ÔÏó(Ò༴ SqlCommand ¶ÔÏó)¡£
SqlCommand foxCMD = new SqlCommand();
// ÉèÖà SqlCommand ¶ÔÏóËùҪʹÓõÄÁ¬½Ó¡£
foxCMD.Connection = con;
// ÉèÖø³¸ø SqlCommand ¶ÔÏóµÄÊÇ Transactª²SQL Óï¾ä¡£
foxCMD.CommandType = CommandType.Text;
// Ö¸ÅÉËùÒªÖ´ÐÐµÄ Transactª²SQL Óï¾ä¡£
foxCMD.CommandText = "SELECT COUNT(*) FROM dbo.·Éºü¹¤×÷ÊÒ";
// ´ò¿ªÁ¬½Ó¡£
con.Open();
// Ö´ÐÐÊý¾ÝÃüÁî²¢½«Ëù·µ»ØµÄµ¥Ò»Öµ¸³¸ø±äÁ¿ total¡£
Int32 total = (int)(foxCMD.ExecuteScalar());
lblInfo.Text = "·Éºü¹¤×÷ÊÒµÄÔ±¹¤ÈËÊýÊÇ:" + 
total.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Çë×¢Òâ", 
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}

private void CH6_DemoForm004_Load(object sender, EventArgs e)
{
...
try
{
// ½¨Á¢Á¬½Ó¡£
using (SqlConnection con = 
new SqlConnection(connectStringBuilder.ConnectionString))
{
// ½¨Á¢Êý¾ÝÃüÁî¶ÔÏó(Ò༴ SqlCommand ¶ÔÏó)¡£
SqlCommand foxCMD = 
new SqlCommand("SELECT AVG(Ŀǰн×Ê) FROM dbo.·Éºü¹¤×÷ÊÒ");
// ÉèÖà SqlCommand ¶ÔÏóËùҪʹÓõÄÁ¬½Ó¡£
foxCMD.Connection = con;
// ´ò¿ªÁ¬½Ó¡£
con.Open();
// Ö´ÐÐÊý¾ÝÃüÁî²¢½«Ëù·µ»ØµÄµ¥Ò»Öµ¸³¸ø±äÁ¿ mAverage¡£
double mAverage = Convert.ToDouble(foxCMD.ExecuteScalar());
lblInfo.Text = "·Éºü¹¤×÷ÊÒµÄÔ±¹¤Æ½¾ùн×ÊÊÇ:" + 
mAverage.ToString("$ NT # #,# #0.0000");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Çë×¢Òâ", 
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}