populating a datagrid... - Extend It! ( Programming in VS2003, ASP.Net 1.1 )

Forum General DotNetN... Extend It! ( Pr... populating a datagrid...

2/24/2006 9:11 AM

	Rob Morrow
23 posts
www.deviant-tuning.com

populating a datagrid...

greetings, all. i'm a bit new to the module development area, so please be patient with me. lol, i may ask a lot of dumb questions. i'm attempting to populate a datagrid based on a stored procedure that is ran with values pulled from a dropdown list. when i run the stored proc with values, it pulls back the information that i expect it to. but when i attempt it through my module, it simply shows me the grid headers and no data. i'll show the flow from the beginning...

1. i tell the datagrid to populate with data pulled from the datasource which uses two values to run the query: bankid (pulled from the dropdown) and userid...
dgTransactions.DataSource = blah.BlahBlah.BlahBlahController.GetTransByBankID(Me.ddlBankName.SelectedValue, UserId)

2. the following function is called in the BlahBlahController.vb file...

Public Shared Function GetTransByBankID(ByVal bankId As Integer, ByVal userId As Integer) As DataSet
Return DataProvider.Instance.GetTransByBankId(bankId, userId)
End Function

3. this of course rolls over to the DataProvider.vb where the following is seen...

Public MustOverride Function GetTransByBankId(ByVal BankId As Integer, ByVal UserId As Integer) As DataSet

4. the override is done via the SqlDataProvider.vb, which is like so...

Public Overrides Function GetTransByBankId(ByVal bankId As Integer, ByVal userId As Integer) As DataSet
Return CType(SqlHelper.ExecuteDataset(ConnectionString, DatabaseOwner & ObjectQualifier & "nuv_AccountActivityGetTransByBankID", bankId, userId), DataSet)
End Function

i know this is asking a lot, but does anyone know what i'm doing wrong? i'm kinda new to the whole "data provider" thing, but i've been grasping quite a bit of it lately. i just keep getting stuck on little things like this. thanks in advance...

3/4/2006 12:33 PM

	Stefan Kamphuis
319 posts
www.superska.net

Re: populating a datagrid...

Hmmm, have you set the dataMember proerty of the DataGrid to the name of the Table within the dataset? I don't know for sure if .net automaticly uses the first table if there's only one present in the dataset.

You might want to try this (assuming there's only one table in the dataset:
dgTransactions.DataSource = blah.BlahBlah.BlahBlahController.GetTransByBankID(Me.ddlBankName.SelectedValue, UserId).Tables(0)

Hope this helps.

Greetz, Stefan Kamphuis

Page 1 of 1

Forum

General DotNetN...

Extend It! ( Pr...

populating a datagrid...