.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

House Keeping

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
what is housekeeping in sqlserver ?

View Complete Post

More Related Resource Links

Extreme ASP.NET: Keeping secrets in ASP.NET 2.0.


Storing data securely in a configuration system is not an easy problem to solve. While I was on the ASP. NET team, this particular feature, secure connection string storage, looked as if it wouldn't get done.

Rob Howard

MSDN Magazine May 2006

House of Web Services: Mandatory Headers in ASP.NET Web Services


The ASP.NET Web Services infrastructure includes support for programming with SOAP message headers. Unfortunately, the model for handling mandatory headers is flawed in that you need to write additional code so that a Web Service will not execute when a mandatory header is not processed. This column explores a specific problem that arises when you deal with mandatory SOAP handles and presents three solutions.

Tim Ewald

MSDN Magazine May 2003

House of Web Services: Accessing Raw SOAP Messages in ASP.NET Web Services


Web Services exchange XML messages. Most of today's Web Service toolkits do their best to hide this fact from developers, by exposing a Web Service's behavior as method invocations against objects instead.

Tim Ewald

MSDN Magazine March 2003

Reading/writing Word documents - keeping formatting


I've done some reading about reading from and writing to a Word doc. The reading from worked without issue:

string strPath = "Test.doc";
FileStream fStream = new FileStream
    (strPath, FileMode.Open, FileAccess.Read);
StreamReader sReader = new StreamReader(fStream);
string text = sReader.ReadToEnd();

But of course this is just a string, without any formatting information included. Writing to the document using a StreamWriter worked, but I received errors when opening the document.

I've also read that trying to perform actions on an Office document on a server without the Office products installed on it can result in mayhem. I'm working on a MVC application that will allow users to upload documents to the server, work on them, save their work and email it around. That doesn't specifically require the need to read/write programmatically, but for certain application functions I do need this. Any helpful suggestions are appreciated.

jQuery results set keeping populating

I have jQuery function that makes an ajax call that builds a HTML string to populate the feature. the problem is there is link on the page that does a refresh of the page, the problem is that the HTML that got added the jQuery ajax call adds the HTML to the page again so that the result is not doubled. if you do it again the result gets added again. So my question is how can i clear the HTML so the result is repeated multiple times? or what is the best way to solve this problem?

Calling WCF Services From Silverlight Keeping The Code Inline in VB.NET

Hello,   I have a large amount of code that I'm trying to convert to a Silverlight 4 Application from a VB.NET Win Forms App.  All of the business logic code is written inline calling stored procedures on a database.  There is so much code that it's overhelming to be making asynchronous call after asynchronous call back to the WCF service.  The code is now all over the place since I'm having to chain methods all around after the WCF calls complete.    I don't really need these WCF calls to be done synchronously (since we don't want to block the main UI thread), but is there any good way in VB.NET to keep all the code in-line when calling a WCF service?  Is there some sort of wrapper that can be used to call the WCF methods or another way?  I know some of this is done easier in C#, but I'm having some issues with this being done in VB.NET.   Example In The VB.NET App I'm Converting:   Dim Customer As New Customer   If Customer.CheckIfCustomerExists(10) = True    'Calls the database, checks if Customer #10 exists        'Do Something   Else       Dim CustomerNum As Integer = Customer.InsertNewCustomer("Customer Name")       'Do Something    End If In Silverlight This Woul

C# ASP.NET Problem keeping scroll position SelectionMode="Multiple"

Have tried numerous solutions and nothing has worked.  I'm pretty sure that Javascript is required to get this functional. Thanks for your help!    Here is the code for file Search.aspx ===BEGIN<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="search.aspx.cs" Inherits="SearchApp.search" MasterPageFile="~/Site1.Master" EnableViewState="true"%> <asp:Content ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <fieldset> <legend style="text-align:center;"><b>Make Atleast one or multiple selections from one of the following categories</b></legend> <div class="wrapperserach"> <div> <div class="side-a"> County<asp:ListBox ID="Lcounty" runat="server" AutoPostBack="true" SelectionMode="Multiple" OnSelectedIndexChanged="Lcounty_SelectedIndexChanged" Width="140px"> <asp:ListItem value="1">Imperial</asp:ListItem>

Keeping colours on click-through charts

I am wondering if someone can help me with this: I have a main pie-chart report with 5 categories. When I click the series label for the respective category it goes through to another bar-chart report with a breakdown of this category into sub-categories. As things stand, whichever category I click in the main report, the colour of the bars in the sub-category report is blue. What I would like to do is "keep" the colour of the main pie-chart category on the bar-chart subcategories. For example if the fill colour of the pie-chart category that I am clicking is Red, I want the bar-chart sub-report that opens up to be coloured all Red as well. Do let me know if this isn't clear... thanks!  

Dynamically sizing columns while keeping two the same size

I am setting up an interface that has a grid with 5 columns.  Three of those columns have a fixed width.  The other two columns I would like to dynamically size according to how big the grid is (i.e. a * size) and I would like them always equal to each other.  The two pieces of code I have tried follow.  Option A keeps the columns the same size but makes everything as wide as it wants w/ no respect for the size of the grid and Option B allows the two columns to size independently. Option A <Grid Grid.IsSharedSizeScope="True" > <Grid.ColumnDefinitions> <ColumnDefinition Width="14" /> <ColumnDefinition SharedSizeGroup="FirstColumn" Width="200*"/> <ColumnDefinition Width="105"/> <ColumnDefinition SharedSizeGroup="FirstColumn" Width="200*"/> <ColumnDefinition Width="14" /> </Grid.ColumnDefinitions> </Grid> Option B <Grid > <Grid.ColumnDefinitions> <ColumnDefinition Width="14" /> <ColumnDefinition Width="200*"/> <ColumnDefinition Width="105"/> <ColumnDefinition Width="200*"/> <ColumnDefinition Width="14" /> </Grid.ColumnDefinitions> </Grid>
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend