Good day, I got great help to display a lookup value in label
I'm editing the aspx page via notepad & don't have the code behind as it is a 3rd party app.
The below does a lookup to sql db then displays values in label text
I would like the datasource to automatically refresh & update the label text every 2 min
Please help
<asp:Label ID="Label2" runat="server" /></asp:Label>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
try {
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection("...");
con.Open();
System.Data.SqlClient.SqlCommand sqlCmd = new System.Data.SqlClient.SqlCo ...
Go to the complete details ...