Converting SqlDataSource to String.

[Milotic]

I was wondering how to convert an SqlDataSource to a string if you're sure the select statement will return only one element.

[ilearneditonline]

I was wondering how to convert an SqlDataSource to a string if you're sure the select statement will return only one element.

Not sure what you are looking for, but maybe this helps.

public function getNodeName(ByVal nodeid As Integer) As String
    Dim query As String = "SELECT node_name FROM t_nodes WHERE node_id=" & nodeid
    Using conn As New SqlConnection(Me.ConnectionString)
        Dim cmd As New SqlCommand(query, conn)
        conn.Open()
        return Convert.ToString(cmd.ExecuteScalar())
    End Using
end function

[Milotic]

What I need might be explained a bit better by this. Help would be greatly appreciated.

        Dim getid As New SqlDataSource
        getid.ConnectionString = ConfigurationManager.ConnectionStrings("MegaMeepConnectionString1").ToString()
        getid.InsertCommandType = SqlDataSourceCommandType.Text
        getid.InsertCommand = "SELECT UserID FROM Profile WHERE UserName = @name"
        getid.InsertParameters.Add("name", Login1.UserName)
 
        Dim idnumber As Integer = ???
 

I need idnumber to equal the what the getid datasource selected. Is it easy to do?

[christopherpond]

Try an Output parameter and return ID in SQL

[christopherpond]

I take back my post, Are you inserting a new User with the given name or just trying to return the ID of an already existing User. If the latter I believe the code posted previously execute.scalar is what you need.