ASP.NET

ASP.NET RSS

Need help passing database column value to a string variable.

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2007

Posts: 86

Reputation: justapimp is an unknown quantity at this point

Solved Threads: 1

justapimp

Offline

Junior Poster in Training

Need help passing database column value to a string variable.

Oct 5th, 2007

I have a data table adapter that returns a single column and I would like to assign the column to a string variable. Can anyone help me on this. it seems very simple but when I use this syntax

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
GpsitDataTableAdpater provider = new GpsitDataTableAdapter();
string CarrierString = Convert.ToString(provider.getProviderByDevUID(1789));
GpsitDataTableAdpater provider = new GpsitDataTableAdapter();
string CarrierString = Convert.ToString(provider.getProviderByDevUID(1789));

it returns the table title "DEVICE". when I test the select statement, I get the right column but, when I used in the context above, I get the table's title.

•

Join Date: Oct 2006

Posts: 169

Reputation: ptaylor965 is an unknown quantity at this point

Solved Threads: 19

ptaylor965 ptaylor965 is offline

Offline

Junior Poster

Re: Need help passing database column value to a string variable.

Oct 6th, 2007

Hi,
This is how i do it for SQL databases

Help with Code Tags

(Toggle Plain Text)

Dim SQLda as New SQLDataAdapter
Dim SQLTable as new Data.DataTable
Dim SQLRow as Data.DataRow
Dim Value as String

SQLda = New SQLDataAdapter(SQL_SELECT_STATEMENT, CONNECTION_STRING)
SQLDA.Fill(SQLTable)

For Each SQLRow in SQLTable.Rows
    Value = SQLRow(Column_Name).toString
Next

Peter Taylor
Visual Basic.NET Application Developer

TaylorsNet
http://www.taylorsnet.co.uk

•

Join Date: Sep 2007

Posts: 86

Reputation: justapimp is an unknown quantity at this point

Solved Threads: 1

justapimp

Offline

Junior Poster in Training

Re: Need help passing database column value to a string variable.

Oct 16th, 2007

Is there another implementation that works better with C#'s table data adapters. I tried your recommendation and it did not work for me.

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Re: Need help passing database column value to a string variable.

Oct 16th, 2007

Are you needing to keep the values in a data table or are you pulling them to use as an array? What exactly are you needing, if you can post it!

•

Join Date: Sep 2007

Posts: 86

Reputation: justapimp is an unknown quantity at this point

Solved Threads: 1

justapimp

Offline

Junior Poster in Training

Re: Need help passing database column value to a string variable.

Oct 16th, 2007

I want to use them as an array that I can iterate through and Possibly produce different output. For example let say my my database content looks something like this.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Column StartDateTime = 2007-12-12 11:00:00:000
Column EndDateTime = 2007-12-17 04:00:00:000
Column TimeZone = 3
Column StartDateTime = 2007-12-12 11:00:00:000
Column EndDateTime = 2007-12-17 04:00:00:000
Column TimeZone = 3

I would like to evaluate the value for the TimeZone and subtract or add the value to the StartDateTime and EndDateTime.

If I can load the values into an array, I can use a foreach statement to do the mathematical operation and return and return the datatable to be binded to a formview later.

Thank you for responding.

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Re: Need help passing database column value to a string variable.

Oct 20th, 2007

well I am not a C# man, infact I have never used it besides for helping those with problems on this and other forums. Sorry for the late response. I can do it in VB and use www.codechanger.com to change it to C#. Below is the C# code I would use, and use a reader, not a datatable unelss you need updating. It's quicker and more efficient:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
void Page_Load(Object s, EventArgs e) {
    SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]);
    SqlCommand cmd = new SqlCommand("SELECT COMMAND OR STORED PROCEDURE NAME",con);
    //Use below line if stored procedure
    //cmd.CommandType = CommandType.StoredProcedure;
 
    con.Open();
 
    ArrayList arr = new ArrayList();
    SqlDataReader dr = cmd.ExecuteReader();
 
    while(dr.Read()) {
        object[] values = new object[dr.FieldCount];
        dr.GetValues(values);
        arr.Add(values);
    }
 
    dr.Close();
    con.Close();
}
void Page_Load(Object s, EventArgs e) {
    SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]);
    SqlCommand cmd = new SqlCommand("SELECT COMMAND OR STORED PROCEDURE NAME",con);
    //Use below line if stored procedure
    //cmd.CommandType = CommandType.StoredProcedure;

    con.Open();
    
    ArrayList arr = new ArrayList();
    SqlDataReader dr = cmd.ExecuteReader();
        
    while(dr.Read()) {
        object[] values = new object[dr.FieldCount];
        dr.GetValues(values);
        arr.Add(values);
    }

    dr.Close();
    con.Close();
}