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 > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
