Re: Nested Datalists

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks alot Tom. I am understanding the logic of that tutorial but the
only problem is that my page isn't in C# (I am currently learning
though =] ). What I have so far is:

strSQL = "SELECT Max(Sheet.DCN) AS MaxOfDCN, Max(ADCN.ADCN) AS
MaxOfADCN, " & _
"Sheet.SheetNumber FROM Drawings INNER JOIN (ADCN INNER JOIN "
& _
"Sheet ON ADCN.RecordID = Sheet.RecordID) ON " & _
"Drawings.Drawing = Sheet.Drawing WHERE " & _
"(Sheet.Drawing = '" & x & "') AND " & _
"(Sheet.SheetType = 'CD') GROUP BY " & _
"Sheet.Drawing, Sheet.SheetType, Sheet.SheetNumber;"

This SQL statement returns all the information that I need (Drawing #,
SheetType, Version(DCN), Revisions(ADCN), and SheetNumber). The DCN
(MaxOfDCN) is the most current version of that item and ADCN
(MaxOfADCN) is an integer that represents the number of revisions to
that current version of the item. I have utilized a function including
this SQL string as the DataSource for one of my datalists. The output
looks like:

COLUMN 1 - COLUMN 2 - COLUMN 3
Drawing #(string) - Most Current Item Version(string) - Number(n)

The function returns a dataset and the values from above are populated
in the datalist. What I'm wondering is if I could add a column to this
dataset and programmatically alter the output.

ds.Tables("DataTable").Columns.Add("NewColumn") = strNewString

So let's say that COLUMN 2 = C and COLUMN 3 = 7, I would like to build
a string that looks like: C1,C2,C3,C4,C5,C6,C7

Can anyone get me started as to how to best (most efficiently) go about
doing this?

Much thanks.

.

Relevant Pages

  • Re: Nested Datalists
    ... "Sheet.Drawing, Sheet.SheetType, Sheet.SheetNumber;" This SQL statement returns all the information that I need, Revisions, and SheetNumber). ... I have utilized a function including this SQL string as the DataSource for one of my datalists. ... Drawing #- Most Current Item Version- Number ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Using VBA to create a Table in Access database
    ... "Set rst = qdf.OpenRecordset" ... in data which forms the WHERE clause of the sql statement. ... i declared qdf.sql = sqlstring followed by ... If you want to modify the code so that you pass in a simple SQL string, ...
    (microsoft.public.access.modulesdaovba)
  • Re: newbie - sql UPDATE statement
    ... You seemed to refer to the same ... "Newbee Adam" wrote in message ... > I do think a replace function can be used in an sql statement like I use ... > outside an sql string like: ...
    (microsoft.public.access.gettingstarted)
  • Re: How can i get the "true" name of an aliased field?
    ... I'm opening an ADO recordset with an SQL string which goes something ... Use rs.Source to get the sql statement that was used to populate the ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Single Quote in SQL Statement
    ... it is easier to debug in you can construct the SQL String separately ... Dim strSQL As String ... > I need to run a insert sql statement into one of my ... the sub get arguments that need to ...
    (microsoft.public.access.modulesdaovba)