I'm creating an online Clock-in/out tool. An employee may have to leave work for a bit and return at a later time in the same day. This would cause multiple entries for the same date. I need to be able to show the daily total for each date. I have not been able to get SQL to total up the times and only display the date once. The image below shows some data in my table and the outcome that I am trying to achieve. The first table has 2 rows highlighted. They have the same date. The second table shows how I would like it to add the two rows and display them as one.
I'm using resx files to localize my asp.net 2.0 application. As it's freeware I need the help of many users translating it for free. I don't want to use automatic translation as there are my special terms which need to be translated exactly.Is there somewhere an online tool where resx-files could be translated? My users might have different operating systems, so having an online tool would be the best to find new users translating the pages.
Our team doing a project in asp.net & Mssql 2005.since our team member are distributed. we need a online tool for tracking project changes, and control access to our online code repositories.
OLE DB provider "SQLNCLI" for linked server "xx.xxx.xxx.xxx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
I have one asp.net 2.0 application with MS Sql 2005 database.. As i deploy this database with client Machine.. now what i need is i need to take a backup of MS Sql 2004 database.. so is that any free tool is available which take daily backup...
I am developing a simple online DBMS to browse my database online.... the main concern for me is to clear everything from the PC when the user disconnect so no body can go and click (Back) on the browser and see the pages if the user forgot to close it.. what I have done so far is :
[Code]....
I am sure this is not enough.. am I right? so what else I should include there?
I want to create a Online Exam site in ASP.NET .In that i want to display Test based on the Date and time and the user can take the test at the time set my the Teacher.
For Example:
Teacher want to take C Test for the Mid Semester Test and the test is schedule on 1 May 2010,then the test should appear on the test page on the 1st may only and the user should be able to take the test on the set time.
The problem is that if i use System time then user can change the system time and can take the test schedule in future.
So i want to know how can implement this thing.I have given many online test but dont know how they work out the time and date logic.
I am trying to have a time clock on my page, I want it to start from 0:00 and then start going up, my plan was to have an AJAX timer and a updatepanel with a label inside of it which would refresh every minute and update the time, how can I get the code in VB.NET to start from 0:00 and increase by 1 minute?
I want to add a running clock on my aspx form. which after certain period of time like 30 minutes or something. After 30 minutes the form should automatically submitted.
for my website, i am trying to connect to the online DB from my local PC.when i put the following connectionstring:Data Source=88.8.88.88; Initial Catalog=dbname;user id=dbuser; password=dbpass; Min Pool size=50;Packet Size=32767;Connect Timeout = 200;pooling='true' 88.8.88.88 is the server ip, the databse over the server is sqlexpress 2008. the connection string is working with no issues over the server.i got the following error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)thanks
I want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I'm trying to create a stopwatch in asp.net that displays the time in seconds as the text of a label. But I noticed that the timer control in asp.net only refreshes the whole page at each tick interval. I managed to create a clock in VB.net using the following code:
I want to merge a software with a website.I have no source code of software, but i want to the database of online data and offline data will automatically synchronize. I have only control over website, online database and offline database.. Is it possible, if yes how?
[code]....
but when i feed data in offline database, online database automatically updated.
I created a database in my local sql server, and ran aspnet_regsql.exe on it, which created all the user and membership tables. However, when I click on the "Asp.Net Configuration" button in VS (2010), it open the Asp.Net Web Site Administration Tool, but with an error that say "An error was encountered. Please return to the previous page and try again." (of course there's no "previous page". What is one to do here? My solution consist of several class libraries (domain, contracts, services, etc, etc) and a Asp.net MVC project. In my web (mvc) project's web.config, my connectionstrings looks as follows (just guessing this matters):
i am trynig to connect to sql server 2005 express with Web Site Administration Tool in visual studio 2008 but i got this error in security tab: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
i have already checked following links and done all hint but nothing [URL] i have MSSQLSERVER running but i can not run SQLEXPRESS
I want to develop a Online Exam Management Project using asp.net and sql server. I want to know whether there is any open source project available for the same.
connecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
