retrieve value from sql to label

Question

i have name and age fields stored in sql i have two label such as labe1 labe12 and button ... i want it to retrieve the value stored in database to the label1 and label 2 .. How to do it....

Hiren Soni · Answer

Lalit M · Answer

try this code Dim cn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings(MyConnectionString1).ToString) cn.Open() Dim SqlCmd As SqlCommand SqlCmd = New SqlCommand(SELECT [FirstName] FROM [Contact] WHERE CustID = 39 cn) custIDLabel.Text = ctype(SqlCmd.ExecuteScalarstring)

Rekha Singh · Answer

string sqlText = select nameage from table where somrthing = something ; SqlConnection connection = new SqlConnection( ur connection string ); connection.Open(); DataSet ds = new DataSet (); SqlDataAdapter ad = new SqlDataAdapter(sqlText connection); ad.Fill(ds); label1.text = ds.Tables[0].Rows[0][0]; label2.text = ds.Tables[0].Rows[0][1]; *********************** pls mark Accepted if u find it helpful