Geeks With Blogs
Gaurav Taneja Great dreams... never even get out of the box. It takes an uncommon amount of guts to put your dreams on the line, to hold them up and say, "How good or how bad am I?" That's where courage comes in.
Using Derived Tables to Simplify the SQL Server Query Process Problem Sometimes querying data is not that simple and there may be the need to create temporary tables or views to predefine how the data should look prior to its final output. Unfortunately there are problems with both of these approaches if you are trying to query data on the fly. With ......

This is about adding a new SQL Jobs in the Sql Server 2005. Step 1 Make sure that the SQL Server Agent is up and running. You can see it in the taskbar icon. If SQL Server Agent is not running, start it from the SQL Server Configuration Manger You can also start the SQL Server Agent from the command prompt using the command netstart net start "SQL Server ......

What is Proxy and how to generate proxy for WCF Services? The proxy is a CLR class that exposes a single CLR interface representing the service contract. The proxy provides the same operations as service's contract, but also has additional methods for managing the proxy life cycle and the connection to the service. The proxy completely encapsulates ......

Create Procedure GT_DeleteRecords_AllTables As /**************************... Stored Procedure: GT_DeleteRecords_AllTables Do not excute this proc Purpose: Delete ALL records within ALL the tables in a DB with ease. Test: Exec GT_DeleteRecords_AllTables*... Set Exec nocount ......

To change the color of Tab control Add this event handler DrawMode property to OwnerDrawFixed. Override the DrawItem event handler definition. tabControl2.DrawItem += new DrawItemEventHandler(OnDraw... step 2 private void OnDrawItem(object sender, DrawItemEventArgs e) { TabPage CurrentTab = tabControl2.TabPages[e.Index]; Rectangle ItemRect = tabControl2.GetTabRect(e.In... ......

CREATING DLL DYNAMICALLY you need to complie this code Public Function CreateResourceAssembly() As Boolean Dim currentpageHashVal As Hashtable = New Hashtable() Dim intArrIndx As Integer Dim strTextVal As String Dim blnIsSuccess As Boolean Dim strAsmFileName As String = FetchTest.resources.dll Dim strPathAssmbly As String = strAppPath + FetchTest.resources.dll" ......

Reading a dll into bytes Dim strPathAssmbly As String ="c:\abc.dll" Dim btByte() As Byte = File.ReadAllBytes(strPathAs... ......

Diplaying the controls Public Sub DisplayControlName(ByVal oControl As Control, ByVal strPageName As String) Dim txtBox As TextBox Dim ddlLst As DropDownList Dim rdBtn As RadioButton Dim rdBtnLst As RadioButtonList Dim chkBx As CheckBoxList Dim chkBx1 As CheckBox Dim lblVal As System.Web.UI.WebControls.L... Dim htmTbl As System.Web.UI.HtmlControls.... ......

How to fetch Page controls of web form Dynamically in vb.net To Find the Page Controls in a Web Page Public Function FindPageControl(ByVal oControlCollection As ControlCollection, ByVal strPageName As String) As ArrayList ' Traverses all the controls in the page For Each oControl As Control In oControlCollection DisplayControlName(oControl, strPageName) ......

Example displaying when data is sent in form of xml document CREATE PROCEDURE XMLINSERT @intShowVersion INT =0, @strClassName varchar(250), @strLang varchar(10), @strXml text='', @intError int output AS SET NOCOUNT ON /* @intShowVersion INTEGER =0, @strCreatedBy VARCHAR(20) = '' , @intTemplateID INTEGER = 0, @dtClientCreatedOn DATETIME = '' , @strUpdatedBy ......

Looop through the controls... Private SetTooltip(oControl, strToolTip) FindToolTipControl(oControl... strToolTip) Sub FindToolTipControl(ByVal oControlCollection As ControlCollection, ByVal strToolTip As String)For Each oControl As Control In oControlCollectionNext ...................... Private Sub SetTooltip(ByVal oControl As Control, ByVal ......

Count Procedure select count(*) from sysobjects where xtype='P' other option is below select CASE(XType) WHEN 'C' THEN 'CHECK constraint' WHEN 'D' THEN 'Default or DEFAULT constraint' WHEN 'F' THEN 'FOREIGN KEY constraint' WHEN 'L' THEN 'Log' WHEN 'FN' THEN 'Scalar function' WHEN 'IF' THEN 'Inlined table-function' WHEN 'P' THEN 'Stored procedure' WHEN ......

UrlRewriting is one of the interesting and advance topics in ASP.Net, following is the link shows the comprehensive information on URLRewriting. Scott has give a fantastic detailed article on URL Rewriting. here http://weblogs.asp.net/scot... http://msdn.microsoft.com/a... ......

Possible Cause:- When you install IIS AFTER .NET 2.0 framework, the rights of the ASPNET user had not been set correctly. Resolution Repair (Uninstall if repair does not work for you) .NET Framework 2.0 Simply run the following from command line to reset the IIS registry settings for aspnet user. Usually framework directory for .Net Framework 2.0 resides ......

Javascript <script language="javascript" type="text/javascript"> function ConfirmDelete() { if(confirm("Do you really want to Delete the Abused Record?")==true) { return true; } document.getElementById('&l... return false; } function ClearMessageLabel() { var msg=document.getElementById... ......

Copyright © Gaurav Taneja | Powered by: GeeksWithBlogs.net