SqlConnection MyConnection = new SqlConnection(MyConn);
String str="select * from Sc_Student";
SqlDataAdapter sqlada=new SqlDataAdapter(str,MyConn);
DataSet myset=new DataSet();
sqlada.Fill(myset);
然後妳的Sc_Student表裏面的內容都會在myset這個數據集中,用String ss=myset.Table[0].Rows[x][y].ToString();取出妳想要的值,X,Y為數據表的Row 和cell