private void Page_Load(object sender, System.EventArgs e)

                    if(!Page.IsPostBack)
{
                     strconn="server=localhost;uid=sa;pwd=sa;database=pubs"
   SqlConnection conn=new SqlConnect(strconn);
                     DataSet ds=new DataSet();
                     string sql="select * from authors"
                     SqlDataAdapter adp=new SqlDataAdapter(sql,conn);
                     adp.Fill(ds,"db")
                     DataGrid1.DataSource=ds.Tables[0].DefaultView;
                     DataGrid1.DataBind();
}
}