about gridview - -new help

At my GRIDVIEW I have 2 columns namely "unit price" and "quantity".
I want to display the product of these 2 columns in another field called "amount" on the GRIDVIEW.
I wish to display the calculated value in this third column once the user lost focus from unit price or quantity.
I will appreciate urgent help...please.

Re: about gridview - -new help

Check the solution for a similar question at http://forums.asp.net/p/1100193/1670896.aspx#1670896

Thanks

Re: about gridview - -new help

Thanks... thanks a lot.....

now i am at another problem. i want to save data to database from that gridview. can u help me by giving c# code?

Re: about gridview - -new help

patuary,

If you want to save the data to a MS SQL DB, I would suggest using a simple stored procedure. Then what you can do is databind the gridview to the SP and there you have it. You can save the data with virtually no code other than the SP.

If you have any ?'s on this, let us know

thnx,

Mark As Answer If this has helped you

Re: about gridview - -new help

thanks... can u provide me C# code??

Re: about gridview - -new help

Check Data Tutorials of this site.

Thanks

Re: about gridview - -new help

thanks a lot again.... now another problem. at page load event i bound salesAmount column by 0(Grid View)...

when i want to save data to database the new calculated value(sales qty*price per qty) does not save... the default value doing save!!!!!

Re: about gridview - -new help

patuary
.... now another problem. at page load event i bound salesAmount column by 0(Grid View)...

You need to keep your page load event code to bound salesAmount column in an IsPostBack check

void Page_Load(.....)
{
    if ( ! Page.IsPostBack )
    {
        // write your code here to bound the salesAmount
    }
}

When you try to save the new calculated values, on the insert/update command, the page_load will be called first and your values are getting reset. If you use the PostBack check, the code is executed only the first time and not on subsequent postback's

Thanks

Re: about gridview - -new help

yes i did it......... BUT still remain same...

I cant understand what is the problem....... this problem is also to others 0 default valued fields...

    string strSQL = "", strCon = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!Page.IsPostBack)
            {
                //GET CONNECTED
                strCon = ConfigurationManager.ConnectionStrings["DB_OrderConnectionString"].ConnectionString;
                SqlConnection con = new SqlConnection(strCon);
                con.Open();

                //GET SERVER DATE
                //this.lblEntryDate.Text = DateTime.Now.ToString("dd-MMM-yyyy");

                //GET PRODUCT INFO

strSQL = "SELECT intProductCode, strProductName as ProductName, SKU, Pack, intQtyPerCase AS QtyPerCase, mnyCasePrice,

0 as QtyToDeliv, 0 as BonusQty, 0 as SalesAmnt, intBonusQtyPerCase FROM tblProductInfo ORDER BY strProductName, intProductCode";

                SqlCommand cmdP = new SqlCommand(strSQL, con);

                SqlDataAdapter AdapterP = new SqlDataAdapter(cmdP);
                DataTable dtProduct = new DataTable();
                AdapterP.Fill(dtProduct);
                this.GVChallanEntry.DataSource = dtProduct;
                this.GVChallanEntry.DataBind();
                cmdP.Cancel();
                cmdP.Dispose();

                //CLOSE CONNECTION
                con.Close();
            }

        }
        catch (Exception ex)
        {
            lblErr.Text = ex.Message;
            if (lblErr.Text == "Line 1: Incorrect syntax near '='.")
                Response.Redirect("ChallanEntryScreen01.aspx");
            else
                lblErr.Text = ex.Message;
        }

    }

Re: about gridview - -new help

i have solved this problem myself... thanks for help

Calender Control

How could i make this code work for every year rather only for 2012......... holiday["1/1/2012"] = "New Year"; holiday["1/5/2012"] = "Guru Govind Singh Jayanti"; holiday["1/8/2012"] = "Muharam (Al Hijra)"; holiday["1/14/2012"] = "Pongal"; holiday["1/26/2012"] = "Republic Day"; holiday["2/23/2012"] = "Maha Shivaratri"; holiday["3/10/2012"] = "Milad un Nabi (Birthday of the Prophet"; holiday["3/21/2012"] = "Holi"; holiday["3/21/2012"] = "Telugu New Year";

Re: Calender Control

If they all fall on the same day every year, then simply remove the year from the key and you can compare month/day alone.

Re: Calender Control

Removed year from the key... tried changing this code lab.Text = (string)holidaylist[e.Day.Date.Month]; to lab.Text = (string)holidaylist[e.Day.Date.Month, e.Day.Date.Day]; but getting an error if (holidaylist[e.Day.Date.ToShortDateString()] != null) { Literal lit = new Literal(); lit.Text = "<br/>"; e.Cell.Controls.Add(lit); Label lab = new Label(); lab.Text = (string)holidaylist[e.Day.Date.Month]; Label1.Font.Size = new FontUnit(FontSize.Small); e.Cell.Controls.Add(lab); }

Re: Calender Control

Hi,

check...

http://forums.asp.net/t/1627219.aspx/1

http://www.aspnet101.com/2008/11/holidays-with-the-calendar-control/

Re: Calender Control

Hi,

check the link for holiday calender..

http://www.c-sharpcorner.com/uploadfile/d5b8d2/how-to-add-holiday-details-within-calendar-control/

http://www.codeproject.com/Articles/26704/Calendar-control-and-holidays

Re: Calender Control

Error::lab.Text = (string)holidaylist(e.Day.Date.Month, e.Day.Date.Day); 'Calender.holidaylist' is a 'field' but is used like a 'method' protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { if (holidaylist[e.Day.Date.ToShortDateString()] != null) { Literal lit = new Literal(); lit.Text = "<br/>"; e.Cell.Controls.Add(lit); Label lab = new Label(); lab.Text = (string)holidaylist(e.Day.Date.Month, e.Day.Date.Day); Label1.Font.Size = new FontUnit(FontSize.Small); e.Cell.Controls.Add(lab); }}

Re: Calender Control

Hi,

it may like..

lab.Text = (string)holidaylist[e.Day.Date.Month, e.Day.Date.Day];

[] instead of ()

try it..

Thanks...

Re: Calender Control

Error :No overload for method 'this' takes '2' arguments

Re: Calender Control

This isn't working any alternatives?

Re: Calender Control

lab.Text = (string)holidaylist[e.Day.Date.Month, e.Day.Date.Day];

lab.Text = (string)holidaylist[e.Day.Date.Month][e.Day.Date.Day];