Dataset and Datagrid
-
I am working on a web application that uses a datagrid, dataset and an sqldataadapter. I have the datasoucre for the datagrid as the dataset. When I click on the link in VS for the data adapter "Preview Data" and click on Fill DataSet, all rows in the SELECT statement are returned. But when I run the web app, the datagrid is never filled. In fact nothing shows up. The Select Command on the Data Adapter :SELECT FirstName, LastName, SSNumb, CustomerNumb FROM Customer Code for Fill :sqlDataAdapter1.Fill(dataSet11,"Customer"); HTML Page language="c#" Codebehind="Customer.aspx.cs" AutoEventWireup="false" Inherits="rental.Customer" %> Customer
Logo
Thanx in advance! Jude
-
I am working on a web application that uses a datagrid, dataset and an sqldataadapter. I have the datasoucre for the datagrid as the dataset. When I click on the link in VS for the data adapter "Preview Data" and click on Fill DataSet, all rows in the SELECT statement are returned. But when I run the web app, the datagrid is never filled. In fact nothing shows up. The Select Command on the Data Adapter :SELECT FirstName, LastName, SSNumb, CustomerNumb FROM Customer Code for Fill :sqlDataAdapter1.Fill(dataSet11,"Customer"); HTML Page language="c#" Codebehind="Customer.aspx.cs" AutoEventWireup="false" Inherits="rental.Customer" %> Customer
Logo
Thanx in advance! Jude
-
You say you have set the datasource property of the datagrid to the dataset. You haven't simply forgot to call the DataBind method of the datagrid?
HAHA! Thanx..yes I forgot Jude
-
HAHA! Thanx..yes I forgot Jude
Well, now that I have the datagrid being filled, I cannot navigatel. I have paging enabled. Do I have to tell the datagrid to go to the next page? If so, how? Jude