C#实现一个存储过程,并且使用 WHILE 进行数据循环插入

//实现一个存储过程,并且使用 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;
        }