C#中存储过程的用法

            简单例子请多多指教.
            dataSet.Reset();
            //执行存储过程
            command = new SqlCommand("GetInfo", connection);
            //说明命令要执行的是存储过程 
            command.CommandType = CommandType.StoredProcedure;
            //向存储过程中传递参数
            command.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar, 30));
            command.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 100));
            command.UpdatedRowSource = UpdateRowSource.None;
            command.Parameters["@ID"].Value = id;
            command.Parameters["@Name"].Value = name
            //执行命令
            dapt.SelectCommand = command;
            dapt.SelectCommand.ExecuteNonQuery();
            dapt.Fill(dataSet, "table1");
            dataView.Table = dataSet.Tables["table1"];
            dataGridView1.DataSource = dataSet.Tables["table1"];