String Format in SQL

2010-03-19T05:42:50.0000000-05:00

Using This sql Function We can Use String In sql FunctionDROP FUNCTION dbo.fnFormatStringGOCREATE FUNCTION dbo.fnFormatString(@format varchar(6000), @arg1 sql_variant, @arg2 sql_variant='''', @arg3 sql_variant='''')RETURNS varchar(8000)ASBEGINRETURN REPLACE( &n

List All the Tables for All Databases Using System Tables-SqlServer

2010-03-17T10:51:54.0000000-05:00

copy and paste the below script in Sql Query Analyzer and run it sp_msforeachdb ''select "?" AS db, * from [?].sys.tables''

How to get a last inserted record or Row from a table without using any Id column?

2010-03-16T05:48:48.0000000-05:00

Below is my data which is present in a table: insert into dupemp(name,salary,deptno) values(''1sd'',4000,12)insert into dupemp(name,salary,deptno) values(''2sd'',4000,12)insert into dupemp(name,salary,deptno) values(''3sd'',4000,12)insert into dupemp(name,salary,deptno) values(''6sd'',4000,12)insert into dupemp(name,salary,deptno) values(''4sd'',4000,12)

Calculating the Size of folder

2010-03-15T05:21:41.0000000-05:00

Private Function GetFolderSize(ByVal FolderName As String) As Long Dim d As New DirectoryInfo(FolderName) Dim TotalSize As Long = 0 For Each s As String In Directory.GetFiles(d.FullName, "*.*", SearchOption.AllDirectories) TotalSize += New FileInfo(s).Length N

Difference between Length() and DataLength() using SqlServer?

2010-03-14T10:18:37.0000000-05:00

Difference between Length() and DataLength() ? Len( ):- Length function return the number of Characters of the specified string expression,excluding blank spaces.

How to Delete a Repeting(or)duplicate records from a Table using SqlServer?

2010-03-14T10:05:47.0000000-05:00

create table dupemp(name varchar(20),salary int,deptno int) insert into dupemp(name,salary,deptno) values(''inthiyaaz'',2000,10)insert into dupemp(name,salary,deptno) values(''inthiyaaz'',2000,10)insert into dupemp(name,salary,deptno) values(''inthiyaaz'',2000,10)insert into dupemp(name,salary,deptno) values(''inthiyaaz'',2000,10)insert int

Get the height and width using JQuery

2010-03-11T18:41:15.0000000-06:00

if you would like to get the height and with of an element of HTML or asp.net control at the run time using JQuery than you can use height() for height and width() function to get width.Lets see an example to get height$("#myDiv").height();// this will give you the heightand to get the width of an element$("#myDiv").width(); // this will give width of an html object

Error: Failed to access IIS metabase and solution

2010-03-11T18:28:35.0000000-06:00
If you are getting error Failed to access IIS metabase ASP.NET while running asp.net website. Then you have to re register the asp_net to correct ISAPI mapping of the dll in IIS.To solve this error you have to open visual studio command prompt from start menu then typeaspnet_regiis -iand hit enterThis will solve the error Failed to access IIS metabase ASP.NET that you are getting to run asp.net website

open PopUp Window in a button click

2010-03-11T05:01:45.0000000-06:00
JavaScript code to open popup window:Method1:<SCRIPT LANGUAGE=''JAVASCRIPT'' TYPE=''TEXT/JAVASCRIPT''> <!-- var popupWindow=null; function popup(mypage,myname,w,h,pos,infocus){ if (pos == ''random'') {LeftPosition=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;TopPosition=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;} else {LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosi

add remove items from one listbox to another using JQuery

2010-03-10T18:21:55.0000000-06:00
Sometime in the web application we need to have functionality like move items between two listboxes in asp.net. Here is the solution using JQuery to Add, AddAll, Remove, RemoveAll items from one list box to another. We are using Jquery appnedTo() method to move the items between two listboxes. here is syntax to use appendTo if you want to move all items $("#fromListBox option").appendTo("#toListBox");

DotNetSparkCode