ASP.NET

Rinki Mukheraji wrote:

I have a txt file save on server inculde 'n' no of lines.

Rinki Mukheraji wrote:

when client upload txt file. then show message file not found.

Sneha Bisht wrote:

Use This Code:
protected void bttbexcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter stringWrite);

GridView1.RenderControl(htmlWrite);
this.EnableViewState = false;
GridView1.AllowPaging = false;
GridView1.AllowSorting = false;
GridView1.Attributes["runat"] = "server";
Response.Write(stringWrite.ToString());
Response.End();

}
public override void VerifyRenderingInServerForm(Control control)
{

}

if (c.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))                  
{

Label lb2;
TextBox tb2;
foreach (Control c in PlaceHolder2.Controls)             
{
if (c.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))                  
{ 
  TextBox tb2 = (TextBox)c;                   
}
else if(c.GetType().ToString().Equals("System.Web.UI.WebControls.Label"))
{
  lb2 = (Label)c;
}
}
}
SqlCommand cmdinsertliftunion = new SqlCommand("INSERT INTO table(field1, field2) VALUES ('" + lb2.Text + "', '" + tb2.Text + "')", con);                   cmdinsert.ExecuteNonQuery();                   

Label lb2 = new Label();
TextBox tb2 = new TextBox();
foreach (Control c in PlaceHolder2.Controls)
{...

Lable lb2 = (Lable)PlaceHolder2.FindControl("lb2");
TextBox tb2 = (TextBox)PlaceHolder2.FindControl("tb2");
if(lb2 != null && tb2 != null)
{
SqlCommand cmdinsertliftunion = new SqlCommand("INSERT INTO table(field1, field2) VALUES ('" + lb2.Text + "', '" + tb2.Text + "')", con);
cmdinsert.ExecuteNonQuery();     
}              

DataGrid dg = (DataGrid)PlaceHolder2.FindControl("dgTheDataGrid");
foreace(DataGridItem dgi in dg.Items)
{
Lable lb2 = (Lable)dgi.FindControl("lb2");
TextBox tb2 = (TextBox)dgi.FindControl("tb2");
if(lb2 != null && tb2 != null)
{
SqlCommand cmdinsertliftunion = new SqlCommand("INSERT INTO table(field1, field2) VALUES ('" + lb2.Text + "', '" + tb2.Text + "')", con);
cmdinsert.ExecuteNonQuery();     
}    
}

thomasa wrote:

Lable lb2 = (Lable)dgi.FindControl("lb2");
TextBox tb2 = (TextBox)dgi.FindControl("tb2");

DataGrid dg = new DataGrid();
dg.ID = "dgTheDataGrid";
dg.RunatServer = true;
DataGridItem dgi = new DataGridItem();
Lable lb2 = new Label();
lb2.ID = "lb2";
dgi.AddControl(lb2);
dg.AddControl(dgi);
PlaceHolder2.AddControl(dg);

foreach (Control c in PlaceHolder2.Controls)
                            {
                                if (c.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))
                                {
                                    int textboxId = PlaceHolder2.Controls.IndexOf(c);
                                    if (textboxId > 0)
                                    {
                                        Control cLabel = PlaceHolder2.Controls[textboxId - 1];

                                        try
                                        {
                                            Label lb2 = (Label)cLabel;
                                            TextBox tb2 = (TextBox)c;

                                            SqlCommand cmdinsert = new SqlCommand("INSERT INTO table(field1, field2) VALUES ('" + lb2.Text + "', '" + tb2.Text + "')", con);
                cmdinsert.ExecuteNonQuery(); 
                                            cmdinsertliftunion.ExecuteNonQuery();
                                        }
                                        catch (Exception)
                                        { 
                                        }
                                    }
                                }