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()); } |
|