Try this : private void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { FillDataGrid(); } } private void FillDataGrid() { string strsql = "Select * from tblupload" //Open DB Connection here DataSet ds = con.GetDataSet(SQL,tableName); DataGrid1.DataSource = ds; DataGrid1.DataBind(); //Close DB Connection here } private DataSet GetDataSet(String sql) { string tableName = "tblupload"; SqlDataAdapter da = new SqlDataAdapter(sql, connectionStr); da.Fill(ds, tableName); return ds; }