C#通过存储过程读取数据

 private static DataTable Select_T_Name()
        {
            string strSql = "Data Source=172.0.0.1;Initial Catalog=TEST;Persist Security Info=True;User ID=sa;Password=sa";
            SqlConnection myConn = new SqlConnection(strSql);
            myConn.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = myConn;
            cmd.CommandText = "Select_T_Name";
            cmd.CommandType = CommandType.StoredProcedure;

            DataTable dt = new DataTable();
            SqlDataAdapter sqlda = new SqlDataAdapter(cmd);

            try
            {
                //cmd.ExecuteNonQuery();
                sqlda.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                string i = ex.Message;
                return null;
            }
            finally
            {
                //return dt;        
                myConn.Close();               
            }      
        }

-------------------------------------------------------------------------------------------------------------------------------------

--Select_T_Name

USE [TEST]
CREATE PROCEDURE [dbo].[Select_T_Name]
AS
BEGIN
    Select * from T_Name
END

--DataTable的操作

DataTable dt1 = new DataTable();
dt1 = Select_T_Name();
for (int i = 0; i < dt1.Rows.Count; i++)
{
      Console.WriteLine(dt1.Rows[i][0].ToString());
      Console.WriteLine(dt1.Rows[i][1].ToString());
}