循环读取数据表的内容的方法？

Question

游标
DECLARE NameCURSOR FOR 

Answer 1

string sql = "select 字段列表 from 表";
string constr = 连接字符串;
var conn = SqlConnection(constr);
conn.Open();
var cmd = SqlCommand(sql, conn);
DataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
    string s1 = dr["字段1"].Value.ToString();
    ...
}

Answer 2

如果数据不多，可以用： try
            {
               string strCon = "Data Source=192.168.1.2;Initial Catalog=Temp;User ID=sa;Pwd=sa";                                              
                SqlConnection myConn = new SqlConnection(strCon);
                string strCom = "SELECT * FROM table";
                SqlCommand myCmd = myConn.CreateCommand();
                myCmd.CommandText = strCom;
                myConn.Open();
                SqlDataReader myreader = myCmd.ExecuteReader();
                while (myreader.Read())
                {
                    string st1 = (string)myreader[0].ToString(); //   字段1               
                    string st2 = (string)myreader[1].ToString(); //   字段2                                  
                }
                myreader.Close();
                myConn.Close();
            }
            catch
            {
                //MessageBox.Show("错误：\n" + ex.ToString(), "！");
            }