Passing variable to DataView

[John Wildes]

Hello all

I am trying to pass a variable to a DataView so that I can filter the rows displayed in my datagrid.

Here's the code I am trying to get to work

Private Sub btnClientSearch _Click(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles btnClientSearch .Click

s_customerID = txtCustomerID.T ext

MsgBox("Client ID is " + s_customerID)

daTamDataFiles. SelectCommand = cmdSelectTransa ctions

daTamDataFiles. Fill(dsStatemen tData.Transacti ons)

dvTransactions. RowFilter = "CustomerID = s_customerID"

End Sub

The error that I get is that s_customerID is not a row, and it isn't, it's the variable that contains some data that I want to filter the rows on, namely the customerID which is a 7 digit alpha numeric code.

dvTransactions is the dataview whose Table property is dsStatementData .Transactions

so what I am trying to do is fill the dsStatementData .Transactions table, show it in my data grid called gridTransaction s using a filtered DataView. If I replace the text s_customerID with a customerID ex 'RUMSDO1' quotes and all. I get the rows filtered for that client ID.

Any help would be greatly appreciated.

John - supreme VB.net noob (pronounced 'newbie')

[Ken Tucker [MVP]]

Hi,

dvTransactions. RowFilter = "CustomerID = '" + s_customerID +"'"

Ken
----------------------
"John Wildes" <sp******@kisso ff.com> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
Hello all

I am trying to pass a variable to a DataView so that I can filter the rows displayed in my datagrid.

Here's the code I am trying to get to work

Private Sub btnClientSearch _Click(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles btnClientSearch .Click

s_customerID = txtCustomerID.T ext

MsgBox("Client ID is " + s_customerID)

daTamDataFiles. SelectCommand = cmdSelectTransa ctions

daTamDataFiles. Fill(dsStatemen tData.Transacti ons)

dvTransactions. RowFilter = "CustomerID = s_customerID"

End Sub

The error that I get is that s_customerID is not a row, and it isn't, it's the variable that contains some data that I want to filter the rows on, namely the customerID which is a 7 digit alpha numeric code.

dvTransactions is the dataview whose Table property is dsStatementData .Transactions

so what I am trying to do is fill the dsStatementData .Transactions table, show it in my data grid called gridTransaction s using a filtered DataView. If I replace the text s_customerID with a customerID ex 'RUMSDO1' quotes and all. I get the rows filtered for that client ID.

Any help would be greatly appreciated.

John - supreme VB.net noob (pronounced 'newbie')

[John Wildes]

Ken

Thanks much, going forward, is this how I would reference variables in properties like this ?

john

"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message news:eW******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

dvTransactions. RowFilter = "CustomerID = '" + s_customerID +"'"

Ken
----------------------
"John Wildes" <sp******@kisso ff.com> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
Hello all

I am trying to pass a variable to a DataView so that I can filter the rows displayed in my datagrid.

Here's the code I am trying to get to work

Private Sub btnClientSearch _Click(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles btnClientSearch .Click

s_customerID = txtCustomerID.T ext

MsgBox("Client ID is " + s_customerID)

daTamDataFiles. SelectCommand = cmdSelectTransa ctions

daTamDataFiles. Fill(dsStatemen tData.Transacti ons)

dvTransactions. RowFilter = "CustomerID = s_customerID"

End Sub

The error that I get is that s_customerID is not a row, and it isn't, it's the variable that contains some data that I want to filter the rows on, namely the customerID which is a 7 digit alpha numeric code.

dvTransactions is the dataview whose Table property is dsStatementData .Transactions

so what I am trying to do is fill the dsStatementData .Transactions table, show it in my data grid called gridTransaction s using a filtered DataView. If I replace the text s_customerID with a customerID ex 'RUMSDO1' quotes and all. I get the rows filtered for that client ID.

Any help would be greatly appreciated.

John - supreme VB.net noob (pronounced 'newbie')

[Ken Tucker [MVP]]

hi,

Yes.

Ken
----------------
"John Wildes" <sp******@kisso ff.com> wrote in message news:e6******** ******@TK2MSFTN GP09.phx.gbl...
Ken

Thanks much, going forward, is this how I would reference variables in properties like this ?

john

"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message news:eW******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

dvTransactions. RowFilter = "CustomerID = '" + s_customerID +"'"

Ken
----------------------
"John Wildes" <sp******@kisso ff.com> wrote in message news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
Hello all

I am trying to pass a variable to a DataView so that I can filter the rows displayed in my datagrid.

Here's the code I am trying to get to work

Private Sub btnClientSearch _Click(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles btnClientSearch .Click

s_customerID = txtCustomerID.T ext

MsgBox("Client ID is " + s_customerID)

daTamDataFiles. SelectCommand = cmdSelectTransa ctions

daTamDataFiles. Fill(dsStatemen tData.Transacti ons)

dvTransactions. RowFilter = "CustomerID = s_customerID"

End Sub

The error that I get is that s_customerID is not a row, and it isn't, it's the variable that contains some data that I want to filter the rows on, namely the customerID which is a 7 digit alpha numeric code.

dvTransactions is the dataview whose Table property is dsStatementData .Transactions

so what I am trying to do is fill the dsStatementData .Transactions table, show it in my data grid called gridTransaction s using a filtered DataView. If I replace the text s_customerID with a customerID ex 'RUMSDO1' quotes and all. I get the rows filtered for that client ID.

Any help would be greatly appreciated.

John - supreme VB.net noob (pronounced 'newbie')