ASP.NET MVC 从入门到放弃(Day11) -C# 连线资料库介绍( ADO.NET )

接着来讲讲资料库连线的部分....

Mysql

类别Class

public class Category
{
   public int CateType { get; set; }

   public string CategoryID { get; set; }

   public string CategoryName { get; set; }
}

连线字串

ConnString = Server=127.0.0.1;userid=root; password=11111111; database=test

连线 Insert or Update or Delete

using (var conn = new MySqlConnection(ConnString)){
   conn.Open();

   using (var command = conn.CreateCommand()){
      command.CommandText = "Insert Into Category    (CateType,Category,Category_Name,ModifyDate,ModifyEID) VALUES(@CateType,@Category,@Category_Name,Now(),@InputUser)";
      command.Parameters.AddWithValue("@CateType", 0);
      command.Parameters.AddWithValue("@Category", "0001");
      command.Parameters.AddWithValue("@Category_Name", "AA");
      command.Parameters.AddWithValue("@InputUser", "111");
      command.ExecuteNonQuery();
      }
}

连线 Select

   var result = new Category();

   using (var conn = new MySqlConnection(ConnString)){

   conn.Open();

   using (var command = conn.CreateCommand()){
   command.CommandText = "SELECT Category, Category_Name FROM Category WHERE Category = @Category And CateType = @CateType";
   command.Parameters.AddWithValue("@Category", "0001");
   command.Parameters.AddWithValue("@CateType", 0);

   using (var reader = command.ExecuteReader()){
         if (reader.HasRows){

            while (reader.Read()){
               result = new Category(){
                        CategoryID = (string)reader["Category"],
                        CategoryName = (reader.IsDBNull(reader.GetOrdinal("Category_Name"))) ? "" : (string)reader["Category_Name"]};
             }

             return result;
          }
          else{
               return result;
          }
  }
  }
}

注解:如果懂SQL语法的人走ADO.NET 是一个很好的处理方式，在後面会讲Entity Framework处理方式