Fetching data into datagrid from sql server 2008 database

See more:

C#

ASP.NET

i have a database in sql server. and i want to fetch values from it in the datagrid in asp.net
i have use the following code. every time i run the page it shows "no Records found".
i have entered some entries in the table used here but it is not showing the output.

i m new to asp.net pls help me...

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Server=dimts-022;Initial Catalog=db_asset;User=UserName;password=Password");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindData();
        }
    }
    public void BindData()
    {
        try
        {
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter("select * from b_asset_master", con);
            DataTable ds = new DataTable();
            da.Fill(ds);
            Grid.DataSource = ds;
            Grid.DataBind();
        }
        catch
        {
            Label1.Text = "No records Found";
            Label1.Visible = true;
        }
        finally
        {
            con.Close();
        }
    }
}