鍦–#涓紝ExecuteReader鏂规硶鐢ㄤ簬浠庢暟鎹簱涓绱㈡暟鎹€備互涓嬫槸浣跨敤ExecuteReader鏂规硶鐨勫熀鏈娉曪細

1. 鍒涘缓涓€涓猄qlConnection瀵硅薄锛岀敤浜庝笌鏁版嵁搴撳缓绔嬭繛鎺ャ€?/li>

SqlConnection connection = new SqlConnection(connectionString);

2. 鍒涘缓涓€涓猄qlCommand瀵硅薄锛岀敤浜庢墽琛孲QL鏌ヨ璇彞銆?/li>

SqlCommand command = new SqlCommand(query, connection);

• query锛氳鎵ц鐨凷QL鏌ヨ璇彞銆?/p>

• connection锛氳繛鎺ュ埌鏁版嵁搴撶殑SqlConnection瀵硅薄銆?/p>

3. 鎵撳紑鏁版嵁搴撹繛鎺ャ€?/li>

connection.Open();

4. 浣跨敤ExecuteReader鏂规硶鎵ц鏌ヨ锛屽苟灏嗙粨鏋滃瓨鍌ㄥ湪SqlDataReader瀵硅薄涓€?/li>

SqlDataReader reader = command.ExecuteReader();

5. 浣跨敤reader瀵硅薄鐨凴ead鏂规硶鏉ラ€愯璇诲彇鏌ヨ缁撴灉銆?/li>

while (reader.Read())
{
// 澶勭悊姣忎竴琛岀殑鏁版嵁
}

• Read鏂规硶杩斿洖涓€涓竷灏斿€硷紝琛ㄧず鏄惁杩樻湁鍙敤鐨勬暟鎹銆?/li>

6. 鍦ㄤ娇鐢ㄥ畬reader瀵硅薄鍚庯紝鍏抽棴鏁版嵁搴撹繛鎺ュ拰reader瀵硅薄銆?/li>

reader.Close();
connection.Close();

瀹屾暣鐨勭ず渚嬩唬鐮佸涓嬶細

using System;
using System.Data.SqlClient;
class Program
{
static void Main()
{
string connectionString = "YourConnectionString";
string query = "SELECT * FROM YourTable";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// 澶勭悊姣忎竴琛岀殑鏁版嵁
}
}
}
}
}

璇锋敞鎰忥紝涓婅堪绀轰緥浣跨敤using璇彞鏉ョ‘淇濆湪浣跨敤瀹岀浉鍏冲璞″悗姝ｇ‘鍏抽棴鏁版嵁搴撹繛鎺ュ拰reader瀵硅薄銆?/p>