I am trying to put values from my comboxes into datagridbiew but it is giving Exception my coe is given below:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=grade;Integrated Security=True;Pooling=False")
Dim cmd As SqlCommand
If ComboClass.SelectedItem <> "" Or ComboDiv.SelectedItem <> "" Or ComboSubject.SelectedItem <> "" Or ComboTeacher.SelectedItem = "" Or ComboYrstart.SelectedItem <> "" Or ComboYrEnd.SelectedItem <> "" Then
Try
conn.Open()
Dim query As String = "insert into TeacherSubject(Teacher,Class,Div,Subject,YearStart,YearEnd)values(@Teacher,@Class,@Div,@Subject,@YearStart,@YearEnd)"
cmd = New SqlCommand(query, conn)
cmd.Parameters.AddWithValue("@Teacher", (ComboTeacher.SelectedItem()))
cmd.Parameters.AddWithValue("@Class", (ComboClass.SelectedItem()))
cmd.Parameters.AddWithValue("@Div", (ComboDiv.SelectedItem()))
cmd.Parameters.AddWithValue("@Subject", (ComboSubject.SelectedItem()))
cmd.Parameters.AddWithValue("@YearStart", (ComboYrstart.SelectedItem()))
cmd.Parameters.AddWithValue("@YearEnd", (ComboYrEnd.SelectedItem()))
Dim NoOfRowsAffected As Integer = cmd.ExecuteNonQuery() //Exception
MessageBox.Show("Teacher-Subject Details Inserted")
LoadDataInDataGrid()
ComboTeacher.SelectedItem = ""
ComboClass.SelectedItem = ""
ComboDiv.SelectedItem = ""
ComboSubject.SelectedItem = ""
ComboYrstart.SelectedItem = ""
ComboYrEnd.SelectedItem = ""
Catch ex As Exception
MessageBox.Show(ex.ToString())
Finally
If conn.State = ConnectionState.Open Then
conn.Close()
End If
End Try
Else
MessageBox.Show("Please fill proper details")
End If
End Sub
adding the exception info of the OP from an "answer"
ok.this is my Exception now how do i handle it ?
System.Data.SqlClient.SqlException was caught
Message=Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.
Number=257
Procedure=""
Server=.\SQLEXPRESS
Source=.Net SqlClient Data Provider
State=3
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at grading_system.frmTeaches.Button1_Click(Object sender, EventArgs e) in C:\Users\Pratik\Desktop\project\form-2\grading system\grading system\frmTeaches.vb:line 196
InnerException: