Csharp/C Sharp by API/System.Data/CommandBehavior

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

CommandBehavior.SchemaOnly

<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; class SchemaOnlyCommandBehavior {

   public static void Main() {
       SqlConnection mySqlConnection = new SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa");
       SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
       mySqlCommand.rumandText = "SELECT ProductID, ProductName, UnitPrice FROM Products WHERE ProductID = 1";
       mySqlConnection.Open();
       SqlDataReader productsSqlDataReader = mySqlCommand.ExecuteReader(CommandBehavior.SchemaOnly);
       DataTable myDataTable = productsSqlDataReader.GetSchemaTable();
       foreach (DataRow myDataRow in myDataTable.Rows) {
           foreach (DataColumn myDataColumn in myDataTable.Columns) {
               Console.WriteLine(myDataColumn + "= " + myDataRow[myDataColumn]);
               if (myDataColumn.ToString() == "ProviderType") {
                   Console.WriteLine(myDataColumn + "= " + ((System.Data.SqlDbType)myDataRow[myDataColumn]));
               }
           }
       }
       productsSqlDataReader.Close();
       mySqlConnection.Close();
   }

}


 </source>


CommandBehavior.SingleRow

<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; class SingleRowCommandBehavior {

   public static void Main() {
       SqlConnection mySqlConnection = new SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa");
       SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
       mySqlCommand.rumandText = "SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice FROM Products";
       mySqlConnection.Open();
       SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(CommandBehavior.SingleRow);
       while (mySqlDataReader.Read()) {
           Console.WriteLine("mySqlDataReader[\" ProductID\"] = " + mySqlDataReader["ProductID"]);
           Console.WriteLine("mySqlDataReader[\" ProductName\"] = " + mySqlDataReader["ProductName"]);
           Console.WriteLine("mySqlDataReader[\" QuantityPerUnit\"] = " + mySqlDataReader["QuantityPerUnit"]);
           Console.WriteLine("mySqlDataReader[\" UnitPrice\"] = " + mySqlDataReader["UnitPrice"]);
       }
       mySqlDataReader.Close();
       mySqlConnection.Close();
   }

}


 </source>