Re: Dataset or ado.net - ASP.NET Discussion Boards

First Prev Next

Re: Showing error message

RaviRanjanKr1-Nov-10 20:53

RaviRanjanKr

1-Nov-10 20:53

Brij wrote:
Better , if you find any exception , show in that page or redirect to some other error page

Ya i knew it, that's why i have already describe or refer a link about custom error which works as you say. Suspicious | :suss:

Re: Showing error message

Brij2-Nov-10 2:36

Brij

2-Nov-10 2:36

RaviRanjankr wrote:
Ya i knew it, that's why i have already describe or refer a link about custom error which works as you say

Obiously, you must be knowing. I just suggested , not to use JS alert.

Cheers!!
Brij
Visit my Blog: http://brijbhushan.net

Check my latest Article :ViewState - Various ways to reduce performance overhead

Re: Showing error message

RaviRanjanKr2-Nov-10 3:06

RaviRanjanKr

2-Nov-10 3:06

Brij wrote:
Obiously, you must be knowing. I just suggested , not to use JS alert.

whatever, thanks for your guidance or suggestion. Wink | ;)

cannot do add to cart function

setengah1-Nov-10 14:53

setengah

1-Nov-10 14:53

first, i'm sorry i'm newbie here and newbie in aspnet. i learn some code from ebook but it's not working. and i'm really sorry too because my english is bad.
when i debug my project its working fine, and i try to add item to my shopping cart its not show any error but the button do not work, its ike the product page only reload. i hope i can find the answer here.

thanks for help.

here the code

CartAccess.cs

using System;
using System.Web;
using System.Data;
using System.Data.Common;

/// <summary>
/// Supports Shopping Cart functionality
/// </summary>
public class CartAccess
{
    public CartAccess()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    // returns the shopping cart ID for the current user
    private static string shoppingCartId
    {
        get
        {
            HttpContext context = HttpContext.Current;
            string cartId;
            {
                // check if the cart ID exists as a cookie
                if (context.Request.Cookies["Delta_CartID"] != null)
                {
                    // return the id
                    //return context.Request.Cookies["Delta_CartID"].Value;
                    cartId = context.Request.Cookies["Delta_CartID"].Value;
                    return cartId;


                }
                else
                // if the cart ID doesn't exist in the cookie as well, generate a new ID
                {
                    // generate a new GUID
                    //Guid tempGuid = Guid.NewGuid();
                    //context.Response.Cookies["Delta_CartID"].Value = tempGuid.ToString();
                    cartId = Guid.NewGuid().ToString();
                    // create the cookie object and set its value
                    HttpCookie cookie = new HttpCookie("Delta_CartID", cartId);
                    // set the cookie's expiration
                    int howManyDays = deltaconfig.CartExpireDays;
                    DateTime currentDate = DateTime.Now;
                    TimeSpan timeSpan = new TimeSpan(howManyDays, 0, 0, 0);
                    DateTime expirationDate = currentDate.Add(timeSpan);
                    cookie.Expires = expirationDate;
                    // set the cookie on the client's browser
                    context.Response.Cookies.Add(cookie);
                    // return the CartID
                    return cartId.ToString();
                }
            }
        }
    }

    // Add a new shopping cart item
    public static bool AddItem(string bookId)
    {
        // get a configured DbCommand object
        DbCommand comm = DataAccess.CreateCommand();
        // set the stored procedure name
        comm.CommandText = "AddItem";
        // create a new parameter
        DbParameter param = comm.CreateParameter();
        param.ParameterName = "@CartID";
        param.Value = shoppingCartId;
        param.DbType = DbType.String;
        param.Size = 36;
        comm.Parameters.Add(param);
        // create a new parameter
        param = comm.CreateParameter();
        param.ParameterName = "@BookID";
        param.Value = bookId;
        param.DbType = DbType.Int32;
        comm.Parameters.Add(param);
        // returns true in case of success or false in case of an error
        try
        {
            // execute the stored procedure and return true if it executes
            // successfully, or false otherwise
            return (DataAccess.ExecuteNonQuery(comm) != -1);
        }
        catch
        {
            // prevent the exception from propagating, but return false to
            // signal the error
            return false;
        }
    }

    // Update the quantity of a shopping cart item
    public static bool UpdateItem(string bookId, int cquantity)
    {
        // get a configured DbCommand object
        DbCommand comm = DataAccess.CreateCommand();
        // set the stored procedure name
        comm.CommandText = "UpdateItem";
        // create a new parameter
        DbParameter param = comm.CreateParameter();
        param.ParameterName = "@CartID";
        param.Value = shoppingCartId;
        param.DbType = DbType.String;
        param.Size = 36;
        comm.Parameters.Add(param);
        // create a new parameter
        param = comm.CreateParameter();
        param.ParameterName = "@BookID";
        param.Value = bookId;
        param.DbType = DbType.Int32;
        comm.Parameters.Add(param);
        // create a new parameter
        param = comm.CreateParameter();
        param.ParameterName = "@CQuantity";
        param.Value = cquantity;
        param.DbType = DbType.Int32;
        comm.Parameters.Add(param);
        // returns true in case of success or false in case of an error
        try
        {
            // execute the stored procedure and return true if it executes
            // successfully, or false otherwise
            return (DataAccess.ExecuteNonQuery(comm) != -1);
        }
        catch
        {
            // prevent the exception from propagating, but return false to
            // signal the error
            return false;
        }
    }

    // Remove a shopping cart item
    public static bool RemoveItem(string bookId)
    {
        // get a configured DbCommand object
        DbCommand comm = DataAccess.CreateCommand();
        // set the stored procedure name
        comm.CommandText = "RemoveItem";
        // create a new parameter
        DbParameter param = comm.CreateParameter();
        param.ParameterName = "@CartID";
        param.Value = shoppingCartId;
        param.DbType = DbType.String;
        param.Size = 36;
        comm.Parameters.Add(param);
        // create a new parameter
        param = comm.CreateParameter();
        param.ParameterName = "@BookID";
        param.Value = bookId;
        param.DbType = DbType.Int32;
        comm.Parameters.Add(param);
        // returns true in case of success or false in case of an error
        try
        {

            // execute the stored procedure and return true if it executes
            // successfully, or false otherwise
            return (DataAccess.ExecuteNonQuery(comm) != -1);
        }
        catch
        {
            // prevent the exception from propagating, but return false to
            // signal the error
            return false;
        }
    }

    // Retrieve shopping cart items
    public static DataTable GetItem()
    {
        // get a configured DbCommand object
        DbCommand comm = DataAccess.CreateCommand();
        // set the stored procedure name
        comm.CommandText = "GetItem";
        // create a new parameter
        DbParameter param = comm.CreateParameter();
        param.ParameterName = "@CartID";
        param.Value = shoppingCartId;
        param.DbType = DbType.String;
        param.Size = 36;
        comm.Parameters.Add(param);
        // return the result table
        DataTable table = DataAccess.ExecuteSelectCommand(comm);
        return table;
    }

    // Retrieve shopping cart items
    public static decimal GetTotalAmount()
    {
        // get a configured DbCommand object
        DbCommand comm = DataAccess.CreateCommand();
        // set the stored procedure name
        comm.CommandText = "GetTotalAmount";
        // create a new parameter
        DbParameter param = comm.CreateParameter();
        param.ParameterName = "@CartID";
        param.Value = shoppingCartId;
        param.DbType = DbType.String;
        param.Size = 36;
        comm.Parameters.Add(param);
        // return the result table
        return Decimal.Parse(DataAccess.ExecuteScalar(comm));
    }

    // Counts old shopping carts
    public static int CountOldCarts(byte days)
    {
        // get a configured DbCommand object
        DbCommand comm = DataAccess.CreateCommand();
        // set the stored procedure name
        comm.CommandText = "CountOldCarts";
        // create a new parameter
        DbParameter param = comm.CreateParameter();
        param.ParameterName = "@Days";
        param.Value = days;
        param.DbType = DbType.Byte;
        comm.Parameters.Add(param);

        // execute the procedure and return number of old shopping carts
        try
        {
            return Byte.Parse(DataAccess.ExecuteScalar(comm));
        }
        catch
        {
            return -1;
        }
    }

    // Deletes old shopping carts
    public static bool DeleteOldCarts(byte days)
    {
        // get a configured DbCommand object
        DbCommand comm = DataAccess.CreateCommand();
        // set the stored procedure name
        comm.CommandText = "DeleteOldCarts";
        // create a new parameter
        DbParameter param = comm.CreateParameter();
        param.ParameterName = "@Days";
        param.Value = days;
        param.DbType = DbType.Byte;
        comm.Parameters.Add(param);
        // execute the procedure and return true if no problem occurs
        try
        {
            DataAccess.ExecuteNonQuery(comm);
            return true;
        }
        catch
        {
            return false;
        }
    }

}

ShoppingCart.aspx.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 ShoppingCart : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Populate();
        }
    }
    // fill shopping cart controls with data
    private void Populate()
    {
        // get the items in the shopping cart
        DataTable dt = CartAccess.GetItem();
        // if the shopping cart is empty...
        if (dt.Rows.Count == 0)
        {
            gridview.Visible = true;
            Updatebtn.Enabled = false;
            TotalAmount.Text = String.Format("{0:c}", 0);
        }
        else
        // if the shopping cart is not empty...
        {
            // populate the list with the shopping cart contents
            gridview.DataSource = dt;
            gridview.DataBind();
            gridview.Visible = true;
            Updatebtn.Enabled = true;
            // display the total amount
            decimal amount = CartAccess.GetTotalAmount();
            TotalAmount.Text = String.Format("{0:c}", amount);
        }
    }
    protected void continuebtn_Click(object sender, EventArgs e)
    {
        Response.Redirect("/");
    }
}

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 Product : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
            // Retrieve BookID from the query string
            string bookId = Request.QueryString["BookID"];
            // Retrieves product details
            BookDetails bd = CatalogAccess.GetBookDetails(bookId);
            // Does the product exist?
            if (bd.Name != null)
            {
                Populate(bd);
            }
            else
            {
                Server.Transfer("ProductNotfound.aspx");
            }
    }
    // Fill the control with data
    private void Populate(BookDetails bd)
    {
        
        // Display product details
        titleLabel.Text = bd.Name;
        descriptionLabel.Text = bd.Description;
        stockLabel.Text = Convert.ToString(bd.Quantity);
        priceLabel.Text = String.Format("{0:c}", bd.Price);
        authorLabel.Text = bd.Author;
        productImage.ImageUrl = "BookImage/" + bd.Image;
        // Set the title of the page
        this.Title = deltaconfig.SiteName + bd.Name;
    }
    protected void AddToCartButton_Click(object sender, EventArgs e)
    {
        // Retrieve ProductID from the query string
        string bookId = Request.QueryString["BookID"];

        CartAccess.AddItem(bookId);
    }
}

and thanks again

Re: cannot do add to cart function

T M Gray2-Nov-10 4:33

T M Gray

2-Nov-10 4:33

Having all of the methods of the cart as static is a bad idea. You are also throwing away the return values. If CartAccess.AddItem returns a bool you should be doing something with it. It could be as simple as setting the text of a label with "added to cart" or "oops something bad happened". I am guessing you would be getting a false and that it has something to do with your database connection. To get detailed info about what went wrong, either remove the try/catch around the DataAccess calls, or in the catch, change it to catch(Exception ex) and set a label with ex.Message.

Your English is not bad at all.

Re: cannot do add to cart function

Fayu9-Nov-10 4:44

Fayu

9-Nov-10 4:44

5 for you because of your etiquette and good manners!!!

Dataset or ado.net

future38391-Nov-10 3:35

future3839

1-Nov-10 3:35

Hi,
Just wondering to know, between ADO.net and Dataset which one is better for working with database.
Could you please give me a link for beginner?

thanks a lot

Re: Dataset or ado.net

Not Active1-Nov-10 4:38

Not Active

1-Nov-10 4:38

You are trying to compare apples to oranges.

ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data.
http://msdn.microsoft.com/en-us/library/h43ks021(VS.71).aspx[^]

The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET.
http://msdn.microsoft.com/en-us/library/zb0sdh0b(v=VS.71).aspx[^]

I know the language. I've read a book. - _Madmatt

help with url rewrite...

swornavidhya_m31-Oct-10 23:09

swornavidhya_m

31-Oct-10 23:09

I have to do an module program which downloads pdf files in the client side. Currently, when users download the file, the url of the downloaded file is viewed by the user.

Modification instructed:
1. In the page where the file download is requested, the url of the downloaded file is viewed in the status bar of that web page. Modification is that the status bar should not display the url of the downloaded file. -- This had been corrected and the code has modified accordingly. It is done correctly only for the first page. Blinks how to process this for the second page..

2. Currently, the call for the download page is given along with the filename of the user request. The filename is passed as the querystring. Modification needed is that the url should get rewritten as "~/download.aspx" instead of "~/download.aspx?<filename>".

I came across using "urlrewriter". But don't know how to implement since i feel little confused with the code examples in net.

I'm placing my code for ur assistance. I'm not using webconfig file also.
old try pdf.aspx
****************

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="old try pdf.aspx.cs" Inherits="old_try_pdf" %>

<!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>Try PDF - Download</title>
    <style>
        .link_text
        {
	        font-family:Tahoma;
	        font-size:10px;
	        color:#1d5296;
	        text-decoration:none;
        }

        .link_text A
        {
	        font-family:Tahoma;
	        font-size:11px;
	        color:#1d5296;
	        text-decoration:underline;	
        }

        .link_text A:hover
        {
	        color:#ff000c;
	        text-decoration:underline;
        }

        .link_text A:active
        {
	        color:#ff000c;
	        text-decoration:underline;
        }
        
        .bullets
        {
	        background-image:url(Bullet.gif);	
	        background-position:center;
	        width:10px;
	        height:10px;
	        display:table-cell;		
	        vertical-align:top;
	        background-repeat:no-repeat;
        }
        
        .display_cell
        {
	        border:solid 1px #e6e7e8;
	        display:table-cell;
	        width:355px;
        }

    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <table>
                <tr>
                    <td class='display_cell'>
                        <asp:Panel runat=server ID="pnl_pdf"></asp:Panel>
                    </td>
                </tr>
            </table>
            
        </div>
    </form>
</body>
</html>

old try pdf.aspx.cs
*******************

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;

public partial class old_try_pdf : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Table tb_currency = new Table();
        tb_currency.Width = 355;
        TableRow tr_currency = new TableRow();
        TableCell tc_currency = new TableCell();
        Image img_currency = new Image();
        HyperLink hlk = new HyperLink();

        foreach (string fnames in Directory.GetFiles(@"~\Link 2 Download\pdf"))
        {
            string fname = null;

            tr_currency = new TableRow();

            tc_currency = new TableCell();
            tc_currency.CssClass = "bullets";
            tr_currency.Cells.Add(tc_currency);

            tc_currency = new TableCell();
            tc_currency.HorizontalAlign = HorizontalAlign.Left;
            tc_currency.CssClass = "link_text";
            hlk = new HyperLink();
            hlk.Target = "_blank";

            fname = Path.GetFileNameWithoutExtension(fnames);

            hlk.Text = fname;
            hlk.Attributes.Add("onMouseOver", "javascript:window.status=''; return true;");
            hlk.Attributes.Add("onMouseOut", "javascript:window.status=''; return true;");
            hlk.Attributes.Add("onClick", "javascript:window.status=''; return true;");
            hlk.NavigateUrl = "~/Old download_pdf.aspx?fn=" + fname;
            tc_currency.Controls.Add(hlk);
            tr_currency.Cells.Add(tc_currency);

            tb_currency.Rows.Add(tr_currency);
        }

        pnl_pdf.Controls.Clear();
        pnl_pdf.Controls.Add(tb_currency);

    }
}

Old download_pdf.aspx
*********************

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

<!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>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>

Old download_pdf.aspx.cs
************************

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Net;
using System.IO;


public partial class Old_download_pdf : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // Create a message string
        string strMessage = "Wait.... File is downloading....";
        // Register startup script to show a message in status bar
        this.RegisterStartupScript("SetStatusText", "<script>window.status='" + strMessage + "';</script>");

        if (Request.QueryString.Count > 0)
        {
            string fn = Request.QueryString.Get(0).ToString();

            string spath = @"~\pdf\" + fn + ".pdf";
            Response.ClearContent(); 
            Response.ClearHeaders();
            Response.ContentType = "application/pdf";
            //Response.ContentType = "application/octet-stream";
            Response.AddHeader("Content-Disposition", "attachment; filename=my_test.pdf");
           
            Response.TransmitFile(spath);
            Response.End();
        }       

    }
}

Even using register startup variable, in Old_download_pdf.aspx, it is showing the downloaded file url path in status bar of the page Old_download_pdf.aspx. Also we have to rewrite the url from "~/Old download_pdf.aspx?fn=<filename>" as simply "~/Old download_pdf.aspx".

When i tried using a hidden variable, i failed in setting the value of the hidden field during the click event of the dynamically creating hyperlink control.

How to complete this? Thanks in advance.

Regards,
M.Sworna Vidhya

Ajax with VS 2005

AndieDu31-Oct-10 20:51

AndieDu

31-Oct-10 20:51

Hi All,

I just come across a pretty weird behaviour on my VS 2005 and Ajax, basically i am having a master page and a content page. This is the front end html code for the master page:

<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="MasterPage.master.cs" Inherits="WebApplication3.MasterPage" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI" TagPrefix="asp" %>


<!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>Test Page</title>
    <link href="Stylesheet1.css" rel="stylesheet" type="text/css" /> 
</head>
<body>
    <form id="form1" runat="server">
    
    <asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
    </asp:ContentPlaceHolder>
    <div>    
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> 
        <%--<cc:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"></cc:ToolkitScriptManager> --%>
        <cc:Accordion ID="Accordion1" runat="server" FadeTransitions="true" SelectedIndex="0" 
                HeaderCssClass="accordionHeader" ContentCssClass="accordionContent">
                    <Panes>
                        <cc:AccordionPane ID="AccordionPane1" runat="server">
                            <Header>Test Pane 1</Header> 
                            <Content>Test pane 1</Content>
                        </cc:AccordionPane> 
                        <cc:AccordionPane ID="AccordionPane2" runat="server">
                            <Header>Test Pane 2</Header> 
                            <Content>Test pane 2</Content>
                        </cc:AccordionPane>
                        <cc:AccordionPane ID="AccordionPane3" runat="server">
                            <Header>Test Pane 3</Header> 
                            <Content>Test pane 3</Content>
                        </cc:AccordionPane>
                    </Panes>
        </cc:Accordion>
    </div>
    </form>
</body>
</html>

and this is the front end html code for the content page:

<%@ Page Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication3.Default" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> 
test
</asp:Content>

but when i try to run it, it always gives me this bloody error:Server Error in '/' Application.
--------------------------------------------------------------------------------

The control with ID 'Accordion1_AccordionExtender' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The control with ID 'Accordion1_AccordionExtender' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.
I even dont have this control 'Accordion1_AccordionExtender' on my page, so i dont know what is complaining for.

But when i put the same code in vs 2008, and i use

<cc:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"></cc:ToolkitScriptManager>

instead of

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

it just worked like a charm, i was searching on the internet, quite a few ppl got the same issue, but no one has a resonable answer about it. My AjaxControlToolkit.dll was released at 12/05/2010 and AJAXExtensionsToolbox.dll was released at 13/12/2006. Can someone in here plz shed me a light what could be the issue?Many thanks.

Hyper Link in datagrid to download a file

<<Tash18>>31-Oct-10 20:38

<<Tash18>>

31-Oct-10 20:38

Hi guys,

Im working on asp.net1.1 web application on C#. actually i have a page in which the user fills up certain details and also have an option to upload a file which is mandatory. Now at the database along with the details entered by the user the file location path also gets saved in the database say for example D:\webapp\Hello\Modules\Agreement\01-11-2010 08-43-50AMimage.gif -- dis is what gets stored in the DB. Now after the user has clicked the submit button the data is inserted and i also have a datagrid in the same page on which the data stored in database gets populated, currently the path of the file is displayed on the datagrid as mentioned above. but what my requirement is i want the path to be displayed as a hyperlink so dat on clicking the link the file gets downloaded.. trhe code is as follows

the following code is on page display.aspx.cs

private void BindAgreement()
{
    string Module = Request.QueryString["servId"];
    DataSet dReasons  = DataAccess.ExecuteStoredProcedure(Session["MosaicConn"].ToString(),"asp_app_get_mainagreement "+Module);
    if(dReasons.Tables.Count > 0)
    {
        if(dReasons.Tables[0].Rows.Count > 0)
        {
            DataTable dtDisplay = new DataTable();
            dtDisplay.Columns.Add(new DataColumn("row_id",typeof(string)));
            dtDisplay.Columns.Add(new DataColumn("module_id",typeof(string)));
            dtDisplay.Columns.Add(new DataColumn("total_value",typeof(string)));
            dtDisplay.Columns.Add(new DataColumn("amc_start_dt",typeof(string)));
            dtDisplay.Columns.Add(new DataColumn("license_amt",typeof(string)));
            dtDisplay.Columns.Add(new DataColumn("implement_amt",typeof(string)));
            dtDisplay.Columns.Add(new DataColumn("number_of_licenses",typeof(string)));
            dtDisplay.Columns.Add(new DataColumn("agree_file_name",typeof(string)));

            for(int i = 0; i < dReasons.Tables[0].Rows.Count; i++)
            {
                DataRow drDisplay;
                drDisplay = dtDisplay.NewRow();
                drDisplay[0] = dReasons.Tables[0].Rows[i].ItemArray[0];
                drDisplay[1] = dReasons.Tables[0].Rows[i].ItemArray[1];
                drDisplay[2] = dReasons.Tables[0].Rows[i].ItemArray[2];
                drDisplay[3] = dReasons.Tables[0].Rows[i].ItemArray[3];
                drDisplay[4] = dReasons.Tables[0].Rows[i].ItemArray[4];
                drDisplay[5] = dReasons.Tables[0].Rows[i].ItemArray[5];
                drDisplay[6] = dReasons.Tables[0].Rows[i].ItemArray[6];
                drDisplay[7] = dReasons.Tables[0].Rows[i].ItemArray[7];
                dtDisplay.Rows.Add(drDisplay);
            }
            lblMessage.Visible = false;
            rptUsers.DataSource = dtDisplay;
            rptUsers.DataBind();
        }

the following code is the code for the datagrid on display.aspx page

<table style="BORDER-COLLAPSE: collapse" borderColor="#006699" width="100%" border="1">
								<tr>
									<td bgColor="background" colSpan="6"><FONT face="Arial" color="#ffffff" size="2"><STRONG>&nbsp;Available 
												Agreements</STRONG></FONT></td>
								</tr>
								<TR bgColor="background">
									<td style="WIDTH: 38px"><FONT face="Verdana" color="#ffffff" size="1"><b>&nbsp;Total Value</b></FONT></td>
									<td style="WIDTH: 66px"><FONT face="Verdana" color="#ffffff" size="1"><b>&nbsp;AMC Start 
												Date</b></FONT></td>
									<td style="WIDTH: 50px"><FONT face="Verdana" color="#ffffff" size="1"><b>&nbsp;License 
												Amount</b></FONT></td>
									<td style="WIDTH: 95px"><FONT face="Verdana" color="#ffffff" size="1"><b>&nbsp;Implementation 
												Amount</b></FONT></td>
									<td><FONT face="Verdana" color="#ffffff" size="1"><b>&nbsp;Number of licenses</b></FONT></td>
									<td><FONT face="Verdana" color="#ffffff" size="1"><b>&nbsp;File Name</b></FONT></td>
								</TR>
								<asp:repeater id="rptUsers" runat="server">
									<ItemTemplate>
										<TR bgColor="#dcd1ff">
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"total_value")%>&nbsp;&nbsp;</FONT><input runat=server type="hidden" id="row_id" name="row_id" value='<%# DataBinder.Eval(Container.DataItem,"row_id")%>'></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"amc_start_dt")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"license_amt")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"implement_amt")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"number_of_licenses")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"agree_file_name")%>&nbsp;&nbsp;</FONT></td>
										</TR>
									</ItemTemplate>
									<AlternatingItemTemplate>
										<TR bgColor="#d7dcff">
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"total_value")%>&nbsp;&nbsp;</FONT><input runat=server type="hidden" id="Hidden1" name="row_id" value='<%# DataBinder.Eval(Container.DataItem,"row_id")%>'></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"amc_start_dt")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"license_amt")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"implement_amt")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"number_of_licenses")%>&nbsp;&nbsp;</FONT></td>
											<td><FONT face="Verdana" size="1">&nbsp;<%# DataBinder.Eval(Container.DataItem,"agree_file_name")%>&nbsp;&nbsp;</FONT></td>
										</TR>
									</AlternatingItemTemplate>
								</asp:repeater></table>
							<br>
						</td></TD></tr>
				</table>

Thanx in advance,
Tash

Re: Hyper Link in datagrid to download a file

Not Active1-Nov-10 2:14

Not Active

1-Nov-10 2:14

Add a hyperlink rather than a label. What problems are you encountering? What don't you understand?

Also, you should not be using the FONT element. Use CSS.

I know the language. I've read a book. - _Madmatt

Re: Hyper Link in datagrid to download a file

<<Tash18>>1-Nov-10 19:00

<<Tash18>>

1-Nov-10 19:00

Hi thanks for your reply.
Actually i can display the path of the file in my page. since im using a repeater over here i wanna show the path of the file as a hyper link and when user clicks on the path the file should get downloaded.. im struggling at this point.. Any help is appreciated..

Thanx in advance,
Tash

Copy Multiple File on Client Machine

raushan_931-Oct-10 20:00

raushan_9

31-Oct-10 20:00

Hello,
i have multiple files on server. I want to Copy all files on Client Machine at once time.
Now i am just using this code
Response.Write("<script type=\"text/javascript\">window.open('download.aspx?f=" + path + "');</script>");
Its Save the file one by one on client machine and ask every time for save.
But i want to save all files at once save click, ya copy all files in Client Machine at once

Regards
Raushan Kumar

ASP.net VB

Xinxen31-Oct-10 19:50

Xinxen

31-Oct-10 19:50

hello all..
I want to ask for help..

about making simple chatting.. with filter word..

any suggest or turtorial maybe?
just simple chatting like facebook, maybe desktop not online..

thx b4..

best way to save news?

Jassim Rahma31-Oct-10 4:40

Jassim Rahma

31-Oct-10 4:40

if you go to BCC news website or any other website you'll see the usrl is referring to a file like this:

http://www.bbc.co.uk/news/world-middle-east-11661496

not to a database like this:

http://www.bbc.co.uk/news.aspx?id=9999999

so what's the best way to save news website? how do they do it? i don't think it's just physical files because maintaining it would be very very difficult..

can anyone explain to me please....

Re: best way to save news?

Brij31-Oct-10 4:53

Brij

31-Oct-10 4:53

jrahma wrote:
http://www.bbc.co.uk/news/world-middle-east-11661496

The above url that you are talking about, It is not the linked to the direct page. They must have used some routing mechanism or URL rewriting kind of thing. So user clicks the news link it is redirected to the appropriate page wit the help of mechanism implemented.

jrahma wrote:
so what's the best way to save news website? how do they do it? i don't think it's just physical files because maintaining it would be very very difficult..

I didn't get your question.
Do you want save the links of the news. So for a user point of view, both the links are same, whether the routed url or querystring one.

Cheers!!
Brij
Visit my Blog: http://brijbhushan.net

Check my latest Article :ViewState - Various ways to reduce performance overhead

losing the focud!!

Jassim Rahma31-Oct-10 4:36

Jassim Rahma

31-Oct-10 4:36

I have a timer which displays the current time within an asp:UpdatePanel This part is working fine..

I have another asp:UpdatePanel on the same page with two TextBoxs for login purpose.

The problem when the timer is running and I try to put the cursor in one of the two boxes in the UpdatePagel of the loging area it just stays there for seconds and then lose the focus! why is that?

these are the panels:

<dxt:ASPxTimer ID="timerClock" runat="server" Interval="1000" OnTick="timerClock_Tick" />
<asp:UpdatePanel runat="server" UpdateMode="Always">
<Triggers>
    <asp:AsyncPostBackTrigger ControlID="timerClock" />
</Triggers>
<ContentTemplate>
    <asp:Table runat="server" Width="120" BorderWidth="0" CellPadding="0" CellSpacing="0">
    <asp:TableRow>
        <asp:TableCell HorizontalAlign="Center" VerticalAlign="Middle"><dxe:ASPxImage ID="imageFlag" runat="server" ImageUrl="~/images/flags/ar-BH.gif" /></asp:TableCell>
        <asp:TableCell HorizontalAlign="Center" VerticalAlign="Middle" Width="100%"><dxe:ASPxLabel ID="lblCurrentTime" runat="server" Font-Bold="true" Text="Loading.." /></asp:TableCell>
    </asp:TableRow>
    </asp:Table>
</ContentTemplate>
</asp:UpdatePanel>

<asp:UpdatePanel runat="server">
<ContentTemplate>
    <asp:Table ID="Table1" runat="server" CellPadding="2" CellSpacing="2">
        <asp:TableRow><asp:TableCell>Email Address:</asp:TableCell></asp:TableRow>
        <asp:TableRow><asp:TableCell><dxe:ASPxTextBox ID="txtLoginEmail" runat="server" Width="160px" /></asp:TableCell></asp:TableRow>
        <asp:TableRow><asp:TableCell>Password:</asp:TableCell></asp:TableRow>
        <asp:TableRow><asp:TableCell><dxe:ASPxTextBox ID="txtLoginPassword" runat="server" Width="160px" /></asp:TableCell></asp:TableRow>
        <asp:TableRow><asp:TableCell HorizontalAlign="Center"><asp:Button ID="btnLogin" runat="server" Text="Login" Width="100px" /></asp:TableCell></asp:TableRow>
    </asp:Table>
</ContentTemplate>
</asp:UpdatePanel>

How do I integrate my asp.net website with other websites...(similar to Facebook Connect)?

Nada Adel31-Oct-10 1:45

Nada Adel

31-Oct-10 1:45

What is the easiest way to achieve that?
Do I have to create an API for my website?

Any references please send them.
Thanks

500-inernal server error .

Davood Riazi30-Oct-10 22:33

Davood Riazi

30-Oct-10 22:33

Hello

what does this error mean?

"500-inernal server error .
There is a problem with the resource you are looking for, and it cannot be displayed."

This project has been written with visual studio .net 2010 and the database is ms sql server 2008.

Every few times I am faced with this error.

Can anyone help me to solve this error ?

Thanks

Davood

D.riazi

Re: 500-inernal server error .

Keith Barrow31-Oct-10 4:37

Keith Barrow

31-Oct-10 4:37

The 500 message you posted is pretty much the server equivalent of "Exception", in that it means "something" has gone wrong the processing the request and the error is on the server side (as opposed to a bad call from the client). It could be one of 1000s of things, can you post a stack trace or log message as the error you supplied doesn't narrow things down very much.

Sort of a cross between Lawrence of Arabia and Dilbert.[^]

Re: 500-inernal server error .

Brij31-Oct-10 4:47

Brij

31-Oct-10 4:47

See, this error is returned from the web server. The Web server encountered an unexpected condition that prevented it from fulfilling the request by the client

This error itself doesn't describe about the error. You need to see the IIS logs to find more details about the error.

So see the logs which might help you to find the exact issue.

Cheers!!
Brij
Visit my Blog: http://brijbhushan.net

Check my latest Article :ViewState - Various ways to reduce performance overhead

print a mobile webpage

behzadcp30-Oct-10 19:28

behzadcp

30-Oct-10 19:28

hi
how to print a mobile web page that run at mobile device such as pda or smart phone?
thabks a lot

databse

sheemap30-Oct-10 8:26

sheemap

30-Oct-10 8:26

hiii to all
any one can tell step by step how to upload data base like Ms Access and Sql Server

rizvan sivally