ASP.NET

Re: How to sum selected gridview values?

27-Jan-09 22:01

You are right. This has to be done using JS. Here[^] is an article. When each checkbox is checked, you need to get the price and sum it.

Navaneeth

How to use google | Ask smart questions

Manas Bhardwaj27-Jan-09 22:39

Manas Bhardwaj

27-Jan-09 22:39

mark.d.inman wrote:
I'd like a checkbox next to each item, so that a user could select multiple products and then display in the footer the sum of the prices selected.

Look, you can start by attaching a check changed handler. Have a look at this [^]example.

mark.d.inman wrote:
I really have no idea where to start, can someone please just point in right direction to do this with javascript?

Next, step would be sum up the price in a client variable when ever a item is checked and subtract it whenevr it is unchecked.
Now, show this value in footre/(or wherever) Rose | [Rose]

mark.d.inman wrote:
Oh and I'm still on .Net 2.0

That does not matter.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Problem in installing DotNetNuke

Piyush Vardhan Singh27-Jan-09 20:34

27-Jan-09 20:34

Hello Friend

I am installing DotNetNuke on my system. but it give Error>> How i resolved this error Please Hlep ME.

ERROR:-Installing Database - Version 5.0.0...FAILURE 400 - The stored procedure 'test.UpdateDatabaseVersionAndName' doesn't exist.

Thanks

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

N a v a n e e t h27-Jan-09 20:38

27-Jan-09 20:38

This is ASP.NET forum. You have to try DotnetNuke customer support of their support forums.

Navaneeth

How to use google | Ask smart questions

Piyush Vardhan Singh27-Jan-09 20:45

27-Jan-09 20:45

But It Related to ASP.net

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

N a v a n e e t h27-Jan-09 20:47

27-Jan-09 20:47

Piyush Vardhan Singh wrote:
But It Related to ASP.net

ERROR:-Installing Database - Version 5.0.0...FAILURE 400 - The stored procedure 'test.UpdateDatabaseVersionAndName' doesn't exist.

. How that is related to ASP.NET ?

Smile | :)

Navaneeth

How to use google | Ask smart questions

Piyush Vardhan Singh27-Jan-09 20:50

27-Jan-09 20:50

It raise through the dotnetnuke asp.net application.This way it related to ASP.net

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Abhijit Jana27-Jan-09 21:51

Abhijit Jana

27-Jan-09 21:51

Piyush Vardhan Singh wrote:
Hello Friend

I am installing DotNetNuke on my system. but it give Error>> How i resolved this error Please Hlep ME.

ERROR:-Installing Database - Version 5.0.0...FAILURE 400 - The stored procedure 'test.UpdateDatabaseVersionAndName' doesn't exist.

Thanks

Did you change the connection string in web.config ? if yes, Which option are your selecting during installation? Select AutoOption. It will automatically upgrade your database.

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Piyush Vardhan Singh27-Jan-09 21:57

27-Jan-09 21:57

where i select Auto option

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Piyush Vardhan Singh27-Jan-09 22:06

27-Jan-09 22:06

i gated

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Tooltip on gridview, how to ?

Frauke28-Jan-09 4:23

Frauke

28-Jan-09 4:23

First off, I have heard a lot of people have problems with DNN 5.0. Try installing 4.9 instead.

For really good guides, take a look at Michael Washington's site. DNN installations are explained in great detail...

http://www.adefwebserver.com/DotNetNukeHELP/[^]

Frauke Nonnenmacher

Creative Cats

Docarctiss27-Jan-09 19:55

Docarctiss

27-Jan-09 19:55

Hello,

I am new to programming, i am trying to create a Tooltip on a Gridview column. I did convert the column to a template field and the items in the column are labels. I populate the Gridview with SQL sever. I would like to create a Tooltip that would display more detail on the column item but i have no idea where to start, if someone could help me threw this it will be highly appreciated.

Thanks for the ..... help Blush | :O

Re: Tooltip on gridview, how to ?

Sundar_R27-Jan-09 21:08

Sundar_R

27-Jan-09 21:08

Did you try setting the tooltip of the labels in rowdatabound method ?

Re: Tooltip on gridview, how to ?

Docarctiss27-Jan-09 22:02

Docarctiss

27-Jan-09 22:02

Yes i am busy doing that now, i am just struggling to link the javascript side to the css side,

How to Add an UpdatePanel dynamically?

meeram39527-Jan-09 19:01

27-Jan-09 19:01

In my form, I have two dropdownists called Countries and States which are dynamically generating. These controls are generating only at the run time and the Country dropdown gets loaded for the first time.

I have written code for the SelectedIndexchanged of the Country dropdown so that the corresponding States also will get updated in the States dropdownlists. These are all working fine.

My issue is these are working in a Postback condition. Can I use an UpdatePanel dynamically so that the User doesn't get an impression that the page is actually posting back. Any idea how to create the Update panels dynamically so as to include both the dropdownlists and populate without a postback? Thanks for any help.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

N a v a n e e t h27-Jan-09 19:10

27-Jan-09 19:10

meeram395 wrote:
My issue is these are working in a Postback condition. Can I use an UpdatePanel dynamically so that the User doesn't get an impression that the page is actually posting back

How user is getting that page is posting back? A post-back and page refresh is not same. Are you saying your page is refreshing?

Not sure I got you correctly.

Smile | :)

Navaneeth

How to use google | Ask smart questions

meeram39527-Jan-09 19:58

27-Jan-09 19:58

Thank you for the immediate response. Sorry that I didn't mention clearly the issue.

Page is not refreshing. It is posting back, means when the User Selects a country from the CountryDropdownlist, the corresponding States are populated from sql database by passing the CountryId.

I made the AutoPostBack property of Country to True so that it posts back to the server when the index changed. Hope this is clear now.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

N a v a n e e t h27-Jan-09 20:38

27-Jan-09 20:38

Well, how can the second dropdown be filled without a post-back? AFAIK, you can't avoid page posting back. BTW, what is wrong by doing so and why are you trying to prevent it?

Navaneeth

How to use google | Ask smart questions

meeram39528-Jan-09 4:47

28-Jan-09 4:47

You are right. The second dropdown is filled with a post-back only. But while using the UpdatePanel, the user will not get the feeling that the page is actually posting back. This will help him to enter the data in other controls and need not wait for the page to be reloaded.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

N a v a n e e t h27-Jan-09 20:47

27-Jan-09 20:47

If updatepanel is used only for filling the dropdowns without page refresh, why don't you try Cascading Dropdown[^]?

Navaneeth

How to use google | Ask smart questions

Rajdev Ramasamy27-Jan-09 20:11

Rajdev Ramasamy

27-Jan-09 20:11

We can add update panels dynamically. Please refer the following code sample(working):

Note: This is a Sample code

Aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DynamicUpdatePanel.aspx.cs" Inherits="DynamicUpdatePanel" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Dynamic Update Panel</title>
</head>
<body>
    <form id="frmDynamicUpdatePanel" runat="server">    
    <asp:ScriptManager ID="pageScriptManager" runat="server"></asp:ScriptManager>
  <asp:Panel ID="panelControls" runat="server">
  </asp:Panel>
    </form>
</body>
</html>

.CS

using System;
using System.Collections;
using System.Configuration;
using System.Data;
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;

public partial class DynamicUpdatePanel : System.Web.UI.Page
{
    DataTable dtCountry;
    DataTable dtState;

    protected void Page_Load(object sender, EventArgs e)
    {
        PopulateData();
        CreateControls();
    }

    protected void CreateControls()
    {
        UpdatePanel updatePanel = new UpdatePanel();
                
        DropDownList ddlCountry = new DropDownList();
        ddlCountry.ID = "ddlCountry";
        ddlCountry.Items.Add(new ListItem("-Select-", "-1"));
        ddlCountry.DataSource = dtCountry;
        ddlCountry.DataValueField = "CountryID";
        ddlCountry.DataTextField = "CountryName";
        ddlCountry.DataBind();
        ddlCountry.SelectedIndexChanged += ddlCountry_SelectedIndexChanged;
        ddlCountry.Items.Insert(0, new ListItem("-Select-", "-1"));
        ddlCountry.AutoPostBack = true;

        DropDownList ddlState = new DropDownList();
        ddlState.ID = "ddlState";
        ddlState.Items.Insert(0, new ListItem("-Select-", "-1"));
        
        updatePanel.ContentTemplateContainer.Controls.AddAt(0, ddlCountry);
        updatePanel.ContentTemplateContainer.Controls.AddAt(1, ddlState);

        panelControls.Controls.Add(updatePanel);

    }

    protected void PopulateData()
    {
        dtCountry = new DataTable();
        DataColumn dc;

        dc = new DataColumn("CountryID");
        dtCountry.Columns.Add(dc);

        dc = new DataColumn("CountryName");
        dtCountry.Columns.Add(dc);

        dtState = new DataTable();

        dc = new DataColumn("CountryID");
        dtState.Columns.Add(dc);

        dc = new DataColumn("StateID");
        dtState.Columns.Add(dc);

        dc = new DataColumn("StateName");
        dtState.Columns.Add(dc);

        DataRow dr;

        dr = dtCountry.NewRow();
        dr["CountryID"] = "1";
        dr["CountryName"] = "India";
        dtCountry.Rows.Add(dr);

        dr = dtCountry.NewRow();
        dr["CountryID"] = "2";
        dr["CountryName"] = "USA";
        dtCountry.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "1";
        dr["StateID"] = "1";
        dr["StateName"] = "Delhi";
        dtState.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "1";
        dr["StateID"] = "2";
        dr["StateName"] = "UP";
        dtState.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "1";
        dr["StateID"] = "3";
        dr["StateName"] = "AP";
        dtState.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "1";
        dr["StateID"] = "4";
        dr["StateName"] = "MP";
        dtState.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "1";
        dr["StateID"] = "5";
        dr["StateName"] = "Orissa";
        dtState.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "2";
        dr["StateID"] = "6";
        dr["StateName"] = "Alabama";
        dtState.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "2";
        dr["StateID"] = "7";
        dr["StateName"] = "Alaska";
        dtState.Rows.Add(dr);

        dr = dtState.NewRow();
        dr["CountryID"] = "2";
        dr["StateID"] = "8";
        dr["StateName"] = "Arizona";
        dtState.Rows.Add(dr);
        
    }

    protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddlCountry = (DropDownList)sender;
        DropDownList ddlState = (DropDownList)panelControls.FindControl("ddlState");
        ddlState.Items.Clear();
        ddlState.Items.Add(new ListItem("-Select-", "-1"));
        
        if(ddlCountry.SelectedValue != "-1")
        {
            DataRow[] drCollection;
            drCollection = dtState.Select("CountryID = " + ddlCountry.SelectedValue);            
            foreach (DataRow dr in drCollection)
            {
                ddlState.Items.Add(new ListItem(dr["StateName"].ToString(), dr["StateID"].ToString()));
            }         
        }
    }
}

Please revert back on any doubts.

Thanks,
Rajdev KR

meeram39528-Jan-09 21:35