public partial class Default2 : System.Web.UI.Page
{
DataTable dt;
SqlConnection cnn;
SqlDataAdapter adp;
protected void Page_Load(object sender, EventArgs e)
{
cnn = new SqlConnection("Data Source=.;Initial Catalog=rd;Integrated Security=True");
cnn.Open();
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
if (Page.IsPostBack == false)
{
grd_bind();
}
}
private void grd_bind()
{
( case when website='' then 'NA'else 'View Site' end ) as school_website,
website from school", cnn);
dt = new DataTable();
adp.Fill(dt);
adp.Dispose();
if (dt.Rows.Count == 0)
{
GridView1.Visible = false;
}
else
{
GridView1.Visible = true;
GridView1.DataSource = dt;
GridView1.DataBind();
Int32 i;
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
String website = (dt.Rows[i]["school_website"].ToString());
if (website == "View Site")
{
((Label)GridView1.Rows[i].FindControl("lbl_website")).Text = "" + dt.Rows[i]["school_website"].ToString() + "";
}
else if (website == "NA")
{
((Label)GridView1.Rows[i].FindControl("lbl_website")).Text = dt.Rows[i]["school_website"].ToString();
}
}
}
}
}
In aspx page
