This post shows how to assign Dataset values into Textboxes or labels , how to get row value from dataset in c#, Get a single value from dataSet in asp.net
protected void btnsearch_Click(objectsender, EventArgs e)
{
if(Label2.Text != "" && Session["username"].ToString() != "")
{
stringun = Convert.ToString(Session["username"]);
stringnameproof ="select * from UserRegistration where UEmail = '"+ un +"'";
// here con is your connection string
SqlDataAdapterad = new SqlDataAdapter(nameproof,con);
DataSetds = new DataSet();
ad.Fill(ds);
if(ds.Tables[0].Rows.Count > 0)
{
stringuname = ds.Tables[0].Rows[0]["UName"].ToString();
stringproof1 = ds.Tables[0].Rows[0]["UIdproof"].ToString();
stringproof2 = ds.Tables[0].Rows[0]["UIdnumber"].ToString();
stringproof = proof1 + proof2;
}
}
}
