searching a text box text in all column and showing its corresponding value from column...

Question

1.50/5 (2 votes)

See more:

hi....

I am bigner in programming. So please answer me easly and clearly..

I created a small windows application. In my SQL db table two columns are there.. FirstName and LastName. In form having two text boxes and one button. My question is when i am entering a text in first textbox and clicking the button at that time i have to serch which column contains the entered text and if it is in FirstName column, then the correspond LastName have to display in the second textbox and the reverse also..

Thanks in advance..

Posted 28-Aug-12 3:09am

naseem drops

Updated 28-Aug-12 3:17am

v2

Add a Solution

Comments

Legor 28-Aug-12 9:12am

So how far have you come so far?

Legor 28-Aug-12 9:24am

By the way if you're a beginner in programming you probably shouldn't start with a database-driven Windows application, in my opinion.

[no name] 28-Aug-12 13:08pm

use google.com, search some code try
face some problem then post here.
This is not a tutorial home.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

abhishekdhanotia · Answer 1 · 2012-08-28T03:32:00

SQL

CREATE PROCEDURE [dbo].[GetDetails]
 (
  @firstName VARCHAR(50)
 ,@lastName VARCHAR(50)
 )
AS

BEGIN

DECLARE @sql AS VARCHAR(100)
SET @sql = 'SELECT FirstName , LastNme FROM YOURTABLE WHERE '
IF @firstName !=''
    SET @sql = @sql + ' firstname LIKE %'+ @firstName + '%'


 IF @lastName !=''
    SET @sql = @sql + ' lastname LIKE %'+ @lastName  + '%'
END

WebMaster · Answer 2 · 2012-08-28T03:57:00

Create this procedure to return the specified row:

SQL

Create Procedure GetFullName
@Name  nVarchar(50)
As
  Select FirstName,
         LastName
         From  Table_Name
         Where FirstName = @Name Or LastName = @Name

then execute that, and if there was a row so you can check if the user, entered firstName so textBox2.Text will be lastName and also the reverse is possible.

C#

string firstName = string.Empty, lastName = string.Empty;

SqlConnection connection = new SqlConnection("write connectionString here");

SqlCommand command = new SqlCommand(connection);
command.Text = "GetFullName";
command.CommandType = CommandType.StoreProcedure;

try
{
   command.Connection.Open();
   SqlDataReader reader = command.ExecuteReader();

   if (reader.Read())
   {
       firstName = (string)reader["FirstName"];
       lastName = (string)reader["LastName"];
   }
   else
       MessageBox.Show("No match found");
   reader.Close();
}
catch { }
finally
{
   if (command.Connection.State == ConnectionState.Open)
       command.Connection.Close();
}

textBox2.Text == textBox1.Text == firstName ? lastName : firstName;

searching a text box text in all column and showing its corresponding value from column...

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0