Error handling (1)

[shahab]

When the record of database is unique and user adds a duplicated value in it, in error handling how can I notice the user. (I mean the error must have a id or sth like that..)

}
		catch (Exception e01)
		{
			Label3.Text=e01.Message.ToString();				
		}

:rolleyes:

Thanks

[MorningZ]

if you do a Try Catch block, like

 

Try

'some SQL insert statement

Catch ex as Exception

'ex.Message has the error message.. you could just look for certain text here (depends on the database though)

End Try

[PlausiblyDamp]

What database are you using? If it is SQL then you are much better trying to catch a SqlException - this will allow you to check the SQL error code. If you are using access then check for a OleDbException this at least gives you an ErrorCode property.

[shahab]

1-

depends on the database though

would you please show me a code?

 

2-I use msSql2000

If it is SQL then you are much better trying to catch a SqlException - this will allow you to check the SQL error code

!

I know the theory i need code!!!:)

[PlausiblyDamp]

something like the following should help

try{
//whatever code you where doing
}
catch(SqlException ex)
{
if (ex.Number == 2627)  //IIRC 2627 is a PK violation
{
//handle duplicate id here
}
}

[shahab]

oh Thanks like this:

 

//Label6.Text = e01.Number.ToString();

if (e01.Number == 2627)

{

Label6.Text = "Sorry there is a username with the same what u typed!Please try new username";

}

 

:)

//handle duplicate id here

if there were many errors what should I do then?

[PlausiblyDamp]

ex has an errors collection - you can use a foreach loop to loop over all the errors returned by SQL.

[shahab]

Thanks! ;) :D