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 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/
