using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient; //须引用此命名空间
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace testProc
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//控件Button2个、TextBox2个、DataGridView1个
//分别命名为btnShow、btnLogin、txtUid、txtPwd、dgvDisplay
private void btnShow_Click(object sender, EventArgs e)
{//调用显示所有用户的存储过程spSelectAll
string cnnString = "server=.\\sqlexpress;database=testprocedure;integrated security=true";
SqlConnection cnn = new SqlConnection(cnnString);
cnn.Open();
SqlCommand cmd = new SqlCommand("spSelectAll ", cnn);
cmd.CommandType = CommandType.StoredProcedure;
在C#中调用存储过程(WinForm)
最新推荐文章于 2024-06-05 07:57:21 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)