执行SQL存储过程实例

private void toolStripButton3_Click(object sender, EventArgs e)
        {   
连接数据库#region  连接数据库并执行存储过程pro         
             SqlConnection scc = new SqlConnection("server=127.0.0.1;database=NorthWind;uid=sa");
             SqlCommand salesCommand = new SqlCommand("pro", scc);
             salesCommand.CommandType = CommandType.StoredProcedure;
             DataTable  dt=new DataTable(); 
             scc.Open();
             SqlDataReader sdr = salesCommand.ExecuteReader();
             scc.Close();
#endregion

DataReaer转换为DataTable#region DataReaer转换为DataTable
             DataColumn col;
             DataRow row;
             int i = 0;
             for (i = 0; i < sdr.FieldCount; i++)
             {
                 col = new DataColumn();
                 col.ColumnName = sdr.GetName(i);
                 col.DataType = sdr.GetFieldType(i);
                 dt.Columns.Add(col);
             }
             while (sdr.Read())
             {
                 row = dt.NewRow();
                 for (i = 0; i < sdr.FieldCount; i++)
                 {
                     row[i] = sdr.GetValue(i);
                 }
                 dt.Rows.Add(row);
             }
#endregion   
             dataGridView1.DataSoure=dt; 
             sdr.Close();
             
        }