I am looking to add additional data into a "stream" that has been
extracted from a database, but before it is sent to a control (Repeater,
in this case).

I have found ZERO (0) articles about this on the Internet. Anyone care
to point me in the right direction? I am not looking for code that
rivals Gray's Anatomy in complexity, just something that can add a
static variable in a line or two of code (at the most).

My script so far looks like this:

   Dim myConn as New
OleDbConnection(ConfigurationSettings.AppSettings("strConn"))
   Dim myCmd_img as New OleDbCommand("SELECT [ID], [Comment] FROM [tbl"
& strSlave & "] WHERE [" & strMaster & "ID] = " & intMaster & " AND [ID]
= " & intSlave, myConn)
   myConn.Open()
   Img.DataSource = myCmd_img.ExecuteReader(CommandBehavior.CloseConnection)
   Img.DataBind()
   myConn.Close()

What I want to do is add the table name, contained within the string
strSlave, into the data extracted from the table. I want to assign it a
variable of "Table". That way, I can call it by its variable in the
Repeater.

I do not want to add the name of the table TO the database, I just want
to add it to the stream of data extracted FROM the database. Ideally, it
would be something as simple as this:

Img.Items.Insert(0, new Item(strSlave, "Table"))

But this doesn't work.

TIA,
...Geshel

Hi,

Neo Geshel wrote:
You can achieve exactly what you want by adding to your SQL query.  You can
SELECT not just table columns, but also literal values: nothing stops you
from doing the following:

Dim myCmd_img as New OleDbCommand("SELECT 'tbl" & strSlave &  "' AS [Table],
[ID], [Comment] FROM
[tbl" & strSlave & "] WHERE [" & strMaster & "ID] = " & intMaster & "
AND [ID] = " & intSlave, myConn)

I hope I did the VB concatenation right (I am not a VB programmer).   The
SQL we are going for is:  "SELECT 'tblWhatever' AS [Table], ..." -- note the
single quotes around the literal value.  This will return an additional
column named "Table" and containing the given value, for each returned row.

Chris Priede wrote:
Show quoteHide quoteActually, this works beautifully, I just had to add my values after any
SQL SELECT operations (such as “SELECT TOP 1”) and before the FROM.
Otherwise Access chokes on the statement.

Thanks.
...Geshel

Add New in Bindings Navigator problem
Select next item in DB without knowing what ID it has
Oracle Adventures
DataTable.Select() - is it possible to pass rows back to datatable
Stored Procedure with Output parameter