//实现一个存储过程,并且使用 WHILE 进行数据循环插入
public void run()
{
//数据库语句的使用
string[] names = { "gan", "cao", "su", "hai" };
string[] passwords = { "1", "2", "3", "4" };
for (int i = 0; i < names.Length; i++)
{
string sql_exec = "declare @username nvarchar(20) = '" + names[i] +
"' declare @password nvarchar(20) = '" + passwords[i] +
"' exec user_study @username ,@password";
ExecuteUpdate(sql_exec);
}
dataGridView1.DataSource = ExecuteQuery(sql_select);
}
private string MySqlCon = "Data Source=192.168.26.68;Initial Catalog=Lota;Integrated Security=True";
public DataTable ExecuteQuery(string sqlStr) //用于查询;其实是相当于提供一个可以传参的函数,到时候写一个sql语句,存在string里,传给这个函数,就会自动执行。
{
SqlConnection con = new SqlConnection(@MySqlCon);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sqlStr;
DataTable dt = new DataTable();
SqlDataAdapter msda;
msda = new SqlDataAdapter(cmd);
msda.Fill(dt);
con.Close();
return dt;
}
public int ExecuteUpdate(string sqlStr) //用于增删改;
{
SqlConnection con = new SqlConnection(@MySqlCon);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sqlStr;
int iud = 0;
iud = cmd.ExecuteNonQuery();
con.Close();
return iud;
}