Hi,

I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five: Name, Surname, Email, Ext, Dept. This is the code that I have written to check achieve this:

Protected Sub SearchBtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SearchBtn.Click

Dim recordAdapter As New recordTableAdapter

I have commented out the email search as if I enable this, for some reason it stops accepting input paramters from Name and Surname. When I use the debugger and set a line break at either the Name or Surname 'Get' command, I can see that the value for the string is what I entered in the textbox, yet it doesn't want to use them in the search and it comes up blank as if it couldn't find anything. Any Ideas ?!?!

Also, I want to introduce a function where if a user enters a search where it cannot find any records based on the search criteria, I want a message to come up saying that it cannot find anything. If anyone can help me with this, I'd be grateful.

Many thanks in advance,

Tom

Dear, friend:

I am sorry that i have not caught your meaning completely.

Do you mean in this statement

GridView.DataSource = recordAdapter.GetDataByExt(ExtTxt.Text)

ExtTxt.Text returns the right value which you input into the TextBox but the result of  recordAdapter.GetDataByExt(ExtTxt.Text) is not as you expect?

Hi,

 No, it's the

GridView.DataSource = recordAdapter.GetDataByEmail(EmailTxt.Text)

which is causing the problem - If I uncomment this IF statement, then the form works, but for some reason it no longer works if I try to search by Name or Surname - I don't understand why this is as when I check the value of NameTxt.Text or SurnameTxt.Txt during debug mode, it shows that the string is what I entered.

Thanks,

Tom

Hi!,
Just in case...

In ur if statement u have used Email.text (name of the textbox control is Email), whereas next line u r assigning null value to Emailtxt (name of the control is EmailTxt), is it typo.

Hi,

Thanks for noticing that - Guess all it takes sometimes is a fresh set of eyes

Edited it to be correct, and all is working now - Cheers!!

In addition, can anyone suggest a method of creating a way of joining the searches so that if someone enters a Name and Surname which don't exist or don't match the database values, it displays a message to say that it has no entries ?

Thanks, Tom.