error on sql command

Question

0.00/5 (No votes)

See more:

string str = "select * from Employee_Details where Employee_Name='" + txt_serch_by.Text + "'";
SqlCommand objgcmd = new SqlCommand(str, ObjCon);
SqlDataAdapter sda = new SqlDataAdapter(objgcmd);
DataTable dt1 = new DataTable();

sda.Fill(dt1);

from this code am getting a error message like-----The name 'txt_serch_by' does not exist in the current contex-------
how to overcome this eror

Posted 29-Apr-13 21:28pm

geo thomas

Add a Solution

3 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)

Kushal.patil121 · Answer 1 · 2013-04-29T21:32:00

Solution 1

its seems that Textbox "txt_serch_by" is not added on form correctly or it is not present.
Please check whether is present or else please provide the design code.

Posted 29-Apr-13 21:32pm

Kushal.patil121

Comments

geo thomas 30-Apr-13 3:35am

no..txt_serch_by" is not added on form correctly...

#endregion

private System.Windows.Forms.Button button1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.ComboBox cmb_serch;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.LinkLabel linkLabel1;
private System.Windows.Forms.Label lbl_serch_by;
private System.Windows.Forms.TextBox txt_serch_by;

Kushal.patil121 30-Apr-13 5:08am

I would recommend you to drag and drop text box from Toolbox to Form.
It will create all necessary properties in design .....
and after that give ID as txt_serch_by2 and use that in your query .....

SLNS001 · Answer 2 · 2013-04-29T21:34:00

Solution 2

Please try it, by storing "txt_serch_by" with one variable in string format and read from that variable.

Posted 29-Apr-13 21:34pm

SLNS001

Comments

geo thomas 30-Apr-13 3:38am

no...its not working

VipulAgrawal 30-Apr-13 4:40am

Are you adding the text box in gridview?????....Then search control by FindControl() function...It will solve the problem.....

Kushal.patil121 30-Apr-13 5:07am

Vipul its seems that he is working on Windows project not web Project.... ;)

geo thomas 30-Apr-13 5:17am

thanku....its solved nw...

TrushnaK · Answer 3 · 2013-04-29T22:12:00

Solution 3

It seems that your txt_serch_by not properly registered to designer page.
remove the textbox and add it again.

Posted 29-Apr-13 22:12pm

TrushnaK

Comments

geo thomas 30-Apr-13 6:33am

i was tryin to access the text bob name in a form to a class...

TrushnaK 30-Apr-13 6:35am

Then what?