Need help passing database column value to a string variable.

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

Join Date: Sep 2007
Posts: 86
Reputation: justapimp is an unknown quantity at this point 
Solved Threads: 1
justapimp justapimp is offline Offline
Junior Poster in Training

Need help passing database column value to a string variable.

 
0
  #1
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
  1. GpsitDataTableAdpater provider = new GpsitDataTableAdapter();
  2. 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.
Reply With Quote Quick reply to this message  
Join Date: Oct 2006
Posts: 169
Reputation: ptaylor965 is an unknown quantity at this point 
Solved Threads: 19
Sponsor
ptaylor965's Avatar
ptaylor965 ptaylor965 is offline Offline
Junior Poster

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

 
0
  #2
Oct 6th, 2007
Hi,
This is how i do it for SQL databases
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
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 86
Reputation: justapimp is an unknown quantity at this point 
Solved Threads: 1
justapimp justapimp is offline Offline
Junior Poster in Training

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

 
0
  #3
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.
Reply With Quote Quick reply to this message  
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.

 
0
  #4
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!
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 86
Reputation: justapimp is an unknown quantity at this point 
Solved Threads: 1
justapimp justapimp is offline Offline
Junior Poster in Training

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

 
0
  #5
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.
  1. Column StartDateTime = 2007-12-12 11:00:00:000
  2. Column EndDateTime = 2007-12-17 04:00:00:000
  3. 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.
Reply With Quote Quick reply to this message  
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.

 
0
  #6
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:
  1. void Page_Load(Object s, EventArgs e) {
  2. SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]);
  3. SqlCommand cmd = new SqlCommand("SELECT COMMAND OR STORED PROCEDURE NAME",con);
  4. //Use below line if stored procedure
  5. //cmd.CommandType = CommandType.StoredProcedure;
  6.  
  7. con.Open();
  8.  
  9. ArrayList arr = new ArrayList();
  10. SqlDataReader dr = cmd.ExecuteReader();
  11.  
  12. while(dr.Read()) {
  13. object[] values = new object[dr.FieldCount];
  14. dr.GetValues(values);
  15. arr.Add(values);
  16. }
  17.  
  18. dr.Close();
  19. con.Close();
  20. }
Last edited by SheSaidImaPregy; Oct 20th, 2007 at 2:59 pm.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC