Error message Problem

Question

User988538322 posted

hi

try

 Catch ex As Exception
            If Err.Number <> 0 Then msgbox(ex.Message, MsgBoxStyle.Critical)
            Exit Sub
        End Try

its work fine But i want to show this with ajax like this. 

try

 Catch ex As Exception
            If Err.Number <> 0 Then DisplayAJAXMessage(Me, ex.Message.ToString)
            Exit Sub
        End Try

 Sub DisplayAJAXMessage(ByVal page As Control, ByRef Message As String)
        Dim myScript As String = ("alert('" & Message & "');")
        ScriptManager.RegisterStartupScript(page, page.GetType(), "MyScript", myScript, True)

    End Sub

But its Not working. tell me what is the problem of this code. Please Help

Answer 1

User1042132515 posted

its looking perfect but still try using a different control(instead of page) which is inside updatepanel instead of page.

ScriptManager.RegisterStartupScript(control, control.GetType(), "MyScript", myScript, True)

Answer 2

User988538322 posted

thanks but sory to say i could'nt understand. can you explain through code or some example?

Answer 3

User1042132515 posted

ok, this is just my thought :) i am not sure if it will work or not but please make a try :)

 you must be using updatepanel in your aspx page. lets assume that you have some button name myControl inside updatepanel.

 

try 
 
 Catch ex As Exception 
            If Err.Number <> 0 Then DisplayAJAXMessage(myControl, ex.Message.ToString) 
            Exit Sub 
        End Try 
 
 Sub DisplayAJAXMessage(ByVal myCon As Button, ByRef Message As String) 
        Dim myScript As String = ("alert('" & Message & "');") 
        ScriptManager.RegisterStartupScript(myCon,myCon.GetType(), "MyScript", myScript, True) 
 
    End Sub

 

Answer 4

User988538322 posted

it was looking right code but i have try this and also check with break point. its running right But message did not display in application. You can check it. 

Answer 5

User1042132515 posted

if possible can you please paste your aspx code? how r u using ajax?

Answer 6

User988538322 posted

i was paste my aspx code in my first post. its my Code and when i use it in simple message then it works fine. for example.

 Sub DisplayAJAXMessage(ByVal page As Control, ByRef Message As String)
        Dim myScript As String = ("alert('" & Message & "');")
        ScriptManager.RegisterStartupScript(page, page.GetType(), "MyScript", myScript, True)
    End Sub

Protected Sub cmdUpdate_Click(ByVal sender As Object, ByVal e As System.EventArgs)
DisplayAJAXMessage(cmdUpdate, "My Message")
end sub

But when i use this code it do not work. and no one error comes. 

 Protected Sub cmdUpdate_Click(ByVal sender As Object, ByVal e As System.EventArgs)

 Try

             UpdateTable("Update BankDetail set AccountNo='" & txtAccountNo.Text & "' , " & _
            "Cno='" & txtBankCNo.Text & "', " & _
            "AccountID='" & cmbAccountID2.Text & "', " & _
            "BankName='" & txtBankName.Text & "', " & _
            "BankAddress='" & txtBankAddress.Text & "', " & _
            "City='" & txtCity.Text & "', " & _
            "ShortName='" & txtShortName.Text & "' where BNo='" & txtUpdate.Text & "'")

           
        Catch ex As Exception
            If Err.Number <> 0 Then DisplayAJAXMessage(cmdUpdate, ex.Message.ToString)
            Exit Sub
        End Try

End Sub

Public Function UpdateTable(ByVal Query As String)
        With obj
            .cn = GetConnection()
            .comm.CommandText = ""
            .comm.Connection = .cn
            .comm.CommandType = Data.CommandType.Text
            .comm.CommandText = Query
            .comm.CommandTimeout = 0
            .comm.ExecuteNonQuery()
            .cn.Close()
        End With
    End Function 

Answer 7

User988538322 posted

and i also want to explane that when i use this code. 

 Catch ex As Exception
            If Err.Number <> 0 Then DisplayAJAXMessage(cmdUpdate, ex.Message.ToString)
            Exit Sub
        End Try

it doesn't work. no message display in run time. But when i use this

 Catch ex As Exception
            If Err.Number <> 0 Then DisplayAJAXMessage(cmdUpdate, "any Message")
            Exit Sub
        End Try

then its work perfect. 

Answer 8

User1042132515 posted

means if you are using static message its working and if you are using ex.Message its not working?? may be you can check your ex.Messge in debug mode and make sure its not containing any ' single quotatin mark(')

Answer 9

User988538322 posted

yes when i debug that code ex.message display. But in web page it does not display. 

Answer 10

User1042132515 posted

can you paste that message? or just check if there are any single quotation mark is there?

Answer 11

User988538322 posted

Conversion failed when converting the varchar value 'Select Record' to data type int.

Answer 12

User1042132515 posted

the single quotation mark ' is creating issue. please try ex.messge.tostring().replace("'","")

Answer 13

User988538322 posted

Still its not working. if you want i can send you a vedio where you can understand Easily.

Answer 14

User1042132515 posted

are you sure you have tried following?

Catch ex As Exception 
            If Err.Number <> 0 Then DisplayAJAXMessage(Me, ex.Message.ToString.Replace("'","")) 
            Exit Sub 
        End Try 

Answer 15

User1042132515 posted

and debug and see that after removing single quotation mark your messge should be:

Conversion failed when converting the varchar value Select Record to data type int.

instead of

Conversion failed when converting the varchar value 'Select Record' to data type int.

Answer 16

User-1199946673 posted

UpdateTable("Update BankDetail set AccountNo='" & txtAccountNo.Text & "' , " & _ "Cno='" & txtBankCNo.Text & "', " & _ "AccountID='" & cmbAccountID2.Text & "', " & _ "BankName='" & txtBankName.Text & "', " & _ "BankAddress='" & txtBankAddress.Text & "', " & _ "City='" & txtCity.Text & "', " & _ "ShortName='" & txtShortName.Text & "' where BNo='" & txtUpdate.Text & "'")

After solving your problem, start reading what you should do to prevent SQL injections...

http://www.mikesdotnetting.com/Article/113/Preventing-SQL-Injection-in-ASP.NET

Answer 17

User988538322 posted

Yes i m Sure. ok i will send you a vedio where you can see working Easily. 

Answer 18

User988538322 posted
Patricgreat check this link for easily understanding. thanks http://www.youtube.com/watch?v=qGtw_5rQ1qQ&feature=feedu

Answer 19

User988538322 posted

Patricgreat check this link for easily understanding. thanks

http://www.youtube.com/watch?v=qGtw_5rQ1qQ&feature=feedu

Answer 20

User1042132515 posted

have you checked the video uploaded? its repeating the same content? can you please cross check?

Answer 21

User1042132515 posted

hey, your problem got solved?

Answer 22

User988538322 posted

Yes in vs 2005 its Not Possible. But in Vs 2008 or Vs 2010 its work perfectly. i don't know why. 

Answer 23

User1042132515 posted

ohh... means there was no issue of quotation mark?? can you please paste the code which worked?

Answer 24

User988538322 posted

Code is same. as above mention. the problem is in AJAX Script Manager and Update Panel in VS 2005. 

Answer 25

User-891884238 posted

I have the same problem, but in Visual Studio 2008 SP1.

Some idea?

 

Thanks,

Eva Janakieff

Answer 26

User-891884238 posted

I resolved it!

My problem was the content of the message I want to show with the DisplayAjax Message.

I include the content of a string variable that contains some spaces, intros...

I made a TRIM() of that string, and the message is showed.

Thanks,

Eva Janakieff