20 August 2012

persistedselection property for a gridview control in asp

›
You can specify how row selection is persisted when the GridView control is in paging mode. By default, row selection is persisted by row in...

datarow to dataset in asp

›
DataTable dt = (DataTable)ViewState["tabData"]; DataRow[] dr = dt.Select("test_cd='899'"); DataSet dsnew = new D...
15 August 2012

Query to attaching of database using only .mdf file without associated log file

›
CREATE DATABASE ... FOR ATTACH_REBUILD_LOG with log file: CREATE DATABASE ... FOR ATTACH

Order of the sqlquery that logically processed

›
What is the order of execution in the following list? select from where group by order by having A: from,where,group by,having,s...

Rename/Alter the column for a table in sqlserver

›
To add new column: Alter Table TableName add ColName dataType To alter a column: Alter Table TableName Alter Column ColumnName DataType NULL...
14 August 2012

can u set innerjoin for update command?

›
Update Employee set State = s.StateID   from Employee e   inner join State s on e.State = s.StateName

Decide whether i/p parameter contains integers or not in sqlserver

›
IF PATINDEX('%[0-9]%',@val) > 0   print 'i/p value contain integer' else print 'Not contain integer'
13 August 2012

Insert records (multiple) into a table using single query in sqlserver

›
create table tblEmp (eid int, ename varchar(20), estatus bit) sqlserver2005 basic: insert into tblEmp values (0,'emp', 'True...
22 July 2012

SQL Command Types

›
DDL is Data Definition Language statements. Some examples: CREATE - to create objects in the database ALTER - alters the structure of th...

select distinct of rows from a table of multiple duplicate columns

›
create table emp(empid int,empname varchar(50),sal money,status bit) insert into emp select 1,'satya',20000,1 union all select 1,...
16 July 2012

array conversions

›
using System; using System.Collections.Generic; --------------------------- arraylist to array > string[] a = (string[])arraylist.toarray...
15 July 2012

General Page Life-Cycle Event Stages

›
The events occur in the following sequence. Its best to turn on tracing(<% @Page Trace=”true”%>) and track the flow of events : PageRe...
09 July 2012

convertion differences between Convert.ToInt32 and int.Parse

›
int.Parse("12") --> 12 int.Parse("12.12") --> Format Ex int.Parse(null) --> Null Ex int.Parse("88970888888...
28 June 2012

clear all cotrol values of a page

›
<script type="text/javascript">     function allclear()     {    //debugger         var elements=document.getElementsByTagNa...

make listbox items colorful

›
protected void Page_PreRender(object sender, EventArgs e) {     bool flag=false;     foreach (ListItem li in ListBox1.Items)     {         i...