Try this
<form id="form1" runat="server">
<div>
<table cellpadding="0" cellspacing="0">
<tr>
<td style="width: 100px">
<asp:Label ID="lblEmpId" runat="server"></asp:Label>
</td>
<td style="width: 100px">
<asp:Label ID="lblName" runat="server"></asp:Label>
</td>
<td style="width: 100px">
<asp:Label ID="lblLeaveStatus" runat="server"></asp:Label>
</td>
</tr>
</table>
</div>
</form>
Now you will have to bind the data to the table like this
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
GetData();
}
}
private void GetData()
{
DataTable dataTable = new DataTable();
string connectionString = ConfigurationManager.ConnectionStrings["MyCon"].ConnectionString;
SqlConnection sqlconnection = new SqlConnection();
sqlconnection.ConnectionString = connectionString;
sqlconnection.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT EmpId,Name,LeaveStatus FROM Employee_Leaves", sqlconnection);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
dataTable.Load(sqlDataReader);
sqlconnection.Close();
if (dataTable.Rows.Count > 0)
{
for (int i = 0; i <= dataTable.Rows.Count - 1; i++)
{
lblEmpId.Text = dataTable.Rows[i]["EmpId"].ToString();
lblName.Text = dataTable.Rows[i]["Name"].ToString();
lblLeaveStatus.Text = dataTable.Rows[i]["LeaveStatus"].ToString();
}
}
}