Hi Nirmal
Use this code. I have checked it works fine & fulfill your requirement
StringBuilder sb = new StringBuilder();
for (int i = 0; i<dsTemp.Tables[0].Rows.Count; i++)
{
string strTemp = "";
for (int j = 0; j < dsTemp.Tables[0].Columns.Count; j++)
{
strTemp += dsTemp.Tables[0].Rows[i][j].ToString() +
" ";
}
strTemp += "<BR>";
sb.Append(strTemp);
}
Response.Write(sb.ToString());
Check it & let me know whether it work
Regards
KK
Nirmal Abraham <[EMAIL PROTECTED]> wrote:Sir,
How to use Loop through the column names of the table sir.
Help me Sir.
------------------------------------------------------------------------------------------------------
Mischa Kroon <[EMAIL PROTECTED]> wrote:
Loop through the column names of the table and add these.
----- Original Message -----
From: "Nirmal Abraham" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, September 12, 2005 1:00 PM
Subject: Re: [AspNetAnyQuestionIsOk] DataGrid to Text(Nirmal) : Help me Sir
> Sir,
> Very very THANK YOU,
>
> I also want the Header row Sir,
>
> -----------------------------------------------------------------------------------------------------------
>
> Mischa Kroon <[EMAIL PROTECTED]> wrote:
> in beginning of code define a variable which holds the column width.
>
> like:
>
> Columnwidth = 30
> then when appending to outputstream fill it out to this width.
>
> str.Append(ds.Tables[0].Rows[i][j].ToString().Padright(Columnwidth ));
>
> ----- Original Message -----
> From: "Nirmal Abraham" <[EMAIL PROTECTED]>
> To: "ASP.NET" <[email protected]>
> Sent: Monday, September 12, 2005 11:04 AM
> Subject: [AspNetAnyQuestionIsOk] DataGrid to Text(Nirmal) : Help me Sir
>
>
>>
>> Help Me Sir :
>>
>>
>>
>> The Given Coding :
>>
>>
>>
>>
>>
>> public void Bind1()
>>
>> {
>>
>> SqlConnection sqlConnection = new
>> SqlConnection("database=Payrull;server=sj2005;uid=sa;pwd=;");
>>
>>
>>
>> sqlConnection.Open();
>>
>>
>>
>> SqlDataAdapter ada = new SqlDataAdapter("SELECT
>> Emp_no,Emp_name,F_Name from Paymast",sqlConnection);
>>
>>
>>
>> ds = new DataSet();
>>
>>
>>
>> ada.Fill(ds);
>>
>>
>>
>> rec.DataSource = ds.Tables[0] ;
>>
>> rec.DataBind();
>>
>> {
>>
>> StringBuilder str = new StringBuilder();
>>
>>
>>
>> for(int i=0;i<=ds.Tables[0].Rows.Count - 1; i++)
>>
>>
>>
>> {
>>
>>
>>
>> for(int j=0;j<=ds.Tables[0].Columns.Count - 1; j++)
>>
>>
>>
>> {
>>
>>
>>
>> str.Append(ds.Tables[0].Rows[i][j].ToString());
>>
>>
>>
>> str.Append(char.ToString('\t'));
>>
>> str.Append(char.ToString('\t'));
>>
>> }
>>
>> str.Append(Environment.NewLine);
>>
>> }
>>
>> Response.Clear();
>>
>>
>>
>> Response.AddHeader("content-disposition",
>> "attachment;filename=FileName.txt");
>>
>>
>>
>> Response.Charset = "";
>>
>>
>>
>> Response.Cache.SetCacheability(HttpCacheability.NoCache);
>>
>>
>>
>> Response.ContentType = "application/vnd.text";
>>
>>
>>
>> System.IO.StringWriter stringWrite = new System.IO.StringWriter();
>>
>>
>>
>> System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
>>
>>
>>
>> rec.RenderControl(htmlWrite);
>>
>>
>>
>> Response.Write(str.ToString());
>>
>>
>>
>> Response.End();
>>
>> }
>>
>> }
>>
>>
>>
>> The Output :
>>
>>
>>
>> The Ouput is in Irregular Format
>>
>>
>>
>> 1 Michael Benjamin
>>
>> 10 Samuel Arumainayagam K.
>>
>> 11 Pratheep B.
>>
>> 11013 Jeyachandran P. Peter Chelliah
>> Y.
>>
>> 11024 Palani Kumar N. Natarajan
>>
>> 11035 Selvakumar Samuel A. Aron Durai Pandian
>>
>> 11046 Jeyaraj J. Joseph
>>
>> 11057 Chandrasekaran S. Sankaralingam
>>
>> 11068 Asir Gnanadoss T. Thiagaraj
>>
>> 11079 Rajendra Prasad S. Sonachalam
>>
>> 11081 Alphonse D. SMN Fernando
>>
>> 11092 Latha K. Kaisinth S.
>>
>> 11103 Balasubramaniam G. Ganapathy
>>
>> 11114 Vedanayagam P. Paramasivan
>>
>> 11125 Jeyakumar Thanasing P. Paulraj
>> Abraham
>>
>> 11136 Immanuel K.Jeyaprakash Koilpillai
>>
>> 11147 Thangaraj R. Rajamany D.
>>
>> 11158 Selvadurai P.M. Pandiyaraj
>>
>> 11169 Suriyan S. Subramonian
>>
>> 11171 Rajendran S. Sathiamurthy
>>
>> 11182 Jessy Devi G. Gerald P. Rayen
>>
>> 11193 Meenatchi Sundaram V. Veerabahu
>>
>> 11204 Subbiah M. Muthiah
>>
>>
>>
>>
>>
>> Sir the Output not in Proper Manner . I Have to arrange in the table
>> form.
>>
>> But not the table.
>>
>>
>>
>> Example : I want the Output Like this
>>
>>
>>
>> 101 Nirmal. Manuel.
>>
>> 102 Sundaram. Arun.
>>
>> 103 Zion.
>>
>> 10411 Arun.
>>
>>
>>
>> In this Format I want Sir. Please Help me Sir.
>>
>>
>>
>> ---------------------------------
>> Yahoo! India Matrimony: Find your partner now.
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>
>
>
> SPONSORED LINKS
> Basic programming language Computer programming languages Programming
> languages Java programming language The history of computer programming
> language
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "AspNetAnyQuestionIsOk" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ---------------------------------
>
>
>
>
> ---------------------------------
> Yahoo! India Matrimony: Find your partner online.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
SPONSORED LINKS
Basic programming language Computer programming languages Programming languages
Java programming language The history of computer programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! India Matrimony: Find your partner now.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Basic programming language Computer programming languages Programming languages
Java programming language The history of computer programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
--------------------------------------------------------------------
Krishan Kant Chamoli Office: +91-172-2653886
AuthorGen Technology (P) Ltd., Fax: +91-172-5018485
24/3, Industrial Area, Phase - 2, Mobile: 9888263726
Chandigarh. INDIA. Pin - 160002. Email: [EMAIL PROTECTED]
--------------------------------------------------------------------
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
