Help Regarding check availability

Question

Hi,

I want to add record in designation table, if user enters a designation means it automatically search in database , if its found na display error message otherwise execute the insert query,...Now  i complete insert code and required field validation,...i don't know how to do the search in database...Please Help Me to do this Search...

Thanks!

Regards!

G.Arun Prasath

Answer 1

Use:

string[] items = fileName.Split('_');

items[0] will be the portion to the first _ and then items[1] will be the portion from the first _ to the second _.

These will exclude the underscores themselves.

Answer 2

You could deal with that situation (or even two hyphen delimiters) by replacing this line:

   string[] items = fileName.Split('_');

with this:

   string[] items = fileName.Split(new char[]{'_', '-'});