(转)
1. 通过文本框textbox.Text输入 实际要输入的参数值,点击Button1,执行存储过程后把检索的数据用datagridview1显示出来;
private void button1_Click(object sender, EventArgs e)
{
//数据库连接字符串
string connString = " =DataSource=.;Initial Catalog=user_table;Persist Security Info=True;User ID=sa;Password=123";
SqlConnection conn = new SqlConnection(connString);
string proc_name = "proc_transfer"; //存储过程名
SqlCommand comm = new