Get specific row value

Results 1 to 2 of 2

Thread: Get specific row value

  1. #1
    Join Date
    Dec 1969

    Default Get specific row value

    Hi, <BR>I am using Asp.Net & C#..<BR>Presently I am using the DataSet ... <BR><BR>DataSet ds = new DataSet(); <BR>cmd_DB.FillDataSet(ds, "myMDB_DBS"); <BR><BR>I need to get the value of one field & store it in a session variable. <BR>How do I do that ??? <BR><BR>eg. in a tabel structure such as.... <BR>id, username, password. <BR>I am using a <BR><BR>select * from myMDB_DBS where username="nicole" <BR><BR>query to filldataset. <BR><BR>How do I get the value <BR>of the password field to store into a session variable ??? <BR><BR>Please help <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Get specific row value

    Just feeling my way around ASP.NET too but this may do what you want:<BR><BR>strPassword = cmd_DB.Tables("myMDB_DBS").Rows(0)("Password")<BR> <BR>Of course you&#039;d better check that records were returned etc. before using this.<BR>Its so hard to get help on all this stuff - is very useful but it lacks descriptions of what each class/method/property etc. acutally does. Alot of guess work and compilations has had to be my strategy so far.<BR><BR>good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts