Pass parameters to OdbcCommand : OdbcCommand « Database ADO.net « C# / C Sharp






Pass parameters to OdbcCommand


using System;
using System.Data;
using System.Data.Odbc;

   class CommandOdbcExample{

      static void Main() {
         OdbcConnection thisConnection = new OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;UID=root;PASSWORD=;");        

         OdbcCommand nonqueryCommand = thisConnection.CreateCommand();

         try {
            thisConnection.Open();

            nonqueryCommand.CommandText = "CREATE TABLE MyTable (MyName VARCHAR (30), MyNumber integer)";
            Console.WriteLine(nonqueryCommand.CommandText);
            nonqueryCommand.ExecuteNonQuery();

            nonqueryCommand.CommandText = "INSERT INTO MyTable VALUES (?, ?)";

            nonqueryCommand.Parameters.Add("@MyName", OdbcType.VarChar, 30);
            nonqueryCommand.Parameters.Add("@MyNumber", OdbcType.Int);
        
            // nonqueryCommand.Prepare();
            string[] names = { "A", "B", "C", "D" } ;
            int i;
            for (i=1; i<=4; i++){
               nonqueryCommand.Parameters["@MyName"].Value = names[i-1];
               nonqueryCommand.Parameters["@MyNumber"].Value = i;
               Console.WriteLine(nonqueryCommand.CommandText);
               Console.WriteLine("Number of Rows Affected is: {0}", nonqueryCommand.ExecuteNonQuery());
            }
            nonqueryCommand.CommandText = "SELECT MyName, MyNumber FROM MyTable";
            OdbcDataReader thisReader = nonqueryCommand.ExecuteReader();

            while (thisReader.Read()) {
               Console.WriteLine("Name and Number: {0} {1}", thisReader.GetValue(0), thisReader.GetValue(1));
            }
            thisReader.Close();

            nonqueryCommand.CommandText = "DROP TABLE MyTable";
            nonqueryCommand.ExecuteNonQuery();
         } 
         catch (OdbcException ex) 
         {
            Console.WriteLine(ex.ToString());
         }
         finally 
         {  
            thisConnection.Close();
            Console.WriteLine("Connection Closed.");
         }
      }
   }


           
       








Related examples in the same category

1.Create database through OdbcCommand
2.Read query result from OdbcCommand
3.how to execute a TableDirect command
4.OleDbConnection: ConnectionTimeout