Hello
I want update when I click sumit it to line:
Catch ex As Exception<br />
MsgBox("Can not Update Data : " & & ex.Message, MsgBoxStyle.Critical, "Error Meaage")<br />
Exit Sub
MsgBox error:
Can not Update Data: Conversion from string "update Employee set minit='ppp'" to type 'Integer' is not valid.
I don't know what it mean ?
my code:
Protected Sub submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit.Click
Dim con As SqlConnection
Dim da As SqlDataAdapter = New SqlDataAdapter
Dim ds As DataSet = New DataSet()
Dim sqlcommand As String
Dim sqlcmd As SqlCommand
Dim rowaffected As Integer
con = New SqlConnection(connStr)
If (Request.QueryString("edit") <> "") Then
sqlcommand = "update Employee set "
sqlcommand &= "fname= '" & FirstName.Text.Trim & "',"
sqlcommand &= "minit= '" & minit.Text.Trim & "',"
sqlcommand &= "LNAME= '" & LastName.Text.Trim & "',"
sqlcommand &= "ADDRESS= '" & Address.Text.Trim & "',"
If male.Checked = True Then
sqlcommand &= "sex = 'M' , "
Else
sqlcommand &= "sex = 'F' , "
End If
sqlcommand &= "salary= '" & Salary.Text.Trim & "',"
sqlcommand &= "dno= '" & Department.SelectedValue & "' "
sqlcommand &= "where ssn= '" & Request.QueryString("edit").ToString & "'"
Try
sqlcmd = New SqlCommand
con.Open()
sqlcmd.CommandType = CommandType.Text
sqlcmd.CommandType = sqlcommand
sqlcmd.Connection = con
rowaffected = sqlcmd.ExecuteNonQuery
Catch ex As Exception
MsgBox("Can not Update Data : " & & ex.Message, MsgBoxStyle.Critical, "Error Meaage")
Exit Sub
Finally
con.Close()
Response.Redirect("sql8.aspx")
End Try
Else
sqlcommand = " insert into employee (ssn, fname,minit, lname,"
sqlcommand &= " address,sex,salary, dno) values("
sqlcommand &= "'" & SSN.Text.Trim & "',"
sqlcommand &= "'" & firstName.Text.Trim & "',"
sqlcommand &= "'" & minit.Text.Trim & "',"
sqlcommand &= "'" & LastName.Text.Trim & "',"
sqlcommand &= "'" & Address.Text.Trim & "',"
If male.Checked = True Then
sqlcommand &= "'M',"
Else
sqlcommand &= "'F',"
End If
sqlcommand &= "'" & Salary.Text.Trim & "',"
sqlcommand &= "'" & Department.Text.Trim & "')"
Try
sqlcmd = New SqlCommand
con.Open()
sqlcmd.CommandType = CommandType.Text
sqlcmd.CommandText = sqlcommand
sqlcmd.Connection = con
rowaffected = sqlcmd.ExecuteNonQuery
Catch ex As Exception
MsgBox("Can not Insert Data : " & ex.Message, MsgBoxStyle.Critical, "Error Meaage")
Exit Sub
Finally
con.Close()
End Try
End If
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Response.Redirect("sql8.aspx")
End Sub
End Class