Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am trying to put values from my comboxes into datagridbiew but it is giving Exception my coe is given below:
VB
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:
Posted
Updated 21-Oct-12 11:07am
v3
Comments
Sandeep Mewara 21-Oct-12 3:14am    
Care to share your exception details?
Sergey Alexandrovich Kryukov 22-Oct-12 0:56am    
Is it System.Windows.Forms? Tag: "Forms".
--SA

All you need to do is to change your code to the following

SQL
cmd.Parameters.AddWithValue("@Teacher", (ComboTeacher.SelectedItem.Text))
cmd.Parameters.AddWithValue("@Class", (ComboClass.SelectedItem.Text))
cmd.Parameters.AddWithValue("@Div", (ComboDiv.SelectedItem.Text)
cmd.Parameters.AddWithValue("@Subject", (ComboSubject.SelectedItem.Text))
cmd.Parameters.AddWithValue("@YearStart", (ComboYrstart.SelectedItem.Text))
cmd.Parameters.AddWithValue("@YearEnd", (ComboYrEnd.SelectedItem.Text))


Please make the above suggested changes in your code, and let me know if it is working or still getting any other exception.

Regards,

ErSehmi
 
Share this answer
 
v2
Please share the code or explain properly. I am not getting what you are trying to ask!
 
Share this answer
 
Comments
nilesh sawardekar 12-Sep-14 23:59pm    
I think this is not solution ...its comment.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900