title: INSERT permission was denied on the object 'employee_info', database 'payroll' schema dbo
body: <pre><code> 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 ('" &amp; Employee_idTextBox.Text &amp; "','" &amp; First_nameTextBox.Text &amp; "','" &amp; Last_nameTextBox.Text &amp; "','" &amp; Middle_nameTextBox.Text &amp; "','" &amp; EmailTextBox.Text &amp; "','" &amp; TelephoneTextBox.Text &amp; "','" &amp; GenderTextBox.Text &amp; "','" &amp; StatusTextBox.Text &amp; "','" &amp; Date_birthDateTimePicker.Text &amp; "','" &amp; Hire_dateDateTimePicker.Text &amp; "')", myconnection)
          mycommand.ExecuteNonQuery()
          MessageBox.Show("New Row Inserted" &amp; ra)
          myconnection.Close()
      End Sub
  </code></pre>
  
  <p>INSERT permission was denied on the object 'employee_info', database 'payroll' schema dbo</p>
  
  <p>how can i resolve this problem?</p>