Getting Single Value from 1

[requested89]

How do I get a single value from the below record set. I don't care if I get it from the datatable or dataset or even if a nice flying Stork comes and drops it in my backgarden I just want to be able to get the value of the field imageName from the database.

oConn = New OleDbConnection(ConfigurationSettings.AppSettings("DBConnString_Cav"))
                queryString = "SELECT imageName FROM contentTable WHERE "& menuCol &" = "& contentID &" ORDER BY contentID DESC"

                oContentRS = New OleDbDataAdapter(queryString, oConn)

                oContentRS.Fill(oContentDS,"ContentDS")
                ContentDT = New DataTable
                ContentDT = oContentDS.Tables(0)
                ContentDT_numrows = ContentDT.Rows.Count
                cntRpt.datasource = oContentDS
                cntRpt.databind()

Thanks in advance this is really annoying me.

Chris

 

[sweth]

you can use Executesclar it retuns only one row from first column.

 

[jbenson001]

Not sure what you are asking. You are retriveing the values then binding the dataset to some object. The results will be shown there, so I am unclear as to what you want to do.

Jim

 

[requested89]

I want to be able to:

1) retrieve the values
2) bind to a repeater
3) use one value in an if statement completely unconnected with the object. For i.e. compare the value of imageName to some other variable or string. It doesn't matter at what point I use this value i.e I could do the comparison as step 2 and then bind the data in step 3 if need be.

Is this possible?

Thanks for your help,

Chris

 

[jbenson001]

To the the value from the dataset:

Dim somevar As datatype
somevar  = oContentDS.Tables("ContentDS").Rows(rownumber).Item(<columnname>)

 

[requested89]

Cool, thanks for your help.

Chris

 

[jbenson001]

no prolem

Jim