Retrieve value from stored procedure as dataset and add to datatable

Becky Bloomwood

15y4.7k

Hi,I have declared a datatable that is somehow similar to the table in the database.

 

DataTable dtgvCriticalTerms = null; //Reflect the CT table in SQL 
Server 



dtgvCriticalTerms = vrmdb.Get_CriticalTerms("ContractID").Tables[0];

Since the query string is ContractID, is my next step needs to declare a dataset such that it can store the data associated with this table?

Once i have this dataset, i need to add it back to the datatable that i have defined it early before?
is it made use of this code:

 

dtgvCriticalTerms = ViewState[viewStateGVCTName] as DataTable;

Thks!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
resolved?
Becky Bloomwood15y ago
Thks. but how come when i view the grid view, it does not contains any record.Thanks!
Amit Choudhary15y ago
Use DataSet when you have multiple tables to store or retrieve so you don't have to use DataSet just use DataTable directly and save and retrieve it from ViewState[] as i can see from your code.

Thanks.