I am trying to make a list, separated by a comma, of entries from a single column in a SQL database. I have been spending the last several days searching for a way to do this, but every thing I found either didn't work, or wasn't exactly what I was looking for.
The query will pull all the email address that are not null. I already know how to do the query, so I do not need help with that. What I need to know is how to take the result of that query and make it look like this:
email0@address. com, email1@address. com, email2@address. com, etc, etc, ...
I feel like I should know this, but for the life of me, I can't remember nor can I find it in any of the textbooks I have.
I am using Visual Basic 2010 and SQL Server 2005. I also have access to Visual Basic 2005 if needed.
Any help would be appreciated. Thank you.
2 1560
A quick update. I think I have found what I am looking for. However, I am having issues with the code. Here is the code that I am using: http://www.programmersheaven.com/2/F...ng-Data-Reader
The part that I am troubles with is:
1. What do I use for the server name, and where do I find it? Like I said above, I am using SQL Server 2005.
2. What about logging in if I use Windows Authentication?
Alright, this is kind of turning into a self help thread, sorry about that. I have figured out the previous questions. Now I have some new issues.
I am using a MDI Parent form to call multiple windows. One form is to display the query from above. The second form displays the data in either a datagrid, or detail view. However, when I open the second form, close it, then open the first form and run the query, I get an error saying that I cannot login to the server. And when I open the first form and run the query, close it, then open the second form, none of my data appears. How do I fix this?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: TimG |
last post by:
12.) Now you have two different tables - each with two columns.
Table #1
Single Column
2 rows with a value equal to 1 and 2
|
by: Brett P. |
last post by:
Hello,
I am trying to have only one column sortable within a
data grid. I know you set the allow sorting property to
true on the style, but this enables sorting for all
columns. Is there a way to override this implementation
so that only a few or one of the columns may be sorted?
thanks,
-brett
|
by: gerry |
last post by:
I want to populating an asp list box from a simple access lookup list
(single column not a table.)I don't want to create tables just for
lookups as the values will be descriptive only and will never change.
What would be the command to rerieve these single column lookups in
ASP script?
Or do I have to create access tables just to hold these static lookup
values?
|
by: veg_all |
last post by:
Is there a way to select a single column from a mysql database and
directly put the results into an arrray? Here is the workaround below,
but I would like to elimniate the array_push step:
$uids=array();
$res = mysql_db_query("db", 'select uid from tbl;', $link);
while ($row = mysql_fetch_row($res)) {
array_push ($uids, $row);
}
|
by: Sonny |
last post by:
Hi,
Would like to know the performance differenece between Multi-column
Index vs Single Column Indexes. Let's say I have a table with col1,
col2, col3 along with a primary key column and non-indexed columns.
In queries, I will use col1, col2, and col3 together and some times
just one or two of these three columns. My questions is, should I
create one index contains col1, col2, and col3, or create 3 seperated
columns. I.e. each column...
| |
by: san1014 |
last post by:
Hi
I have a table
SQL> select * from nodes;
NODE_ID NODE_NAME
-------------------- ------------------------------
N1 Kothhapet
N2 Nagole
N3 Uppal
|
by: ssknov |
last post by:
hi
i need to populate a DatagridView1 with a single column values of a table.
I tried like this.
Dataset ds=new dataset();
my dataset ds retrieves and filles a single column from a table.
DataGridView1.Datasource=ds;
|
by: Darsin |
last post by:
Hi all
I need to perform a summation on a column of a table based on a
criteria given in another column in the same table. The catch is i
need to perform different sums according to the number of criterias in
the criteria column, in a single query. the structure of the table is
somethinmg like this (only relevant columns are shown)
TABLE1
Value - numeric(20,6)
Month - int
|
by: santoshjsh |
last post by:
hello everyone,
i have a gridview in which i have multiple checkboxes in a single column.
means for every row in the gridview i have four checkboxes in one column e.g Add, Delete, Print, Modify.
now i need to bind these check boxes from database table according to the four different fields in the table in which the value is 0 and 1. if the column value is 1 than the checkbox should be displayed checked otherwise no.
i dont know how...
|
by: luciegiles |
last post by:
Hi,
I wish to transpose data in an Access table currently in a single column over many rows to many columns over single row:
Current format:
CHI DateIssued
123456 01/01/10
123456 01/02/10
987654 05/01/10
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |