SQL Server :: Delete Records Automatically At Server Side?
Sep 14, 2010
the application which i created is a web application which doesnt need much of a database,so i am just using the sql express free version which allows 4 gb of data,to avoid disasters iw ould like to delete records which are very old like,1 month,2 months old etc,how can i do this periodically should i do this on client side or the server side...
what id there are 100000 records and if we put this in page load or some method,it could take some time to delete,which i dont want..... how i can automate this process at the server side only
View 4 Replies
Similar Messages:
Mar 10, 2010
In my online shoping project i m uploading images in my Image folder
now i want to delete image when it is deleted from database.
View 3 Replies
Oct 26, 2010
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server.I have sql 2005 and I have created triggers and tables CDC to capture the data. everything functions good and the data is being updated in the _CDC tables. all i need to do now is to generate the updated data as a report (excel/html)- what should I do ......?i need to show only the updated columns when user selects the date periods ( Range between dates ) and the person name - i need to display any updated info about that person during that period. So this updated columns about this person should be displayed in excel formatted column wise.
View 2 Replies
Jan 11, 2010
I need to call server side event when the i enter or delete the text (char) in textbox. How to do this in asp.net/c# 3.5.
View 9 Replies
Apr 8, 2010
The code for the asp.net page is:
<div class="facebox_content">
<% if (CurrentUser.Role == "Free")
{
%>
<table cellpadding="0" cellspacing="0" style="border-collapse:collapse;width:380px;">
<tr>
<td>
User Name :
</td>
<td>
Membership Cost :
</td>
</tr>
<tr>
<td style="width:190px;">
<asp:TextBox ID="txtUserName" Enabled="false" runat="server" Text="<%= CurrentUser.Name %>"/>
</td>
<td style="width:190px;">
<asp:TextBox ID="txtCost" Enabled="false" runat="server" Text="2000"/>
</td>.........
View 1 Replies
Mar 4, 2010
I was reading about the fact that you can turn an IFrame control into a server object if you give it the runat="server" attribute. So I did that, for the purpose of running a website WITHIN our network. What I mean is that I want the site that loads INSIDE the frame to be loaded from WITHIN our network's IP address, and not the remote location's (browser's) IP address.Does this not work this way or am I barking up the wrong tree with IFrames?
I have a situation with dozens of remote locations, many of which I cannot easily get static IPs for, using a web based service that has IP restrictions in their hosting environment. I am essentially trying to, via our web server, FUNNEL all the users in the field through our network via an IFrames webpage, so that they can access this service which requires static IPs. They are okay with this, at the service we are using, if I can get this idea working.
VPN is not an option. These users are ehhhhh... no comment. For that matter, I don't feel comfortable with these remote users being on my network as anything but a port 80 web user, because of the potential for viruses.
View 2 Replies
Feb 4, 2010
HOWTO create ASP.NET C# controls on server side for posted data that had no runat=server on the client.
I have processes needing to post files to a ASP.NET application. These processes must post without runat=server as such:
<form ~~~~ to some ASP.NET/C#/aspx page>
<input type=file name=MY_FILE ~~~>
</form>
On the ASP.NET page, in the Page_Load I would code somethign like this:
[URL]
Here is the trick, the control "fileLIST_FILE" does not exist because the HTML does not have runat=server on it.
If the client did have runat=server the designer.cs would have somethign liek this:
System.Web.UI.HtmlControls.HtmlInputFile fileLIST_FILE;
With all that said, I want to make "fileLIST_FILE" on the fly inside Page_Load fromt he posted name of "MY_FILE".
do not focus on the fact that this is a file upload. I would like to know how to do this for any posted FORM data.
View 11 Replies
Mar 31, 2010
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
View 7 Replies
Aug 19, 2010
I need to test the counts shown in SSRS report. The report reads the counts from one of the tables.
I need to verify the counts shown in the report. For this I need to insert bulk records in the table (with different userid, datetime, etc).
How can I do this? I really don't want to do this manually.
View 1 Replies
Jul 15, 2010
I was wandering if I can make this faster. I am taking records out of Oracle and putting them into a SQL Server. btw, I am inserting into the Identity column
[Code]....
View 1 Replies
Oct 16, 2010
I am using VS 2008 with SQL in express edition . I have made my website and hosted it on server with cuteftp .Now i want to change
the website so when i tried to delete all files the App_data folder does not delete .
So i am unable delete my mdf and log file which are in this folder. It says file error.
I always use SQL in design window in VS and know less of coding in SQL.
View 5 Replies
Dec 2, 2010
is possible to insert and delete data in database sql server from global.asax? How to make the connection string? Does anyone have any examples? it is difficult for my level.
View 3 Replies
Nov 22, 2010
We have an UpdatePanel that is showing a gridview with loads of data in it. We have loads of well written sprocs that don't take very long, BUT we have a few horrible ones that take ages.
We do intend to rewrite them but in the interim we have put the ADO.NET commandtimeout up to 180s. The scriptManager.AsyncPostBackTimeout is set to 240s. We want to handle this on the serverside. One of the reports still fails (it's got a couple of nested cursors in it - someone who hasn't had SQL lesson 101 from me!).
Half the time, the nice error timeout message is shown using server side handling of the command timeout. The problem is that the other half of the time the commandtimeout doesn't seem to fire.
View 1 Replies
Feb 19, 2010
I'm new to writing custom ASP.NET server controls, and I'm encountering the following issue:
I have a control that inherits from System.Web.UI.HtmlControls.HtmlGenericControl. I override the control's Render method, use the HtmlTextWriter to emit some custom HTML (basically a TD tag with some custom attributes), and then call the case class' Render method.
Using the control:
<dc:Header id="header1" runat="Server" DataColumn="MemberNumber" Width="30%">Member Number</dc:Header >
The problem is that when I view my rendered HTML, the server tag is emitted to the client as well (right after the TD tag):
<dc:Header id="ctl00_ContentPlaceHolder_testData1_testData1_header1">Member Number</dc:Header>
How do I prevent this from happening?
View 1 Replies
Feb 15, 2013
I have data in database and that database is in the ip address .this ip address includes the data when i run the application it will give me all records but after the publish it will show me less data.
View 1 Replies
Jan 6, 2010
If I have a standard HTML textbox
[Code]....
but got a readonly error.
View 10 Replies
Dec 9, 2010
I have a requirement of adding server side variables in client side and other way round. Because I need to set a value from client side using javascript and access the same in code behind page.
I have to use C#.Net and JavaScript.
View 2 Replies
Oct 17, 2010
Suppose I'm building a StackOverflow clone using webforms ASP.NET and jQuery. The Question page has a question, several answers, and comments under each. Requirements:Users can post new answers and comments, and edit existing ones, without postbacks. No UpdatePanels; the AJAX calls retrieve just the JSON they need, not HTML fragments. The page loads with all existing answers and comments in place (no javascript needs to run to read the page).
What I'm trying to figure out is how to do this without having to maintain two sets of markup (one that's bound on the client using some form of jQuery templating, and one that's bound on the server using traditional WebForms).
View 7 Replies
Jan 5, 2010
I reordered some items in a listbox using Javascript. When I read the items in a postback in the code behind (ASP.NET), the order is in the original order. How do I get the same order as shown in the screen after Javascript manipulation?
View 3 Replies
Oct 4, 2010
I m using site login Control in my login.ascx file and disaplaying login control in Div so if there is login link in page and i click on that then Login Div will popup which is site login.May i know how can handle error like username or password is incorrect on client side instead server side?
View 6 Replies
Feb 9, 2011
I have to implement the print functionality on aspx page like on click of print image icon user will be able to get the print out of aspx page .aspx page will contain the server controls like textboxes , Gridview etc which one approach will be the best server side or client side printing ?
View 4 Replies
Jul 19, 2010
I am trying to set a hidden type value to x on Server Side and then access it with Javascript. I have tried multiple ways to accomplish this.
At the basic level this is what I am trying to do.
Aspx page
<asp:HiddenField ID="HidRowNumber" runat="server" />
CS Page
In IsPostBack
HidRowNumber.Value = EFileRowNumber.Text;
Javscript
var status = document.getElementById("<%= HidRowNumber.ClientID %>").value;
When I am debugin it say it HidRowNumber's Value has changed to x but when I access the value with JS it always returns ''.
View 23 Replies
Aug 7, 2010
i can use escape() and unescape() functions by Client side easily, but the problem when i have use escape() method for peice of HTML , then i dont know how to unescape this piece of HTMl By Server Side not By Client Side. how i can unescape (escapped HTML) by server side?
View 2 Replies
Oct 26, 2010
I have a hidden variable and its value is being updated using javascript(client side) which I make a call from server side code. After making the call I am not able to retrieve the updated value from Server side variable. I went through this forum [URL] but not able find a way how to implement functionality with IFRAME. I am trying to call the client side code and retrieve the updated value from server side in page_load event.
View 5 Replies
Feb 4, 2010
I have set the ajax tabs disable on form load. ON button click, I want to enable the tab server side,not client side.
protected void btnEnableCostPetroleumTab_Click(object sender, EventArgs e)
{
TabContainer2.Tabs[0].Enabled = true;
}
But its not enabling the tab?
View 12 Replies
