I'm new to asp.net c#2 ddlist : mean that choose from ddlbeginwk to ddlnextwk and a button btnlookupin my DB is ms sql express and i have 2 main table:
Teach_Week_id int
Name_Week nvarchar
Term int --there a 2 term per year in my school
[code]...
I have the following database, consisting of 3 tables: Job, JobPhase, Assigned (as seen in the following image)
[URL=http://img836.imageshack.us/i/87157705.jpg/][IMG]http://img836.imageshack.us/img836/8710/87157705.th.jpg[/IMG][/URL]
I'm trying to create a page that will hold a table. The table will represent, for a particular employee (ID = D_ID), his/her corresponding Job Schedule sheet.
how can i create a job which run a StoreProcedure in a sepcific time like 11:59pm daily and one in weekly on sat at 11:59pm and one more is that how can do backup the daily data using scheduling or job in sql server 2005
View 3 RepliesI Want to Create windows schadule with my website on my host in server.
View 4 RepliesI want to develope an Teacher's Rating/ Feedback/ Assesment (by students) application in .NET.There will be 20 different points on which a student will rate his/her teachesr as poor, fair, good, Very Good and Excellent.
View 4 RepliesI can able to post now FB comment post from asp.net system but if i want to schedule some message from my sytem what can i do ? How can i store FB account ?
View 1 RepliesSchedule Hours for Using WebApp?
View 7 Repliesi am using .net 3.5 framework.I need to create a schedule and i need to run the schedule(daily at 12 noon) using .net.
View 3 RepliesHow to Schedule an ASPX Page to run at a particular intervals of time using Schedule Tasks in Control Panel"? If so can any one explain me in detail "How would I achieve that with neat steps".
View 6 Repliesi have a time and at 12:00,14:00 and 16:00 i need a email to go out daily, but i been trying to code how to set time with no luck .... i also google it as well
View 1 RepliesI want to know how to create events calendar in asp.net , monthly view, weekly view, day view.... any article link to refer..
View 1 RepliesI am completely new to asp.net vb web programming. and am working on a web project that will require event to be trigger at user defined date and time over the web, e.g: if a user schedule an email to b sent at particular time from server. how do i go about such and where do i start from.
View 8 RepliesI would like to schedule a web service. In console applications, I can run them in scheduled tasks, is there a way to do it for web services?
View 3 RepliesHow can I schedule several statements that involve select ... into ..., delete, and exec one other stored proc, periodically? For instance, every 6 hours, in Sql server DB
View 1 RepliesI want to schedule a batch process in my APPLICATION SERVER every night by calling a stored in my database.
View 4 RepliesI am creating a feature which will allow users to import data of excel sheet to database.First, data will be imported from excel sheet and will be displayed in a tabular format.User performs a mapping porcess for database fields and click Submit button.Then a stored procedure inserts all the data of each row into more than 15 tables.
Above mentioned process might cause an issue if users import more than 1000 records (they are definitely going to do that. Thats why this entire functionality is intended for).Basically, what I would like to do is, Insert all the rows to a single table (Temp table), have a cloumn in a table which will be a flag and initially, will be set to "Pending".Create a page which will be executed when there are less users accessing the system (Specific time),
This page will see if there are records in a temp table with FLAG "Pending". If yes then it will fetch one record from the table and will insert data of first row into all the necessary tables. After first transaction it will wait for some time and will fetch the second record....This will last until the final row of temp table is reached.
Can i schadule my site for send email on time for example i set 8:59 and i want to automatic send email on this time.
View 6 RepliesI don't want to use SSRS web service to schedule SSRS report rather than wants to use sharepoint jobs to schedule SSRS report. Let me know possibilty.
Technology
- SQL Server 2008 R2
- SharePoint 2010
Well, I'm sure this is not the first time to see this question. and TBH you can find this question answered on many other websites and blogs -not only here-
But I never saw a complete answer for this question, I mean no one talked about the advantages and the disadvantages. no one shared a real experience.
Although Quartz.NET seems like a good solution but yet, there's no enough reviews or a good comparison between the different ways to achieve such a thing.
As far as I read about it I found this are the possible ways of doing this :
Using a: Web Service, Windows Appliction, Console Application, Quartz.NET.
Examples of stuff I want to achieve with the scheduled or automatic methods/events are like archiving after a certain period, auto deleting/moving records in the database, setting a property of an object after a certain time, automatically run some methods according to my holiday schedule.
I hope you'd share your experience either with one of those approaches or share a new way of doing this.
Coming to my task, I have to schedule a process which will delete all the files in the paticular table with particular key.I have the stored procedure for the deletion. What all I need is, How to schedule this process in the application server.?
View 5 RepliesI am trying to use schedule task on the server from the web application hosted in IIS. I have written the code to create Task and passing the valid username/password under which this task needs to run on server. But I get an error: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access. The same code works well with console and windows service and able to create task. I understand that this is security issue. My sample app is attached at: [URL]
I need to schedule a task in my system with windows task scheduler and vbscript(or js also).
I want to send an http request for an aspx page in my project fom the vbscript file .This aspx page contains some database related operations.
That means when the task scheduler is started it should update my project db.
I got this link for reference
[URL]
But it is not working for me.
Can i use javascript instead of vb script?
My project is in C# and backend is sql server express 2008
I i want to schedule an asp.net page on my hosting, how to achieve it?
for instance, i have a page named myservice.aspx runing on my website.com/myservice.aspx
i want to run this page on every 24 hours.
I'm new to ASP.net 3.5 and trying to create a test site so I can figure out how to use it in the real world. I have created a FormView (Formview1) based on a Client table using Linq Data Sources. The page includes a DropDownList to lookup Clients. I have added a list option (<asp:ListOption value="" Text="(Select Client)" and set AppendDataBoundItems=true so my added option is displayed. I decided to try to use Formview with only the Edit and Insert Modes, and I have set the Default Mode = Insert. When you open the page, a blank Client record is displayed.
The Client record contains serveral lookup fields and they have drop down lists for each. When I select a client from the Client DropDownList, is get the following message 'ddlClientType' has a SelectedValue which is invalid because it does not exist in the list of items I had this problem before and decided the best way to handle this (in the interim) was to turn off foreign key constraints for each of the lookup fields (e.g. ClientType) in SQL Server. That worked for 2-3 days. Now the problem has started again.
When I develop in other applications, I would simply create a lookup data source based on a Union Query with the actual data and a blank record. How can you do this using Linq DataSources. Can you get access and modify the queries?
i have web application it should create single HTML page . that one HTML page should send to the customers.how to create HTML page .i created one page but it retriveing single record from the databse values . my problem is i have to pull all the records from the database and papulate the HTML page. but i am getting only onerecord on that page.my code as follows
string type = ds.Tables[0].Rows[i].ItemArray[4].ToString();
string WAIVN = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string status = "cdcr";
[code]....
but iam not getting all records only single record only iam retriving