Data From Database display to textbox c#

Question

Good day Guys. I want to display the value of Townhouse into txthouse after selecting code from the data Thank you guys .

DataTable dtRefItem = Common.Common.GetData("SELECT Townhouse FROM County where code= '"+txtbox.text"'"

What Common.Common.GetData exactly do? And looks like you need to use + after txtbox.text like '" + txtbox.text + "'" — Soner Gönül
– Soner Gönül, Commented Apr 10, 2014 at 6:39
@SonerGönül get the data from the database. I use already that sir i encounter error. — Dreamer XD
– Dreamer XD, Commented Apr 10, 2014 at 6:42
@ThorstenDittmar I need to display the value of townhouse when I select the value of code . — Dreamer XD
– Dreamer XD, Commented Apr 10, 2014 at 6:43
@renats I get what you want, but you're not asking a specific question - but could you please explain what your problem is/what error you're getting/what's not working/what you've tried. Just anything that makes this a question which will not be closed for "unclear what you're asking"... — Thorsten Dittmar
– Thorsten Dittmar, Commented Apr 10, 2014 at 6:46

Brendan · Accepted Answer · 2014-04-10 14:50:21Z

1

I would recommend using sql parameters instead of building up the sql command with just strings. this will help limit your exposure to sql injection and is just a good practice to start.

answered Apr 10, 2014 at 14:50

Brendan

112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim Schmelter · Accepted Answer · 2014-04-10 07:14:50Z

0

A DataTable normally contains multiple DataRows. Even if you select only one you need to access that row from it's DataTable.Rows-property.

string townHouse = null;
if(dtRefItem.Rows.Count > 0)
{
    townhouse = dtRefItem.Rows[0].Field<string>("Townhouse");
}
txthouse.Text = townHouse;

edited Apr 10, 2014 at 7:14

answered Apr 10, 2014 at 7:00

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

1 Comment

Dreamer XD Over a year ago

Thank you sir for the effort ^^ @TimSchmelter

Collectives™ on Stack Overflow

Data From Database display to textbox c#

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related