Click here to Skip to main content
15,886,919 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionHow to fetch data from database in lables in asp.net using three tier architecture Pin
mohansahu7-Jun-12 21:18
mohansahu7-Jun-12 21:18 
AnswerRe: How to fetch data from database in lables in asp.net using three tier architecture Pin
Sandeep Mewara7-Jun-12 22:43
mveSandeep Mewara7-Jun-12 22:43 
QuestionCombining Array with delimiters Pin
Fiona Tan7-Jun-12 7:05
Fiona Tan7-Jun-12 7:05 
AnswerRe: Combining Array with delimiters Pin
thoiness7-Jun-12 7:19
thoiness7-Jun-12 7:19 
GeneralRe: Combining Array with delimiters Pin
Fiona Tan7-Jun-12 7:34
Fiona Tan7-Jun-12 7:34 
GeneralRe: Combining Array with delimiters Pin
thoiness7-Jun-12 7:39
thoiness7-Jun-12 7:39 
GeneralRe: Combining Array with delimiters Pin
Fiona Tan7-Jun-12 8:29
Fiona Tan7-Jun-12 8:29 
GeneralRe: Combining Array with delimiters Pin
thoiness7-Jun-12 8:53
thoiness7-Jun-12 8:53 
I suspect you may be starting to get way over your head here. You may need a contract developer to piece all this together.
StringBuilder sb = new StringBuilder();

using (SqlConnection conn = new SqlConnection("(replace this with a real connection string)"))
{
  conn.Open();
  using (SqlCommand cmd = new SqlCommand("SELECT Email FROM Customers WHERE newsletterAgree = 1", conn))
  {
     using (SqlDataReader rdr = cmd.ExecuteReader())
     {
       while (rdr.Read())
         sb.AppendFormat("{0};", rdr["Email"]);
     }
  }
}

string finalString = sb.ToString();

If you want to convert finalString to an array, then once again, you need to do:
string[] finalArr = finalString.Split(';');

This should be compatible with all versions of ASP.NET
AnswerRe: Combining Array with delimiters Pin
Vitaly Tomilov10-Jun-12 7:01
Vitaly Tomilov10-Jun-12 7:01 
QuestionDynamic Ajax accordion not fetching any data at production server Pin
Member 90849896-Jun-12 22:01
Member 90849896-Jun-12 22:01 
AnswerRe: Dynamic Ajax accordion not fetching any data at production server Pin
Richard MacCutchan7-Jun-12 5:21
mveRichard MacCutchan7-Jun-12 5:21 
AnswerRe: Dynamic Ajax accordion not fetching any data at production server Pin
jkirkerx7-Jun-12 8:24
professionaljkirkerx7-Jun-12 8:24 
AnswerRe: Dynamic Ajax accordion not fetching any data at production server Pin
Vitaly Tomilov10-Jun-12 7:06
Vitaly Tomilov10-Jun-12 7:06 
Questionhow to pass values from 1 page to another.. Pin
SumitChandra6-Jun-12 21:07
SumitChandra6-Jun-12 21:07 
AnswerRe: how to pass values from 1 page to another.. Pin
paulalvin6-Jun-12 22:01
paulalvin6-Jun-12 22:01 
AnswerRe: how to pass values from 1 page to another.. Pin
paulalvin6-Jun-12 22:07
paulalvin6-Jun-12 22:07 
GeneralRe: how to pass values from 1 page to another.. Pin
SumitChandra7-Jun-12 1:56
SumitChandra7-Jun-12 1:56 
GeneralRe: how to pass values from 1 page to another.. Pin
R. Giskard Reventlov7-Jun-12 5:08
R. Giskard Reventlov7-Jun-12 5:08 
GeneralRe: how to pass values from 1 page to another.. Pin
thoiness7-Jun-12 6:53
thoiness7-Jun-12 6:53 
AnswerRe: how to pass values from 1 page to another.. Pin
k@ran7-Jun-12 5:51
k@ran7-Jun-12 5:51 
AnswerRe: how to pass values from 1 page to another.. Pin
basurajkumbhar8-Jun-12 0:04
basurajkumbhar8-Jun-12 0:04 
GeneralRe: how to pass values from 1 page to another.. Pin
RichardGrimmer11-Jun-12 5:07
RichardGrimmer11-Jun-12 5:07 
AnswerRe: how to pass values from 1 page to another.. Pin
thatraja7-Jun-12 9:13
professionalthatraja7-Jun-12 9:13 
AnswerRe: how to pass values from 1 page to another.. Pin
bishu_Visu8-Jun-12 20:09
bishu_Visu8-Jun-12 20:09 
AnswerRe: how to pass values from 1 page to another.. Pin
ashjassi17-Aug-12 3:11
ashjassi17-Aug-12 3:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.