C# (CSharp) Create_Connection.open_Connection примеры использования

Пример #1

    public static DataTable Execute_Query(SqlCommand cmd)
    {
        cmd.Connection  = Create_Connection.open_Connection();
        cmd.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable      dt = new DataTable();

        da.Fill(dt);
        return(dt);
    }

Пример #2

 public static int Execute_Non_Query(SqlCommand cmd)
 {
     try
     {
         cmd.Connection  = Create_Connection.open_Connection();
         cmd.CommandType = CommandType.StoredProcedure;
         return(cmd.ExecuteNonQuery());
     }
     finally
     {
         Create_Connection.close_Connection();
     }
 }