fetching the data into gridview in asp.net [Resolved]

using System.Data.SqlClient;

using System.Data;

SqlConnection con = new SqlConnection("Server=YourServerName;Initial Catalog=DatabaseName;User=UserName;password=YourPassword");

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

BindData();

}

}

public void BindData()

{

try

{

con.Open();



SqlDataAdapter da = new SqlDataAdapter("select * from Table_Name", con);

DataTable ds = new DataTable();

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

}

catch (Exception ex)

{

Label1.Text = ex.Message.ToString();

}

finally

{

con.Close();

}

}

R D Patel

Thanks n Regards
Bhupendra Tiwari

sumasri