how to put the header for this values

[phanimadhav]

1,anuradha,23000,10,
4,Bhanu Kiran,10000,10,
5,Bhanu Prakash,20000,10,
6,fanendra,33000,20,
7,vamsi,8000,30,
8,joythi,18000,40,
9,naveena,18000,40,
10,ramakrishna,12000,30,
11,ravindra,22000,20,
12,satish,11000,10,
13,lakshmi,30000,20,
14,sudheer,27000,20,
15,Suman Chandra,20000,40,
16,suresh,19000,40,
17,negeswerarao,25000,30,
2,Anuradha,18000,10,
3,arunbabu,10000,20,

this is my .csv file.I got this values from sqlserver but how to get the columnheader from sqlserver please help me.thankq

[dip_developer]

1,anuradha,23000,10,
4,Bhanu Kiran,10000,10,
5,Bhanu Prakash,20000,10,
6,fanendra,33000,20,
7,vamsi,8000,30,
8,joythi,18000,40,
9,naveena,18000,40,
10,ramakrishna,12000,30,
11,ravindra,22000,20,
12,satish,11000,10,
13,lakshmi,30000,20,
14,sudheer,27000,20,
15,Suman Chandra,20000,40,
16,suresh,19000,40,
17,negeswerarao,25000,30,
2,Anuradha,18000,10,
3,arunbabu,10000,20,

this is my .csv file.I got this values from sqlserver but how to get the columnheader from sqlserver please help me.thankq

Retrieving column names of a table:
In some cases, you need to get the columns of a specific table. There are
basically 3 approaches to do this :

1.Use the sp_help procedure to get extended information about a
database object. By database object, we mean a table, view, and the like (you
can find extended information on this procedure at BOL).

2.You can use the following select statement to retrieve a table’s columns:
SELECT TOP 0 * FROM table_name

3.The third approach, which I personally prefer, is using the schema object of
SQL Server. For example, to retrieve the column names of Authors table, you can
use the following SELECT statement:
SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'authors'
Which results in the following result set:

column_name
----------------------------
au_id
au_lname
au_fname
phone
address
city
state
zip
contract
(9 row(s) affected)

[phanimadhav]

thank u for ur replay
this is my code

StreamWriter writer = File.CreateText(filename);
SqlCommand command1 = new SqlCommand("select top 0 * from mymca", connection);
SqlDataAdapter adapter1 = new SqlDataAdapter(command1);
DataSet ds1=new DataSet();
adapter1.Fill(ds1, "mymca");
DataTable dt1 = ds.Tables["mymca"];
string s2 = ds.Tables["mymca"].Rows[0].ToString();
writer.Write(s2);

how to print the header please help me

[ammoos]

pls try this

StreamWriter writer = File.CreateText(filename);
SqlCommand command1 = new SqlCommand("select * from mymca", connection);
SqlDataAdapter adapter1 = new SqlDataAdapter(command1);
DataSet ds1=new DataSet();
adapter1.Fill(ds1, "mymca");
string s2 = ds.Tables["mymca"].Columns[columnCount].ColumnName;
writer.Write(s2);

in this columnCount is the index of the columns starting from 0

eg:
string s2 = ds.Tables["mymca"].Columns[0].ColumnName;
writer.Write(s2);
string s2 = ds.Tables["mymca"].Columns[1].ColumnName;
writer.Write(s2);
string s2 = ds.Tables["mymca"].Columns[2].ColumnName;
writer.Write(s2);
string s2 = ds.Tables["mymca"].Columns[3].ColumnName;
writer.Write(s2);

[phanimadhav]

thanks for ur replay .i got the answer thank q very much.once again tankq very much have a greate day bye.

[Plater]

If you have a DataReader (or use a DataAdapter to fill a DataSet/DataTable) all the column names are populated into properties of the object.

[phanimadhav]

thanks plater i got the answer.thanks for your replay.thankq very much.have a greate day bye.