SQL Server :: Writing SP To Propagate Calendar Tables?
Jan 28, 2011
I have a new web application I'm trying to create. I'd like to put some automation into how it propagates upcoming dates. Here is the way I'd like it to function.
I have three tables:
Managers
- id
- netid
- phone1
- phone2
- username
Monthvals
- id
- monthname (Friendly like December 2010)
- monthval (shortdate like 2010-12-01 00:00:00)
Weekends
- id
- weekend_val (date of the friday)
- month_id (Monthvals.id)
- mgr_id (Managers.id)
The tables I need to create SPs for are monthvals and weekends that will build the upcoming year. This is where I'm kind of stumped.
The spec for this is each manager gets assigned a weekend every 35 days with the exception of two which alternate so in that case, every 70 days.
What I need this SP to do is based on the activity in December or the last six weeks, I'd like it to write out a schedule for the following year. I don't mind writing this out but I could really use some psuedocode to iron out what I'm trying to do.
I am developing a web application where users can draw their own images in a web page using canvas. After it's drawn, this image should be shown in other users' browsers' canvas. Same thing with updates.I am only using javascript. How can i solve this problem using System.net and Asp.net?
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
I'm a little stuck here, with my first server control. I'll just post the whole thing, as I'm sure I've done plenty of mistakes. The main thing for me to find out is if there's a more elegang way to write this.
What I'm trying to accomplish here is to write a panel with custom HTML inside it. Inside the custom HTML, I need to put some server controls I can actually reach. My attempt at finding the span in the code failed, so there's obviously something wrong.
[Code]....
Obviously, I've only just begun, but I'd really value some feedback before I dig myself in too deep ;)
I've got two websites. One is a copy of the other, I even went ahead and remade a copy of the original a second time hoping it would alleviate the issue I'm having but it didn't.
On both pages I have a calendar so the route is
Csharp Code:
[code]....
The issue is on the original site /Calendar works. It shows the Calendar page with the current month. On the copy site /Calendar gives a 404 but /Calendar/Index shows the Calendar page with the current month.
I have write small web-service that recieves query and read txt file for matching. For it I'm using StreamReader.
I'm not waiting that it will be thousands of users in hour for this service, but whats worried me - if some users at the same time will be use that service is it ok? Can text file on server side be readed at same time from some users?
What is capacity for using StreamReader or StreamWriter on server?
I have an ASP.NET app that writes binary data to a SQL database. It worked fine using SQL Express, but does not ever write the data using SQL Server 2008 R2. SQL Profiler shows the binary data in the UPDATE query, but nothing happens... no errors, no data saved. Does anyone know what I'm missing? Other data types work fine.
I have a table that is not getting updated. My insert command is working fine. Here is the update code from business logic area and stored prodecure. The SP works fine when I execute it from sql mgmt studio and updates the table:
I am trying to create and write a file on a remote server using the below code:
[Code]....
but i am running into issues and getting errors. Below are some tries i have given. My IIS settings are 'Anonymous Access' checked and also 'Integrated windows authentication' checked.
a. As i understand asp.net site would run using ASPNET account, i tried giving full permission to ASPNET account to the folder on the remote server (where i want to drop the file). But i am getting this error - "Logon failure: unknown user name or bad password"
b. The other thing i tried is giving full permissions to 'Everyone' to the remote server folder. But i get the same error as above. But when in my web.config i enable impersonation by using: [Code]....
then the error goes away and everything works fine as expected. The file gets dropped to the network share.
why the scenario (a) doesn't work because that should work as if i give ASPNET account full access to the folder, and my website is running under the same account, then it should work.
Also, in the scenario (b), i believe it is using my domain account, as the impersonation is true without specifying any username and password and also the remote server folder has Everyone access to full control. BUT, as a security breach, i cannot use Everyone account to the remote folder. In that case, how can i make this working.
I was also thinking if i can use the virtual directory as the path to the remote folder, something like http://domain.com/remotefolder but dont know how can i use this approach. Can someone pls share some sample code and the configuration.
In Production Server there are Issue with Writing in one of File. File not getting Write.I have give all the permsion even added EveryOne give full permsion.It's working on a windows 7 But Not working on a Windows Server 2008.R there any extra permsion need to apply ??
I'm making an application which takes image from user upload it to server and then perform any image processing like to convert to gray or invert etc.
My problem is this when i did the process on image to gray it or invert then how to write this new file on server or is there any other way so that i would be able to show this (new) image to user and make it downloadable?
I need some jquery code in my application I have a button on the page and I want to handle it by jquery when the user click on it to show a confirmation dialog for example Are you sure? yes|no buttons but this is an asp.net button inside the updatepanel and in the other side I have some server side code to delete a record from database but my question is how I can handle both of them? server side and jquery inorder to when "yes" button clicked it runs server side and delete recorde from database and if the button is no it stop running ?
I've got an MVC 2 application running on Server 2008 R2, IIS 7.5. The application runs without issues. I added ELMAH to trap unhandled errors, write them to a database and send emails. The ELMAH functionality works without issues on my development machine (XP). However, that same functionality does not work on the server. ELMAH fails silently so I'm at a loss to know why things are not working
i need to save multiple documents stored in SQL server as Image type to disk.
What i want to do is "backup" all files in a table (column) to disk, zip them and Response.TransmitFile(FilePath) to client.
I could use C# ot VB but that would require a lot of connections to database or a lot of server memory and i don't want that, becauze there are a lot of files to be saved Since SQL can write files to disk i was thinking about saving those files to disk directly from sql. Something like when u're doing a backup
I've created 2 web user controls. A = User control that displays an image, and B is the user control that hosts A. I'm trying to stream an array of bytes to A, but it seems like the Response.BinaryWrite method completely overwrites any heirachial controls (I can't see any of B's other controls besides the image).
How do I get A to just display the image from the byte stream? It doesn't come from a database, it's an image I created on the fly.
I want to compare smalldatetime values in my db to a calendar date. I'm not getting any value from dr[0] when I debug and put breakpoint in code below. Same thing if I select 'dateStart' instead of 'count(*)'. Any ideas?
how to connect the two tables of the sql server 2008 databse in C#.
in this there are two tables
1) Tour header(id, name, city, destination)
2) Tour Detail(id, tour id, day no, title,description,images)in this id of tour header and tour id of tour header will be same.now i want to retrieve the data on the basis of when id==tour id.how can we can run the query of two tables.
I am using Framework 2.0, ASP.NET AJAX 1.0 and Visual Studio 2005.I am using 2 Ajax Calendar Extender in my page. I am using a text box and html image control and setting the TargetControlID to the test box id and the PopupButtonID to the image control name. When i click the first image the calendar pops up and without choosing a date if i click the second image the second calendar control opens on top of the first calendar control. Is there any way i can make the previous one disappear without choosing a date leaving the calendar control associated with the last image clicked.
