how to insert the data in GridView from Textboxes on button click.

Question

0.00/5 (No votes)

See more:

hi i have been stuck on that problem for last 2 days. i want to get the data from textboxes and on button click i want that data to be inserted in gridview. on every click there shud be a new row created and old row must not be removed. here is my code. whenever i enter the new data and click on button my old row is deleted and new row is stored in place of it. Kindly help me with my that problem thanx.

C#

        private void gridVIEWData()
       {

           dt1.Columns.Add("pName", typeof(string));
           dt1.Columns.Add("pCategory", typeof(string));
           dt1.Columns.Add("price", typeof(string));
           dt1.Columns.Add("pQuantity", typeof(string));
           dt1.Columns.Add("totalPrice", typeof(string));
       }
       protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
       {

       }

       protected void TextBox4_TextChanged(object sender, EventArgs e)
       {

       }

       protected void txt_productCode_TextChanged(object sender, EventArgs e)
       {

       }

       protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
       {

       }

protected void Button3_Click(object sender, EventArgs e)
        {
            if (!flag)
            {
                gridVIEWData();
                flag = true;
                Int32 total = Convert.ToInt32(txt_quantity.Text) * Convert.ToInt32(txt_price.Text);
                DataRow dr = dt1.NewRow();
                dr["pName"] = DropDownList2.SelectedItem;
                dr["pCategory"] = DropDownList1.SelectedItem;
                dr["price"] = txt_price.Text;
                dr["pQuantity"] = txt_quantity.Text;
                dr["totalPrice"] = total;
                dt1.Rows.Add(dr);

                GridView1.DataSource = dt1;
                GridView1.DataBind();
            }
            else if (!IsPostBack)
            {
                Int32 total = Convert.ToInt32(txt_quantity.Text) * Convert.ToInt32(txt_price.Text);
                DataRow dr = dt1.NewRow();
                dr["pName"] = DropDownList2.SelectedItem;
                dr["pCategory"] = DropDownList1.SelectedItem;
                dr["price"] = txt_price.Text;
                dr["pQuantity"] = txt_quantity.Text;
                dr["totalPrice"] = total;
                dt1.Rows.Add(dr);

                GridView1.DataSource = dt1;
                GridView1.DataBind();
            }
            
            //else if (!IsPostBack)
            //{
            //    Int32 total = Convert.ToInt32(txt_quantity.Text) * Convert.ToInt32(txt_price.Text);
            //    DataRow dr = dt1.NewRow();
            //    dr["pName"] = DropDownList2.SelectedItem;
            //    dr["pCategory"] = DropDownList1.SelectedItem;
            //    dr["price"] = txt_price.Text;
            //    dr["pQuantity"] = txt_quantity.Text;
            //    dr["totalPrice"] = total;
            //    dt1.Rows.Add(dr);

            //   GridView1.DataSource = dt1;
            //   GridView1.DataBind();
            //}
            
        }
    }

Posted 13-Oct-12 5:41am

Omar Shehzad

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Omar Shehzad · Answer 1 · 2012-10-13T21:38:00

Solution 2

thanks alot buddy. i have solved it myself. now i m getting problem in deleting a row from it.can anyone help.

Posted 13-Oct-12 21:38pm

Omar Shehzad

vv_shameer · Answer 2 · 2012-10-13T07:07:00

Why this problem happens is Asp.Net cannot persist the changes in DataTable you created between different requested. You need to write code to persist these changes. One solution is to store the data table in a Session variable after adding the new row. Also make sure to retrieve the same data table from this session before adding the next row.

The code will look like this;
C#

DataTable dt1=new DataTable(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["a"] = null; } }

C#

protected void Button3_Click(object sender, EventArgs e)
{
if  Session["a"]==null)
            {
                gridVIEWData();
                //flag= true;
                Int32 total = Convert.ToInt32(txt_quantity.Text) * Convert.ToInt32(txt_price.Text);
                DataRow dr = dt1.NewRow();
                dr["pName"] = DropDownList2.SelectedItem;
                dr["pCategory"] = DropDownList1.SelectedItem;
                dr["price"] = txt_price.Text;
                dr["pQuantity"] = txt_quantity.Text;
                dr["totalPrice"] = total;
                dt1.Rows.Add(dr);
 Session["datas"]=dt1;
                GridView1.DataSource = dt1;
                GridView1.DataBind();
            }
            else             {
                Int32 total = Convert.ToInt32(txt_quantity.Text) * Convert.ToInt32(txt_price.Text);
DataTable dtcached = (DataTable)Session["a"];
                DataRow dr = dtcached.NewRow();
                dr["pName"] = DropDownList2.SelectedItem;
                dr["pCategory"] = DropDownList1.SelectedItem;
                dr["price"] = txt_price.Text;
                dr["pQuantity"] = txt_quantity.Text;
                dr["totalPrice"] = total;
DataTable dtCached=(DataTable)Session["datas"];
                dtCached.Rows.Add(dr);
 
                GridView1.DataSource = dtCached;                GridView1.DataBind();
            }
}

Changed code I have shown it in BOLD, Hope this helps.. It is not good to use lot of session variable as it adds more loads to server, but it gives you a hint

how to insert the data in GridView from Textboxes on button click.

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us