ASP.NET gridview

Question

0.00/5 (No votes)

See more:

hey there,
i have a web form in which i have a ddl which is taking values from the db,a label which is showing price of the selected item from the ddl that too from db,a textbox in which user can input the no. of quantities of the selected item.
Now i have a gridview in which i have columns itemName,Price,Qty and amount(will b price * Qty).Now,what i want is to add new row to this gridview which includes values selected from ddl,label and quantity on a button(Add) click.

And then save these values to my db table.
Can anyone help...

thanks
Amit

Posted 9-Sep-10 18:52pm

AmitChoudhary10

Add a Solution

1 solution

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)

Ankur^\m/ · Accepted Answer · 2010-09-09T19:03:00

Solution 1

On button click, post back the page. Get these values, and update the database. Re-bind the GridView. What's the problem?

Posted 9-Sep-10 19:03pm

Ankur^\m/

Comments

AmitChoudhary10 10-Sep-10 1:11am

Well,the problem is that i am new to .NET and dont have much experience with gridview and dataBinding.

Ankur^\m/ 10-Sep-10 1:20am

In that case, go through "http://msdn.microsoft.com/en-us/library/dd548005.aspx" or "http://www.codeproject.com/KB/webforms/GridView_all_in_one.aspx" before you start programming.

AmitChoudhary10 10-Sep-10 1:39am

The thing is that either i am missing something or something is surely wrong with my code.My code for btnAdd_click is

protected void btnAddNewRow_Click(object sender, EventArgs e)
{
if (ddlSearchItems.SelectedIndex > 0)
{
DataRow drValues = dtValues.NewRow();
drValues["Id"] = ddlSearchItems.SelectedItem.Value;
drValues["Item"] = ddlSearchItems.SelectedItem.Text;
drValues["Rate"] = lblActualPrice.Text;
drValues["Qty"] = txtQuantity.Text;
drValues["Amount"] = Convert.ToInt32(lblActualPrice.Text) * Convert.ToInt32(txtQuantity.Text);
dtValues.Rows.Add(drValues);
dtValues.AcceptChanges();
gvOrders.DataSource = dtValues;
gvOrders.DataBind();
//gvOrders.Columns[0].Visible = false;
SetVisibilities(true);
gvOrders.Visible = true;
foreach (GridViewRow row in gvOrders.Rows)
{
//InsertOrder(row.Cells[0].Text, row.Cells[2].Text);
}
}
}

Ankur^\m/ 10-Sep-10 1:44am

Tell me what is not working?
BTW you are not updating the Database here (no SQLDataAdapter.Update() method).

AmitChoudhary10 10-Sep-10 1:56am

I am still working on adding row into gridview on Add button click,then i'll work on saving it to db.

Order.aspx

protected void btnAddNewRow_Click(object sender, EventArgs e)
{
if (ddlSearchItems.SelectedIndex > 0)
{
DataRow drValues = dtValues.NewRow();
drValues["Id"] = ddlSearchItems.SelectedItem.Value;
drValues["Item"] = ddlSearchItems.SelectedItem.Text;
drValues["Rate"] = lblActualPrice.Text;
drValues["Qty"] = txtQuantity.Text;
drValues["Amount"] = Convert.ToInt32(lblActualPrice.Text) * Convert.ToInt32(txtQuantity.Text);
dtValues.Rows.Add(drValues);
dtValues.AcceptChanges();
gvOrders.DataSource = dtValues;
gvOrders.DataBind();
//gvOrders.Columns[0].Visible = false;
SetVisibilities(true);
gvOrders.Visible = true;
foreach (GridViewRow row in gvOrders.Rows)
{
//InsertOrder(row.Cells[0].Text, row.Cells[2].Text);
}
}
}

Order.aspx.cs

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using ChalkHillDAL;

namespace ChalkHill
{
public partial class Order : System.Web.UI.Page
{

public static DataTable dtValues;
private string conn = string.Empty;
SQLHelper objSqlHelper = new SQLHelper();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CreateDataTable();
AddValuesToSearchDropdown();
}
}
private void PopulateItems()
{

}
protected void btnAddNewRow_Click(object sender, EventArgs e)
{
if (ddlSearchItems.SelectedIndex > 0)
{
DataRow drValues = dtValues.NewRow();
drValues["Id"] = ddlSearchItems.SelectedItem.Value;
drValues["Item"] = ddlSearchItems.SelectedItem.Text;
drValues["Rate"] = lblActualPrice.Text;
drValues["Qty"] = txtQuantity.Text;
drValues["Amount"] = Convert.ToInt32(lblActualPrice.Text) * Convert.ToInt32(txtQuantity.Text);
dtValues.Rows.Add(drValues);
dtValues.AcceptChanges();
gvOrders.DataSource = dtValues;
gvOrders.DataBind();
//gvOrders.Columns[0].Visible = false;
SetVisibilities(true);
gvOrders.Visible = true;
foreach (GridViewRow row in gvOrders.Rows)
{
//InsertOrder(row.Cells[0].Text, row.Cells[2].Text);
}
}
}

private void InsertOrder(string productName, string quantity)
{
objSqlHelper.InsertOrderInDB("insert into tblOrderItems (Pid, QtyOrdered) values ('" + productName + "'," + quantity + ")");
}

protected void CreateDataTable()
{
dtValues = new DataTable();
dtValues.Columns.Add("Id");
dtValues.Columns.Add("Item");
dtValues.Columns.Add("Rate");
dtValues.Columns.Add("Qty");
dtValues.Columns.Add("Amount");
}

private void AddValuesToSearchDropdown()
{
DataSet dsProducts = objSqlHelper.GetProducts("select * from tblProducts");
if (dsProducts != null)
{
ddlSearchItems.DataSource = dsProducts;
ddlSearchItems.DataTextField = "ProductName";
ddlSearchItems.DataValueField = "Pid";

AmitChoudhary10 10-Sep-10 2:00am

hey,Why is it not showing the complete data sent by me?...

AmitChoudhary10 10-Sep-10 2:03am

i've my sql work done in a seperate project file that is referenced to it

SQLHelper.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace ChalkHillDAL
{
public class SQLHelper
{
public static SqlConnection conn;
public SQLHelper()
{

}
private static SqlConnection GetConnection()
{
conn = new SqlConnection(ConfigurationSettings.AppSettings["conn"].ToString());
conn.Open();
return conn;
}
private static void DisposeConnection()
{
if (conn != null)
{
conn.Close();
conn.Dispose();
}
}
public DataSet GetProducts(string query)
{
DataSet ds = new DataSet();
try
{
SqlConnection conn = GetConnection();
SqlDataAdapter da = new SqlDataAdapter(query, conn);

da.Fill(ds);
}
catch (Exception ex)
{ }
finally
{ DisposeConnection(); }
return ds;
}
public DataSet GetProductDetails(string query)
{
DataSet ds = new DataSet();
try
{
SqlConnection conn = GetConnection();
SqlDataAdapter da = new SqlDataAdapter(query, conn);

da.Fill(ds);
}
catch (Exception ex)
{ }
finally
{ DisposeConnection(); }
return ds;
}

public void InsertOrderInDB(string query)
{
try
{
SqlConnection conn = GetConnection();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{ }
finally
{ DisposeConnection(); }
}
}
}

Ankur^\m/ 10-Sep-10 2:09am

You mean, the new row is not added to your GridView?

AmitChoudhary10 10-Sep-10 2:16am

yes,dats d prob.is my code missin something required?...

I am using template feild(item template and footer template) in my gridview columns.i m just askin 4 code to add a new row to grid on button click dat will show values frm my ddl,label and textbox.

Ankur^\m/ 10-Sep-10 2:58am

FooterTemplate? for what?
Your code seems fine to me (the first code that you pasted here). Put a break-point and check the value of table if it contains the new row before binding the gridview.