в 15:31, 26 мая 2010

2010-05-26T15:31:19Z

Admin: 1 версия

2010-05-26T11:42:29Z

1 версия

Новая страница

==Set CommandType and CommandText of IDbConnection==

<source lang="csharp">
using System;
using System.Data;
using System.Data.SqlClient;
class MainClass {
public static void ExecuteNonQueryExample(IDbConnection con) {
IDbCommand com = con.CreateCommand();
com.rumandType = CommandType.Text;
com.rumandText = "UPDATE Employees SET Title = "Sales Director" WHERE EmployeeId = "5"";
int result = com.ExecuteNonQuery();
Console.WriteLine(result);
}
public static void ExecuteReaderExample(IDbConnection con) {
IDbCommand com = con.CreateCommand();
com.rumandType = CommandType.StoredProcedure;
com.rumandText = "Ten Most Expensive Products";
using (IDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
Console.WriteLine(" {0} = {1}", reader["TenMostExpensiveProducts"], reader["UnitPrice"]);
}
}
}
public static void ExecuteScalarExample(IDbConnection con) {
IDbCommand com = con.CreateCommand();
com.rumandType = CommandType.Text;
com.rumandText = "SELECT COUNT(*) FROM Employees";
int result = (int)com.ExecuteScalar();
Console.WriteLine("Employee count = " + result);
}
public static void Main() {
using (SqlConnection con = new SqlConnection()) {
con.ConnectionString = @"Data Source = .\sqlexpress;Database = Northwind; Integrated Security=SSPI";
con.Open();
ExecuteNonQueryExample(con);
ExecuteReaderExample(con);
ExecuteScalarExample(con);
}
}
}
</source>

← Предыдущая	Версия 15:31, 26 мая 2010
(нет различий)

Csharp/C Sharp/Database ADO.net/IDbConnection - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия