貓~程式碼集散區

ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["WEBConnectionString"]; 
SqlConnection conn = new SqlConnection(connstr.ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("proc name", conn); 
cmd.CommandType = CommandType.StoredProcedure; 
cmd.Parameters.AddWithValue("@VTYPE", "3"); 
SqlDataAdapter sda = new SqlDataAdapter(cmd); 
DataTable dt = new DataTable(); 
int value = sda.Fill(dt); 
foreach (DataRow dr in dt.Rows)
{
}