Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs) Handles Button1.Click Dim myconnection As sqlConnection Dim mycommand As sqlCommand Dim ra As Integer myconnection = New sqlConnection("server=IAI-004;uid=;pwd=;database=payroll") myconnection.Open() mycommand = New sqlCommand("INSERT INTO employee_info([employee_id],[first_name],[last_name],[middle_name],[email],[telephone],[gender],[status],[date_birth],[hire_date]) values ('" & Employee_idTextBox.Text & "','" & First_nameTextBox.Text & "','" & Last_nameTextBox.Text & "','" & Middle_nameTextBox.Text & "','" & EmailTextBox.Text & "','" & TelephoneTextBox.Text & "','" & GenderTextBox.Text & "','" & StatusTextBox.Text & "','" & Date_birthDateTimePicker.Text & "','" & Hire_dateDateTimePicker.Text & "')",myconnection) mycommand.ExecuteNonQuery() MessageBox.Show("New Row Inserted" & ra) myconnection.Close() End Sub
对象“employee_info”,数据库“工资单”模式dbo上的INSERT权限被拒绝
我如何解决这个问题?