Hell All actually we want to make my website fast and i use repeater jquery ajax for get data using store procedure now we want to implement paging concept in this code but still remember our speed will not effect because we want ot fast website - ASP.NET Discussion Boards

VB

If FileUploadToServer.HasFile Then
    ' Existing code
Else
    SaveFileInfo ("", 0, "")
End If

Thank you F-ES Stitecore.

Your solution worked for me.

It's very easy. Don't make it required. It's your code. Just pass a blank value for apFileName when there is no file. I guess I don't see where you are stuck.

There are only 10 types of people in the world, those who understand binary and those who don't.

Want to build an ecommerce site exactly like the one listed:
www.roadtrafficsigns.com

It's a javascript site using asp with aspx webages. I can look at some of the source code and understand a little bit, but I'm really at a lost of where to begin. I especially want to learn how the custom entering text fields are working with the image display. Any help is appreciated.

You are unlikely to learn this by posting questions here. Google will find you many articles on the subject which you should read for yourself.

If you want to build an ecommerce site then get a book on asp.net and start learning. If you encounter any specific questions regarding specific problems then feel free to post about them. Also if I was you I'd pick a better site to reproduce.

Member 12055876 wrote:
I especially want to learn how the custom entering text fields are working with the image display.

What custom entering text fields? What does that mean?

There are only 10 types of people in the world, those who understand binary and those who don't.

actually we want to make my website fast and i use repeater jquery, ajax for get data using store procedure now we want to implement paging concept in this code but still remember our speed will not effect because we want fast website
my code is
CS.aspx

XML

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

<!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></title>
    <style type="text/css">
        body
        {
            font-family: Arial;
            font-size: 10pt;
        }
        table
        {
            border: 1px solid #ccc;
            border-collapse: collapse;
            background-color: #fff;
            width:200px;
        }
        table th
        {
            background-color: #B8DBFD;
            color: #333;
            font-weight: bold;
        }
        table th, table td
        {
            padding: 5px;
            border: 1px solid #ccc;
        }
        table, table table td
        {
            border: 0px solid #ccc;
        }
    </style>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $.ajax({
                type: "POST",
                url: "CS.aspx/GetCustomers",
                data: '{}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: OnSuccess,
                failure: function (response) {
                    alert(response.d);
                },
                error: function (response) {
                    alert(response.d);
                }
            });
        });

        function OnSuccess(response) {
            var xmlDoc = $.parseXML(response.d);
            var xml = $(xmlDoc);
            var customers = xml.find("Table");
            var table = $("#dvCustomers table").eq(0).clone(true);
            $("#dvCustomers table").eq(0).remove();
            customers.each(function () {
                var customer = $(this);
                $(".name", table).html(customer.find("compid").text());
                $(".city", table).html(customer.find("Compdate").text());
                $(".postal", table).html(customer.find("name").text());
                $(".country", table).html(customer.find("phone").text());
                $(".phone", table).html(customer.find("subdepartnm").text());
                $(".fax", table).html(customer.find("block").text());
                $("#dvCustomers").append(table).append("<br />");
                table = $("#dvCustomers table").eq(0).clone(true);
            });
        }
    </script>

</head>
<body style="font-family: Arial; font-size: 10pt">
    <form id="form1" runat="server">
    <div id="dvCustomers">
        <asp:Repeater ID="rptCustomers" runat="server">
            <ItemTemplate>
                <table class="tblCustomer" cellpadding="2" cellspacing="0" border="1">
                   <tr>
                        <th>
                            <b><u><span class="name">
                                <%# Eval("compid")%></span></u></b>
                        </th>
                    </tr>
                    <tr>
                        <td>
                            <b>Complain Date: </b><span class="city"><%# Eval("Compdate")%></span><br />
                            <b>Name: </b><span class="postal"><%# Eval("name")%></span><br />
                            <b>Phone: </b><span class="country"><%# Eval("phone")%></span><br />
                            <b>Department: </b><span class="phone"><%# Eval("subdepartnm")%></span><br />
                            <b>Block: </b><span class="fax"><%# Eval("block")%></span><br />
                        </td>
                    </tr>
                </table>
            </ItemTemplate>
        </asp:Repeater>
    </div>
    </form>
</body>
</html

>

CS.aspx.cs code
using System;
using System.Collections.Generic;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Services;

public partial class CS : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.BindDummyItem();
}
}

private void BindDummyItem()
{
DataTable dummy = new DataTable();
dummy.Columns.Add("compid");
dummy.Columns.Add("Compdate");
dummy.Columns.Add("name");
dummy.Columns.Add("phone");
dummy.Columns.Add("subdepartnm");
dummy.Columns.Add("block");
//dummy.Columns.Add("Fax");
dummy.Rows.Add();
rptCustomers.DataSource = dummy;
rptCustomers.DataBind();
}

[WebMethod]
public static string GetCustomers()
{
DataTable dt = new DataTable();
SqlCommand cmd = null;
SqlDataAdapter adp = null;
string constr = ConfigurationManager.ConnectionStrings["SERVERNAME"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
//string constr = ConfigurationManager.ConnectionStrings["SERVERNAME"].ConnectionString;
cmd = new SqlCommand("sp_Closed", con);
cmd.Parameters.Add("@OfficerId", SqlDbType.BigInt).Value = 1344;
cmd.CommandType = CommandType.StoredProcedure;
//adp = new SqlDataAdapter(cmd);
//adp.Fill(dt);
//rptCustomers.DataSource = dt;
//rptCustomers.DataBind();
//string query = "SELECT TOP 10 * FROM Customers";
//SqlCommand cmd = new SqlCommand(query);
return GetData(cmd).GetXml();
}

private static DataSet GetData(SqlCommand cmd)
{
string constr = ConfigurationManager.ConnectionStrings["SERVERNAME"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
return ds;
}
}
}
}
}

What exactly are you asking us to do?

There are only 10 types of people in the world, those who understand binary and those who don't.

I have done all process of making asp.net app over wan...did port farwarding,provided inbound rules to port 80 and got public ip address...but when am accessing my application in wan ....its showing web page is not avaialble...m struggeling to fix it for last some days..but dint get succeeded ....please help me with this issue.
Thanks

How many times are you planning on reposting the same question?

Rather than annoying the people who are trying to help you by deleting and reposting the same question over and over again, try responding to the answers you've been given previously.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

the question that i posted is not same as i posted earlier ...its an issue which m getting ...please help me solving it...n i am sorry if its annoying ...but this time the question is different though subject is same .

Member 11919722 wrote:
please help me solving it.

Solving what? You've not provided any details. You've told us you can't access your application, but you've given us absolutely nothing to work with.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

let me explain you ....actually i m accessing my asp.net we app over wan ...for which i have used a public ip address i.e public ip address/host machinne ip adddress/directory/xyz.aspx ....this way i have typed in the browser ..in remotely located computer...but m getting the follwing error..
This webpage is not available

ERR_CONNECTION_TIMED_OUT

whats wrong m doing here. please let me know

You clearly haven't set up your router / firewall properly. That's not something we can talk you through fixing; you'll need to talk to your network administrator to get things set up correctly.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

I am building a system in asp.net C# with an Sql Server DB.
I have split the work into separate tasks.
I have put a timeline of around 41 days. The requirements are as below.
Can anyone say how long it would take and if my timeline is too long?

1. Requirements Gathering and Associated Documentation - Requirements Specification/Functional Specification and Agreement with Stakeholder(s)/Users - 4 days

2 Create DB and Tables and 4 tables - 4 days
3 Create Login Form - 2 days
4 Create Menu - 2 days

5 Create Initial Input Form - containing all the fields that need to be recorded inititally and the 2 calculated fields - 5 days

6 Create “Update Single File” form - Allow user to update this file and write it back to the table in the DB - 3 days

7 Create “Update Multiple Files” form - Display multiple files maybe based criteria selected from dropdown and allow user to possibly do a bulk update of the records - 4 days

8 Create “Add Staff” form and have it writing to the Staff table - 2 days

9 Create “LogOut” form - 1 day

10 Create “Reports”. This would involve creating reports that would have the Grouping of the data in the various different scenarios e.g. Total for Invoice, Total for Trans Number. A report for Audit trail may be needed also. These reports may need to be created in SSRS reporting. - 5 days

11 Audit Trail - Create a record in the audit table each time a record has been updated. Maybe display this audit trail in the “Update Single File” form - 3 days

12 Create Stored Procedures in DB to carry out the above functions - 3 days

13 Carry out functional reviews with Stakeholder(s)/Users - 1 day

14 Carry out Unit testing - 1 day

15 UAT with Stakeholder(s)/Users and Sign Off of System - 1 day

It sounds rather high to me, but it's an estimate of how long it will take you to do the work, so it depends on how quickly you think you can do it.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

If you have to write it from scratch, it may take that long for you to do it.
If you already had all the planning done, and you just had to code it, it could be 1/2 the time.

But the 80/20 rule still exists.

You spend 20% of your time writing the code, and 80% fixing things you never thought a user could do, unless of course you already have that experience. Writing and testing RegEx to validate input could consume all your quoted times.

I think a login page should not me more than 4 hours including the database table, cookies, and hashing using PWDTK, or whatever its called. And a logout page more than 2 hours.

Reports are time consuming, they take me about 3 days depending on the complexity, and if it's a HTML or Report Writer report.

When I quote jobs out, I quote the time to write the job 50%, and the time to test the job, make corrections, test validation, speed test, code analysis, user experience, 30%, and then artwork for buttons, icons, 20%. And then I add 20% more hours as a safety cap.

I do quote jobs in units of days, then break it down into hours.

I'll give you some tips that I have learned over the last 12 years.
Don't write the project for Microsoft SQL Server, use Entity Framework instead

I would just write SQL Linq for database functions, and not write out TSQL.

Just start out with BootStrap.css, and create a responsive design. Even if your using webforms and not MVC. With webforms, you can make a DLL for Entity Frameworks, or stick it in App_Code.

Write your HTML for Forms, such as textboxes as

<div class="form-group">
  <label>Enter user name:</label>
  <input class="form-control" />
</div>

and use the bootstrap.css to toggle form errors.

I know I'm going to get negative feedback on my suggestions here, but I should of implemented the practice years ago, and I regret not doing it. That SQL Linq is so slick, it's amazing what you can do with it. And the bootstrap.css allows you to just drop in any theme you want, plus it looks cool.

Thanks for your reply jkirkerk it was very helpful

Hi, I want to extract the name of customer, Invoice number, etc from an Invoice that would be a Pdf file.
Please help ASAP.
TIA

Refer to this article on how to extract text from a pdf file, Extract Text from PDF in C# (100% .NET)[^]

There are only 10 types of people in the world, those who understand binary and those who don't.

This extract whole document I just want to extract Invoice No.
For e.g If it is like: -
Invoice Number : INVC2563

It should extract only INVC2563.

The string INVC may Vary.

Praveen Kandari wrote:
This extract whole document I just want to extract Invoice No.

Yes, extract the text and then parse it to find what you need.

There are only 10 types of people in the world, those who understand binary and those who don't.

Does anyone know of any Rapid Development tool for Asp.net to build a database front-end with reporting in a few days.

Is Visual Studio LightSwitch any good?

Hi,

My company website is with ASP.NET 2.0 and one day the marketing guy ask me to unify domain.com to www.domain.com so that if visitors visit domain.com they will be redirected to www.domain.com and the status code must be 301 (301 Moved Permanently). He asks me to verify with http://www.redirect-checker.org/. In this site if we input domain.com and click Analyse button, if we have "Status: 301 Moved Permanently" then it's ok.

I tried with so many methods (using URL_Rewrite muldule with Canonical redirect, setup domain.com and redirect to www.domain.com, add <rewrite> rule to web.config file) and all of the methods work fine. However, I only have "Status: 301 Moved Permanently" for the first times access to the site. A second times when I access I see the site be redirected correctly to www.domain.com but the header is "HTTP/1.1 200 OK" but NOT "Status: 301 Moved Permanently" anymore.

Could you please help me how to always have "Status: 301 Moved Permanently"?

Thank you in advance