ScriptManager
A server control that makes script resources available to the browser, including the Microsoft AJAX Library and the functionality that enables partial-page rendering.
ScriptManagerProxy
A server control that enables nested components to add script and service references if the page already contains a ScriptManager contro...
Thursday, October 29, 2009
What is Use of Scriptmanager in asp.net AJAX
The ScriptManager control manages client script for Microsoft ASP.NET AJAX pages. By default, the ScriptManager control registers the script for the Microsoft AJAX Library with the page. This enables client script to use the type system extensions and to support features such as partial-page rendering and Web-service calls.BackgroundWhen a page contains one or more UpdatePanel controls, the ScriptManager control manages partial-page...
Friday, October 23, 2009
What is the CHECK constraint in SQL Server?
Business rule validation can be applied to a table by using CHECK constraint. CHECK constraint must be specified as a logical expression that evaluates either to TRUE or FALSE.A CHECK constraint takes longer to execute as compared to NOT NULL, PRIMARY KEY, FOREIGN KEY or UNIQUE constraints. Thus CHECK constraint must be avoided if the constraint can de defined using NOT NULL, PRIMARY KEY, FOREIGN KEY constraint...
What are the types of constraints in SQL Server?
There are three types of constraints in SQL Server -1. Domain Constraint - deals with one are more columns. 2. Entity Constraint - are all about individual rows. 2. Referential Integrity Constraint - are created when a value in one column must match the value in another column - in either the same table or in a different tabl...
What is the DEFAULT constraint in SQL Server?
A DEFAULT constraint, like all constraints, becomes an integral part of the table definition. It defines what to do when new row is inserted that does not include data for the column on which you have defined the DEFAULT constraint. You can either define it as a literal value(like default salary to zero or UNKNOWN for a string column) or as one of several values such as GETDATE().The main things to understand about a DEFAULT...
How to find out column names and their datatypes in a given table using a query in SQL Server?
Using the table tablename, write the query as follows - Select * from information_schema.columns where table_name = tablena...
What is the DEADLOCK ?
A deadlock is a situation in which two transactions conflict with each other and the only resolution is to cancel one transactio...
What is a Subquery ?
A Subquery is a normal T-SQL query that is nested inside another query. They are created using parentheses when you have a SELECT statement that serve as the basis for the either part of the data or the condition in another query.Subqueries are generally used to fill one of couple of needs -1. Break a query up into a series of a logical steps. 2. Provide a listing to be the target of a WHERE clause together with [IN|ESISTS|ANY|ALL]....
What is the EXISTS operator in SQL Server ? OR What is the EXISTS keyword in SQL Server ?
When you use EXISTS, you do not really returned data - instead you return a simple TRUE/FALSE regarding the existence of data that meets the criteria established in the query that the EXISTS statement is operated against.EXISTS simply test whether the inner query returns any row. If it does, then the outer query proceeds, if not, the outer query does not executes, and the entire SQL statement returns nothing.The EXISTS condition...
How to find nth highest salary from Employee table in SQL Server?
SELECT TOP 1 salary FROM (SELECT DISTINCT TOP n salary FROM employee ORDER BY salary DESC) a ORDER BY sala...
How to convert timestamp data to date data (datetime datatype) in SQL Server?
The name timestamp is a little misleading. Timestamp data has nothing to do with dates and times and can not be converted to date data. A timestamp is a unique number within the database and is equivalent to a binary(8)/varbinary(8) datatype. A table can have only one timestamp column. Timestamp value of a row changes with every update of the row. To avoid the confusion, SQL Server 2000 introduced a synonym to timestamp, called...
What is the IDENTITY property in SQL Server?
The IDENTITY property enables you to use system generated values in your tables column. It is similar to the auto number datatype in MS ACCESS. You are allowed a single column in each table with the IDENTITY property. Typically, IDENTITY column generates system assigned keys. To enforce entity integrity, you must uniquely identify each row in a table. If no natural column or set of column does this, you might went to create an...
What is the CASCADE action in SQL Server?
By default, you can not delete a record or update the referenced column in a referenced table if that record is referenced from the dependent table. If you want to be able to delete or update such records, then you need to set up a CASCADE action for the delete and/or updat...
What is the FOREIGN KEY in SQL Server?
FOREIGN KEYs are both a method of ensuring data integrity and a manifestation of the relationships between tables. When you add a FOREIGN KEY to a table, you create a dependency between the table for which you define the FOREIGN KEY (the referencing table) and the table your FOREIGN KEY references (the referred table). After adding a FOREIGN KEY, any record you insert into the referencing table must have a matching record in...
What is the use of CASCADE CONSTRAINTS?
When this clause is used with the DROP command, a parent table can be dropped even when a child table exist...
Get Current System Date Format
To get short date pattern of your system:messagebox.show(System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern())To get long date pattern of your system:messagebox.show(System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.LongDatePattern(...
Change Format of Date in VB.NET
Dim departDate As DatedepartDate = Date.NowDim d As String = Format(departDate, "dd/MM/yyyy")MsgBox(d)'Above Example shows how to convert date format according to our requirement...
Tuesday, October 20, 2009
Restricting numeric entries only in a DataGridView column
At times we have a requirement where we need to restrict the user to enter only numbers in a column of a DataGridView to achieve this we need to use EditingControlShowing event of DataGridView, this event is new in .Net framework 2.0 and it occurs when a control for editing a cell is showing. Following sample shows a implementation of it:private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs...
Tuesday, October 13, 2009
Transposing Column to Row Through Select Query
My student Mr. Bhupendra Asked me that how can i show values of my columns of table as a ROW. To do so: (we also require such query while creating cross-tab reportlets we have following table:CREATE TABLE [vehical_type]( [unqid] [uniqueidentifier] primary key, [vname] [varchar](100) NULL)we can get our desired result from below query:-- It will be better to create Stored Procedure of it.declare @st varchar(max)set @st='create...
Friday, October 9, 2009
How to set required field validator for dropdownlist
My colleague Sweta asked me to how to set required field validator for doopdownlist.so to set required field validator for doopdownlist we need to follow these steps.1. let your dropdown list in such format that first item of it is "--Select--" as in example give below.2. if your valumember is integer type then set value '0' of valuemamber for "--Select--"3. take required field validator and select your dropdownlist as control...
Tuesday, October 6, 2009
How to implement keyword "Limit" like functionality in MS SQL Server
select * from mytable limit 10, 20 the equivalent in MS SQL Server would be: select top 20 * from mytable where pk not in (select top 10 pk from mytable order by pk) order by ...
Evaluate Rows one by one
through qry written below we will get 1 record at a time and in random order.SELECT TOP 1 * FROM TabCountryMast ORDER BY newid...
Thursday, October 1, 2009
Create Control at runtime using JavaScript
through code written below we can create control at runtime using javascript< %@ Page Language="C#" AutoEventWireup="true" CodeFile="AddRemoveJavascript.aspx.cs" Inherits="AddRemoveJavascript" % >< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >< html xmlns="http://www.w3.org/1999/xhtml" >< head runat="server" > < title ><...
Subscribe to:
Posts (Atom)