SQL Server :: Choose The Most Popular Venue?

Jan 21, 2011

i have to choose the most popular venueselect max(count(Destination))as popular_venu from bookingthis shows me error.how do i solve this?nothr queriesselect max(count(Departure_time)from bookingwhere Departure_time>12:00:00i got error for both.please help me to sovle

View 5 Replies


Similar Messages:

SQL Server :: Method To Choose Where To Place If Condition For Query

Jul 15, 2010

I have a table with 3 fields, catCode, startDate and endDate. I am having trouble deciding how to query my DB based on the following. By default a gridview will return all records that match the catCode selected from a dropdown list. If the user checks a check box, only records are returned where.

startDate <= today AND endDate >= today

How can I apply the If condition to compare when the check box is selected? I used the wizard to build the select statment for the gridview, but I can switch that to a SP if that makes life easier.

View 8 Replies

Forms Data Controls :: Datagrid With Column Choose To Choose Columns Dynamically Using DataGrid With Object Data Sour

Sep 30, 2010

I have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source

Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}

View 1 Replies

C# - What Is The Most Popular Website Written

Oct 31, 2010

I am trying to justify writing a website in asp.net that has the potential to be as large as wikipedia. Are there any large websites content driven websites that have been written asp.net?

View 1 Replies

Software For Tracking How Popular A Web Site?

Nov 2, 2010

Is there a (free!) software/components that I can use to track how my web site is being used - which pages are most popular, how many times was the site visitied today, yesterday etc...

View 3 Replies

Popular Languages For HTML Pages Generation?

Feb 1, 2010

Asp.net, php, jsp What other popular (used alot in production) languages for HTML pages generation are there?

View 4 Replies

E-commerce: Most Popular/most Bought Products List

Mar 9, 2010

Im Searching for a tutorual to make a list of the most bought products on my e-commerce site. (toplist)

View 2 Replies

Javascript - What Is The Best And Easiest-to-use Video Player For Popular Video Extension

Sep 6, 2010

What is the best and easiest-to-use video player for popular video extension in asp.net?

View 1 Replies

What Should I Choose Webforms Or Mvc

Apr 28, 2010

Possible Duplicates: Advice on using ASP.net WebForms or MVC, How to decide which is right, WebForms or MVC when doing ASP.NET

I am new to web development and asp.net... I was going through asp.net website and 'n' number of question here in stackoverflow regarding Webforms or MVC.... But still as a beginner can't get an idea what to choose?

What should i choose webforms or mvc?If MVC,What should i know before getting started with it?If webforms,What should i know before getting started with it?

View 4 Replies

What Programming Model To Choose

Dec 3, 2010

I'm a seasoned programmer with years of experience in Windows Forms development using different programming languages as already stated in this question: Will learning WPF improve my skills in ASP.NET? ASP.NET or any Web based programming language doesn't feel natural for me to explore or to use. Although I am unfamiliar with Web based technologies, my curiosity about these grows and grows. In addition to it, I am aware of the market place Web based programming takes. I would like to expand my knowledge and experience to the Web, though would it be just to know what I'm talking about instead of speculating whatever.

My experience as an information and process systems developer allows me to understand the concepts and some of the basics. I am aware that Web based applications are stateless, for instance, and that I need to use session or viewstate variables to keep the information the user is working with alive, otherwise I would loose them. I also understand the basics of Ajax based controls such as the UpdatePanel, which is to update or to refresh only a part of a UI page rather than reloading everything through the connection again. I can get that CSS defines styles for your page's sections and that you may change radically your Website's aspect just by changing the CSS reference. I am also aware of masterpages, which I don't really understand, in fact.

Programming Model
I just watched this video about choosing the right model for me/my application:
Choosing the Right Programming Model. If looks like ASP.NET MVC, which I thought was the best approach, is more for the veteran Web developers, people who are comfortable with Web applications. I have used a lot of DataBinding in Windows Forms, and WebForms seems to be more what I'm looking for into ASP.NET, until they say that MVC allows for Unit Testing, TDD and Agile methodologies, which I adhere to, as a certified Professional Scrum Master. I'm a bit mixed up on what will be more natural for me speaking of programming model.

Questions
Taking into account my base of knowledge and my experience, what programming model do you think I'm going to be more comfortable with? Will choosing one over the other allow me to get acquainted enough with ASP.NET to one day try the other model? In the video about choosing the Programming Model both sat on ASP.NET, I heard about DataBinding while using Web Forms, but no mention of DataBinding in the MVC model. Is there any possible DataBinding in MVC?

View 3 Replies

Database Already Exists Choose A Different Name?

Apr 1, 2010

Here's the case I created this Permias.mdf on another solution that I had and then after that I decided not to use that solution and created a new website from visual studio and copy and paste the .mdf file to be used for this website.

Database 'C:\Permias.mdf' already exists. Choose a different database name.

View 2 Replies

Which Design Pattern To Choose

Jul 20, 2010

I am using asp.net and c#.

I have a some classes. Some of the classes are having same methods insert, update and delete.

Each insert will insert different data to different table. (same for update and delete). What type of pattern can be applied for this kind of class.

View 3 Replies

Web Forms :: How To Add C# Page While Choose New Project In VB.net

Apr 3, 2010

i create a new web project there is two options to code 'C#' and 'VB.Net', I choose vb.net.....everything is working fine, now i want to add new webpage but in that page i want to write code in C# i know its possible because i did same job previously....but now the problem is when i go for add new item and choose web>webpage but there is single option to write source that is VB.net.....that is default setup when is choose new project.....

how to add C# page while choose new project in VB.net......

View 9 Replies

Which Technology To Choose When Integrating RFID

Sep 14, 2010

I have a RFID reader which reads my employee code. Now i want to log the date and time of the chip when it is scanned by the reader (ie) for an attendance system Login time and logoff time. I would like to use asp.net MVC and sql server 2005. how to integrate RFID with an asp.net mvc web application. Where should i start?

View 2 Replies

How To Choose A Country From That Drop Down List

May 15, 2010

I have a dropdown list in my page which can load country list from a SQL database table. Now, I want to choose a country from that drop down list and If I click on the go button, then I want another query which can compare the country name(which I have selected) with another table and load the other necessary info from that table. If I specify the country name on the SQL command , then the data loads nicely(

<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT [Zone_Name], [Card] FROM [Rates] WHERE ([Zone_Name] LIKE 'Canada%')">
[code]...

View 6 Replies

Choose Best Data Application Methodology?

May 12, 2010

LINQ to SQL

Entity Framework

MVC

We're rewriting a VB 6 windows application in C# for our intranet. Our organization has about 400 employees. Our database is SQL Server 2008. The application is a Human Resources Employee Administration System.

How does a group of newbies set out to choose the best approach to handling the data for this relatively small organization?

Any recommendations as which approach to try first or otherwise which one you consider the best approach and why?

View 7 Replies

Orm - Choose A Code Generation Tools?

May 20, 2010

I am new to the code generation tools and I would like to know how does a tool like LLBGen Pro compares with the Entity Framework? On top of that my boos is really looking into a tool called CodeOnTime http://codeontime.com/default.aspx because he likes their good UI support.I am asking here because I really want an unbiased opinion.I am not sure if LLBGen can also generate the UI. So far all the development in the house we do it the classic way coding each layer manually. However we are in need of a fast prototyping tool.

View 3 Replies

Web Forms :: Choose Which Master Page To Use?

Apr 6, 2010

I have 2 Master Pages: Master Page A and Master Page B. I also have another page (page C). I want to, when someone try to load page C, if he is logged, page C uses Master Page A. If not, page C uses Master Page B

View 3 Replies

Need The System To Be Able To Let The User Choose The Time Of Email?

Feb 25, 2010

I'm only a novice asp.net developer and have never done this before. I have a developer working on a new web application for me. Part of the application allows the user to select a time when they receive an email, containing information collected throughout the day. The user can select a time, e.g. 5pm, then at 5pm every day they receive an automated email of information from the system. They can log in to their control panel and change this time.My developer says there is only two ways to schedule this batch, but it's not possible to let the user select a time. They have suggested:

a) Using a console application that will trigger the event everyday and send the batch update
b) Using a Windows Service that will deploy on your server and do the operation.


I really need the system to be able to let the user choose the time of their email. I hoped this would be possible with ASP.NET. Is it? If so, how?

View 3 Replies

Security :: How To Choose A User And Store Specify Their Rights In C#

Mar 14, 2011

Roles: - administators

If it administator shows menu "Admin".

If I want to display the menu: "Create new employee ', have to create Roles: new_employee?

If so, how to choose a user and store specify their rights in c#?

View 3 Replies

Which Control To Present Table For User To Choose From

Nov 10, 2010

I want to put up a table with a couple columns, and have the user select a row. This will all be from code; not through a DataConnection. GridView seems like it wants to deal with bound controls. What control should I use? ListView doesn't do columns. A table doesn't seem to allow selection. Specifically, what I'm doing is letting the user find a person in active directory. They'll enter the name, and I'm going to present a list of the Active Directory matched results that they can choose from. Is there already some built in control or package that will do this?

View 1 Replies

C# - Choose Landing Page After User Logs In?

Jan 31, 2011

I was wondering when a user logs in using the login control for ASP.NET, how do we choose where the user goes after? Do we configure this in the web.config file?

View 2 Replies

C# - Ajax Autocompleteextender Not Showing The Autocompletelist To Choose?

Apr 23, 2010

i was working ajax auto completeextender witha text box in asp.net and c#.net. i am not able to get list to choose ,i have the appropriate web service method called..

<form id="form1" runat="server">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<div>

[Code]....

View 1 Replies

Why Would I Choose To Create A Website Verses A Project

Dec 21, 2010

I'm using visual web dev 2008, why do I have two choices Create a website and Create a project?

View 1 Replies

Installation :: Trying To Choose Items For Ajax Toolbox For VS 2010?

Nov 8, 2010

I have just installed VS 2010 Professional. After I create a c# web project with default target 4.0, I don't see most items in ajax toolbox. When I try to choose items, CalendarExtender along with other items are not in the list to choose from.Shouldn't those items like CalenderExtender be available by default? Suppose I could manually download the ajax toolkit but is that the right way to fix it?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved