Get value with reader from another form c#

Goran Bibic

Need string to label

What I wrong?

Query is ok

private String getKorisnickoIme()
{
SqlConnection myConnection = new SqlConnection(cs);
String value = "SELECT ime_prezime FROM osobe_korisnici WHERE id='" + korisnikId + "'";
SqlCommand cmd = new SqlCommand(value, myConnection);
myConnection.Open();
SqlDataReader rdr = cmd.ExecuteReader();
return value;
}

Result in label is

SELECT ime_prezime FROM osobe_korisnici WHERE id='10'

id is 10, but I need to write in label name and surname for user (ime_prezime)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sumit Chaudhary8y ago
Accepted answer
Hi,

Firstly check that query in data base if there is some error so please share your table formet and tell me that actually what you want from table and there is no one error or your perfect output then check your ado.net code.

Thanks
Sumit Chaudhary
Goran Bibic8y ago
Regards Sumit
I try this, but same
String value = "SELECT ime_prezime FROM osobe_korisnici WHERE id=" + korisnikId;
Sumit Chaudhary8y ago
Hi Goran Bibic,

if yout table id is int data type so that id's value should not in '_' and so you want to write in label name and surname for a specific user (ime_prezime) so get only name and surname in a query.

like: select name, surname FROM osobe_korisnici WHERE id=10

Thanks
Sumit Chaudhary