using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class profile : System.Web.UI.Page
{
    string a;
    SqlConnection cn = new SqlConnection("Server=103.48.50.60,1232;DataBase=caishipolychem;uid=caishipolychem;pwd=Chandan@1234");
    SqlCommand com = new SqlCommand();
    SqlDataAdapter da = new SqlDataAdapter();
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {

        a = "Radiant Warmer";
        // Page.Header.Title = a + " Suppliers," + a + " exporter";
        Label1.Text = a;
        cn.Open();

        da = new SqlDataAdapter("Select * from divinesurgical where category = '" + a + "'", cn);
        //        da = new SqlDataAdapter("Select * from ananya", cn);

        da.Fill(ds);

        GridView2.DataSource = ds;

        GridView2.DataBind();
        if (GridView2.Rows.Count == 0)
        {

        }

        cn.Close();
    }
    protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView2.PageIndex = e.NewPageIndex; GridView2.DataBind();
    }
}