ASP.NET

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)
                                        { 
                                        }
                                    }
                                }

J4amieC wrote:

Last time you said it wasnt you that downvoted, but this is too much of a coincidence!

J4amieC wrote:

I suggest you are downvoting answers where you either dont like or dont understand the answer given.

J4amieC wrote:

Therefore, for the time being at least I will personally not be answering any of your questions.

.netman wrote:

Considering your answer yesterday to one of my posts was a sarcastic 'go and read a beginners tutorial'

.netman wrote:

An example tutorial for an arraylist closely applied to my situation was what I was looking for.

J4amieC wrote:

You seem to be having memory problems,

J4amieC wrote:

If that isn't screaming "beginning programming book" then its beyond me what is.

.netman wrote:

Yes but your reply(which you deleted to cover your back)

.netman wrote:

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

if(c is TextBox)
{
}

TextBox tb = c as TextBox
if(tb != null)
{
}