ASP.net select specific value from datasource into textbox

I tried adding this:

    Protected Sub txtCompanyName_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        'txtMSGID.Text = txtCompanyName.SelectedItem.ToString
        IndDirCompanies.Select("CompanyID = " + txtCompanyName.SelectedItem.ToString())
        CInt(IndDirCompanies.Select("CompanyID = " + txtCompanyName.SelectedItem.ToString())(0)("MSGID"))
    End Sub

But I am getting the following error:

 Error      1      Value of type 'String' cannot be converted to 'System.Web.UI.DataSourceSelectArguments'.      C:\Documents and Settings\Johanna\My Documents\Visual Studio 2005\WebSites\AdSales\WebInsertion.aspx      114      32      C:\...\AdSales\

ah, i thought IndDirCompanies is a DataTable, am I correct in saying it's a SqlDataSource or ObjectDataSource?

if so, you'll have to do this, instead of the line that's throwing the error:
IndDirCompanies.FilterExpression = "CompanyID = " + txtCompanyName.SelectedItem.ToString()
Dim MSGID As Integer = CInt(IndDirCompanies.Select("CompanyID = " + txtCompanyName.SelectedItem.ToString())(0)("MSGID"))

the MSGID will be in the variable and you can do with it what you like. you might have to cast the result of the Select call to whatever type it returns.

ugh, sorry, i posted before i was finished :)
the select call should be
IndDirCompanies.Select(New DataSourceSelectArguments())

not
IndDirCompanies.Select("CompanyID = " + txtCompanyName.SelectedItem.ToString())

Yes it is a SqlDataSource.  sorry.

I added this:

  Protected Sub txtCompanyName_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
       IndDirCompanies.Select(New DataSourceSelectArguments())
        Dim MSGID As Integer = CInt(IndDirCompanies.Select("CompanyID = " + txtCompanyName.SelectedItem.ToString())(0)("MSGID"))
    End Sub

However, I am still getting this error:

Error      1      Value of type 'String' cannot be converted to 'System.Web.UI.DataSourceSelectArguments'.      C:\Documents and Settings\Johanna\My Documents\Visual Studio 2005\WebSites\AdSales\WebInsertion.aspx      114      60      C:\...\AdSales\

try this.

  Protected Sub txtCompanyName_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
       IndDirCompanies.Select(New DataSourceSelectArguments())
        Dim MSGID As Integer = CInt(IndDirCompanies.Select(New DataSourceSelectArguments())(0)("MSGID"))
    End Sub

                                              

1:
2:
3:
4:

Now I am getting this:

Error      1      Interface 'System.Collections.IEnumerable' cannot be indexed because it has no default property.      C:\Documents and Settings\Johanna\My Documents\Visual Studio 2005\WebSites\AdSales\WebInsertion.aspx      113      37      C:\...\AdSales\

you need to determine what the exact type is that Select returns. it's likely to be an array or list or collection of DataRow objects, or even a DataTable.

it should only contain one row (unless you can have more than one MSGID per company id).

easiest is to just set a breakpoint inside and set up a watch or use the Immediate window to enter the expression.

"easiest is to just set a breakpoint inside and set up a watch "  Not sure How to do that. I know how to setup a breakpoint, run the application and step through it, but I can't get there since the error is keeping the application from running that page.

I will look up how to do that.

put the break point on the line Dim result as IEnumerable....

we've commented out the indexing temporarily so it shouldn't throw an error, but you can then check what type it is and then cast it and index it accordingly.

sorry, i'd do this bit for you, but i don't have access Visual Studio at the moment, so i'm kind of "blind" :)

 Protected Sub txtCompanyName_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
       IndDirCompanies.FilterExpression = "CompanyID = " + txtCompanyName.SelectedItem.ToString()
       Dim result As IEnumerable = IndDirCompanies.Select(New DataSourceSelectArguments())
       
        'Dim MSGID As Integer = CInt(result(0)("MSGID"))
    End Sub

                                              

1:
2:
3:
4:
5:
6:

ok, the Select returns a DataView.

so the code below should result in the variable MSGID to store the correct value.

 Protected Sub txtCompanyName_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        IndDirCompanies.FilterExpression = "CompanyID = " + txtCompany.SelectedItem.ToString()
        Dim result As DataView = CType(IndDirCompanies.Select(New DataSourceSelectArguments()), DataView)
        Dim MSGID As Integer = CInt(result.Item(0)("MSGID"))
    End Sub

                                              

1:
2:
3:
4:
5:

DataView is in System.Data, so make sure you have an Imports System.Data in your page.

What if you change your SQL Select clause to concat the MSGID and CompanyName. this will ensure that you get the information you need in the dropdownlist and you can still leave the DataValueField as CompanyID
your dropdownlist will look something like this
001 - ABC Company Pty Ltd
002 - XYZ Company Pty Ltd
Once selected from dropdownlist you can then get the DataTextField text and if you wish extract the MSGID for the selected item and append it a text box.
                          SELECT CompanyID, MSGID + ' - ' + Company AS myField from whatever
your DataTextField = "myField"
then you could use Instr/Left to grab the text before ' - ' and you have your MSGID
 
OR

create another Select Statement that accepts CompanyID as parameter. on the Selectedindexchanged even you call the select statement that grabs the MSGID based on the CompanyID Parameter, and append the return MSGID to the textbox. This offcourse in not a very good for network. as for every selection you are making a DB call.

Velio:

I am getting this error:

Syntax error: Missing operand after 'Trade' operator.   For this line of code:

        Dim result As Data.DataView = CType(IndDirCompanies.Select(New DataSourceSelectArguments()), Data.DataView)

Mayank_Agarwal:

I've tried doing this in the past with username and email address but I could never get it to work quite right.  I would end up having the username + ' '+ with the email address inserted into the database together.

I am not  familiar with how to break them apart so that they insert individually.

I will try this out and see where I get:

SELECT CompanyID, MSGID + ' - ' + Company AS myField from IndDirCompanies = "myField"

Mayank_Agarwal:

When I try to concatenate MSGID and Company Name

MSGID + ' - ' + CompanyName  I get an error that states: "Conversion failed when converting the nvarchar value 'Name of Company' to data type int.

cast(MSGID, varchar) + ' - ' + CompanyName

not sure about this Trade operator... wonder if it's a vb thing (not my stength, as you may have noticed :))

in this line:
        IndDirCompanies.FilterExpression = "CompanyID = " + txtCompany.SelectedItem.ToString()

try replacing the + with a &... this is pretty much a shot in the dark :)

HI Albee_J
I would usggest if its not too Much of an issue change teh MSGID to Varchar, as this was I did.
also I am not sure at the end of the Select statement you got  = myField, i really dont know why have you put that.
below is the SQL i use and both the fields Suburb and PostCode are Varchar

SELECT dbo.PostCode.PostCodeID, dbo.PostCode.Suburb + ' - ' + dbo.PostCode.PostCode AS Suburb FROM dbo.PostCode

and i load the values in the an listbox with DataValueField as PostCodeID and DataTextField as Suburb.

Thank you gentlemen, I will work on implementing your solutions today and advise of my results.