Re: Problem in installing DotNetNuke - ASP.NET Discussion Boards

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

Re: Problem in installing DotNetNuke

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

N a v a n e e t h

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

Re: Problem in installing DotNetNuke

Piyush Vardhan Singh27-Jan-09 20:45

Piyush Vardhan Singh

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

Re: Problem in installing DotNetNuke

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

N a v a n e e t h

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

Re: Problem in installing DotNetNuke

Piyush Vardhan Singh27-Jan-09 20:50

Piyush Vardhan Singh

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

Re: Problem in installing DotNetNuke

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

Re: Problem in installing DotNetNuke

Piyush Vardhan Singh27-Jan-09 21:57

Piyush Vardhan Singh

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

Re: Problem in installing DotNetNuke

Piyush Vardhan Singh27-Jan-09 22:06

Piyush Vardhan Singh

27-Jan-09 22:06

i gated

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

Re: Problem in installing DotNetNuke

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

Tooltip on gridview, how to ?

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

meeram395

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.

Re: How to Add an UpdatePanel dynamically?

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

N a v a n e e t h

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

Re: How to Add an UpdatePanel dynamically?

meeram39527-Jan-09 19:58

meeram395

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.

Re: How to Add an UpdatePanel dynamically?

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

N a v a n e e t h

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

Re: How to Add an UpdatePanel dynamically?

meeram39528-Jan-09 4:47

meeram395

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.

Re: How to Add an UpdatePanel dynamically?

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

N a v a n e e t h

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

Re: How to Add an UpdatePanel dynamically?

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

Re: How to Add an UpdatePanel dynamically?

meeram39528-Jan-09 21:35

meeram395

28-Jan-09 21:35

Sorry for the late reply.

Thank you Rajdev. Code Works perfectly fine. Thanks a lot!!!

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

Sending Same Message to Multiple Users

sjs4u27-Jan-09 19:00

sjs4u

27-Jan-09 19:00

Hi,

I am sending message to multiple user. I am using forloop and using this for loop it takes the numbers one by one from the textfile and send the sms.

but it takes to much time for 10 numbers at a time.

Is it possible with Multithread or Webservices ? Or any other solution.

Thanks

sjs

Re: Sending Same Message to Multiple Users

Aman Bhullar27-Jan-09 19:03

Aman Bhullar

27-Jan-09 19:03