public static void ConnDb() { string strConn = "Data Source=localhost;DataBase=mytest;User ID=sa;Password=sa"; string strSql = "select * from stu"; //create conntion object SqlConnection dbConn = new SqlConnection(strConn); dbConn.Open(); //create command object SqlCommand dbCmd = new SqlCommand(strSql, dbConn); //use dbComm to create dbReader; SqlDataReader dbReader = dbCmd.ExecuteReader(); while (dbReader.Read()) { string str = "0:" + dbReader.GetInt32(0) + " 1:" + dbReader.GetString(1) + " 2:" + dbReader.GetString(2); Console.WriteLine(str); } if (null != dbReader) { dbReader.Close(); } if (null != dbCmd) { dbCmd.Clone(); } if (null != dbConn) { dbConn.Close(); } }