Skip to main content

Topics covered in Blog

Horizontal Image Scroller!
Expand and collapse through javascripts!
How to generate the dynamic rad menu !
How can you implement tree structure with checkboxes!
Count the Original dimensions of uploaded image ?
Minimum and Maximum Character Validation on Input.
how to control "page refresh" in asp.net page
code to get virtual path of current application directory c#
Image Randomizer in Asp.Net!
How to download file in c#
Change the Color of a gridview's row based on some condition!
How to set the operation on the basis of records checked and unchecked in the gridview!
Controls disable while Page loads!
SEND A PDF FILE AS AN ATTACHEMENT OF MAIL!
How To Convert a txt file to pdf fILE
Configure MSDE: Installation/Server Setup, Database Creation/Backup/Restore/Deletion using OSQL
Last modified datatime of a table!
Find the IP of visitors machine!
Create a CMS through Umbraco open source tools!
Tiny MCE Editor
How To generate a Xml File through Asp.Net Coding.
Javascript code to show the Remaining character in the text box!
Physical path of File & URl of Browser
SQL Table Ownership Changes(Change the Owner of the already created database With Sql Commands)
Enabling Database Mail on SQL Server Express !
Clear the Transaction log files in the Sql server
How to Delete duplicate rows from a table?
How to ReIndex Your DataBase?
How to take backup of database and place them on your Disk with a query
Action in Sql server 2005
Date and Time Functions in SQL server.
Function inn Sql Server
Email Functionality in the Sql Server 2005
Backup Database using a Query!
HTML in a mail!
Select n rows froms table excluding top row
Maxium Coumns in a table
Custom Paging Sorting!
Image Upload!
URL Rewritting
Indexes in Sqlserver!

Comments

Post a Comment

Popular posts from this blog

URL Rewritting

http://www.simple-talk.com/dotnet/asp.net/a-complete-url-rewriting-solution-for-asp.net-2.0/ http://msdn.microsoft.com/en-us/library/ms972974.aspx URL Rewriting in ASP.NET Summary: Examines how to perform dynamic URL rewriting with Microsoft ASP.NET. URL rewriting is the process of intercepting an incoming Web request and automatically redirecting it to a different URL. Discusses the various techniques for implementing URL rewriting, and examines real-world scenarios of URL rewriting. (31 printed pages) Download the source code for this article. Contents Introduction Common Uses of URL Rewriting What Happens When a Request Reaches IIS Implementing URL Rewriting Building a URL Rewriting Engine Performing Simple URL Rewriting with the URL Rewriting Engine Creating Truly "Hackable" URLs Conclusion Related Books Introduction Take a moment to look at some of the URLs on your website. Do you find URLs like http://yoursite.com/info/dispEmployeeInfo.aspx?EmpID=459-099&type=summ...
Post a Comment
Read more

SEND A PDF FILE AS AN ATTACHEMENT OF MAIL!

System.Net.Mail.MailMessage m1 = new System.Net.Mail.MailMessage(); m1.From = "manpreet@gmail.com" m1.Subject = "Test mail "; m1.Body = str.ToString(); m1.IsBodyHtml = true; m1.To.Add("jasdeep@gmail.com"); m1.CC.Add("jasdeep123@gmail.com"); m1.Attachments.Add(new Attachment(strserverpath + @"\pdf\" + PdfFileName)); smtp.Send(m1);
Post a Comment
Read more

Sql Server Tips

IF WE WANT TO SELECT  TOP N ROWS  FROM A TABLE ,  WE USE THE FETCH NEXT  SELECT    * FROM  table1   ---//First m rows ignore first n rows ORDER BY id OFFSET n ROWS FETCH NEXT m ROWS ONLY if n=0, m=10 then first  10 rows if n=10, m=10 then first  10 rows start from 11th row Row_number()   SELECT  ROW_NUMBER() OVER(order by db.id) Insertion Simultaneouly in temp table with output clause DECLARE @table1 table (   Id int,   name nvarchar(50) ); DECLARE @table2 table (  Id int,  name nvarchar(50) ); INSERT INTO @table2 OUTPUT INSERTED.*   INTO @table1   select top 10 id, name  from FinalTable SELECT * FROM @table2; SELECT * FROM @table1;
Post a Comment
Read more