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:
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
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
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
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
Feb 1, 2010
Asp.net, php, jsp What other popular (used alot in production) languages for HTML pages generation are there?
View 4 Replies
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
Sep 6, 2010
What is the best and easiest-to-use video player for popular video extension in asp.net?
View 1 Replies
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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