textbox value read from sql table name coloum

Question

read data from sql

i have sql table like below

sno    name   mobile
1        raju    9014494876
2        vamshi    9346352389

i want o/p like below in csharp code

i have two texboxs
textbox1 ,textox2

i want read name from sql table display first text box read ""raju"' and second textbox "vamshi"

o/p ...

raju
vamshi

Ranjit Powar · Answer

Try this SqlDataAdapter da; DataSet ds; da = new SqlDataAdapter(Select name from Tablename  con); da.SelectCommand.CommandType = CommandType.StoredProcedure; ds = new DataSet(); da.Fill(ds); textbox1 . Text = ds.Tables[0].Rows[0][Name].ToString(); textbox2 . Text = ds.Tables[0].Rows[1][Name].ToString();

Ranjit Powar · Answer

Your problem solved or not?

sama rr · Answer

Thanks for replay... if sql table like below sno qunty rate 1 5 6 2 4 3.5 multiply coloum2 and coloum3 read first textboxsecond text box dispaly like ( qunty * rate )5*6= 30 o/p 30 14