c# 中dataset的使用

查詢資料的源代碼：

string conString="data source=127.0.0.1;database=test;user id=sa;password=123";
string strSQL="select * from student";
SqlConnection myConnection=new SqlConnection(conString);
DataSet ds=new DataSet();
myConnection.Open();
SqlDataAdapter adapter=new SqlDataAdapter(strSQL,myConnection);
adapter.Fill(ds,"ds");
myconnection.Close();
           

封裝後的代碼是：

public static DataSet Query(string StrSql)
        {
            using (SqlConnection connection = new SqlConnection(myConStr))
            {
                DataSet ds = new DataSet();
                connection.Open();
                SqlDataAdapter command = new SqlDataAdapter(StrSql,connection);
                command.Fill(ds,"ds");
                return ds;

            }
        }
           

使用的方法：

private void button2_Click(object sender, EventArgs e)
        {
            string StrQuery = "select * from student";
            DataSet ds = OperateDatabase.Query(StrQuery);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string j = ds.Tables[0].Rows[i][0].ToString();
                MessageBox.Show(j);
            }
        }