CODE
string nome=textbox1.text;
string sqlsrt="select * from tb_usuarios where nome='"+nome+"'";
string connstr = @"......................blablablabla";
sqlconnection conn = new sqlconnection(connstr);
conn.open();
slqcommand cmd = new sqlcommand(sql,connstr);
sqldatareader dr=cmd.executereader();
while (dr.read())
{
textbox2.text = dr["nome"];
textbox3.text = dr["sobrenome"];
textbox4.text = dr["telefone"];
}
conn.close();
string sqlsrt="select * from tb_usuarios where nome='"+nome+"'";
string connstr = @"......................blablablabla";
sqlconnection conn = new sqlconnection(connstr);
conn.open();
slqcommand cmd = new sqlcommand(sql,connstr);
sqldatareader dr=cmd.executereader();
while (dr.read())
{
textbox2.text = dr["nome"];
textbox3.text = dr["sobrenome"];
textbox4.text = dr["telefone"];
}
conn.close();
Já tentei colocando: dr["nome"].tostring e não consigo fazer com que o dr["nome"] seja "jogado" no textbox2.text.
"Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)"
Qual a forma correta de fazer?
Obrigado.
