I m BACK with bang sorry for not made new articles in recent days, actually reason i was working on new project which  difficult so i have not found time anyways when i was working on the project i have found few websites which are only open for particular countries also same time one of my friend told me that in their company few websites are locked you can`t access list of websites.

so friends here is the best solution , you can use proxy server website to access any website in any environment.

Please check here is few list of websites which i like it all the websites are proxy servers.

1)HideMyAss

2)number1proxy

3)Unblocked

4)BoratProxy

5)SiteSurf

6)ProxyBuddy

7)LimitKiller

HideMy

9)Proxrio

10)CantBustMe

Here is few more link please copy and paste in browser.

http://www.highspeedproxy.info/
http://www.guardtunnel.com/
http://www.totalnetprivacy.com/
http://hidetosurf.co.cc/
http://www.freeproxy.ca/
http://hide-me.co.tv/
http://money2cash.info/
http://unblockit.biz/
http://www.bypassschoolblocks.info/
http://moneydating.info/

Enjoy the list of proxy websites.

Just before one day i got one request from my client he wants to compare two database tables which located on the two different servers.

i thought how can i do this with sql server and i found one terrific solution to achieve same task. so all the sql server programmers and .net programmers who stuck on same issue here is the solution for you guys.

i take one example to describe you how can you do with a simple query or store procedure,

i have two servers first server name is A2 and second server name is A4 in both the server there are two different database A2 has the database name UserCatalog and second server A4 has the database name CatalogRequests.

Now both the database has different tables name. first UserCatalog has the table name is tb_user and second database CatalogRequests has the table name is tb_catalog.

now both the table have the conman field which is rowid.

the requirement is compare both the tables and get the values from tb_catalog and not in the tb_user table.

here is the query to achieve same task which describes you above.

select * from A4.CatalogRequests..tb_catalog where rowid Not In (Select rowid from A2.UserCatalog ..tb_User) order by rowid desc;

so here is the description what above stuff mean.

to access different server with different database servername.databasename..tablename
make sure after database name when you write the table name in between use “..”

please reply me if you have any kind of suggestion or if you have any kind of problem.

Thanks in Advance.

Microsoft Release the Open source for the content management system or you can say is new blog engine name as Oxite.

Oxite is an open source, web standards compliant, blog engine built on ASP.NET MVC.

Oxite has the features like Commenting,Comment moderation,Tagging , Content pages etc i mean all the blog related stuff included in the Oxite.

Here is the link to download Oxite

ASP.NET MVC lets developers use ASP.NET to build Web applications using an architecture called model-view-controller. Microsoft released a preview of the ASP.NET MVC framework, designed to make it easier for developers to test applications, late last year.

so enjoy the Microsoft CMS system.

Now Recession is almost over and all we want to try to relocate or change our job in to MNC company.

so here is the links which will provides all the types of .net interview question which will helps all of us to get right job which we all wants.

Below is the list of all the websites which i like most.

link 1
link 2
link 3
link 4
link 5
link 6
link 7
link 8
link 9
link 10
link 11
link 12
link 13
link 14
link15
link 16
link 17

Below links for the sql server Interview questions.

link 1
link 2
link 3

Enjoy the questions.
Best of luck for the interviews.

Recently few of my friends was looking for a job during them interviews one comman question asked to them is the get or find the Nth value form the any table like Employee table.

so here is the one query which will give you Nth value from the employee table.

1) SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

2) Select top 1 Name, Salary From Employees Where Salary Not In (Select Distinct Top 4 Salary From Employees order by Salary desc) order by Salary desc

3) SELECT TOP 1 Mark FROM (SELECT TOP {N} Mark FROM Student ORDER BY Mark DESC) AS E ORDER BY Mark ASC

Where {N}= 2,3,4,5 etc

Eg: For 4th Highest Mark {N}=4

Enjoy friends

Now a days i m  working in one project where i need to add textbox at run time when user will press button add new field then one textbox will add on the page with validation control for same textbox after user will fill those new added textboxes and press save i want to all the new added textboxes values run time and save in the database.

i m giving you code where not just textbox but you can find any web control in one page.

First add below code in the aspx page.

<asp:Table ID=”tblText” runat=”server”>
</asp:Table>

then add this code on the button click

Sub AddControlsForTextbox(ByVal name As String)
Dim newrow As New TableRow
Dim newcell As New TableCell
Dim newtextbox As New TextBox
Dim req1 As New RequiredFieldValidator
newtextbox.ID = “txt” & name
req1.ControlToValidate = “txt” & name
req1.ErrorMessage = ” Please Enter Value In  ” & name
req1.Display = ValidatorDisplay.Dynamic
Dim lbl As New Label
lbl.Text = name & ” :  ”

End Sub

then when user click on save button get the textbox values for that you have to get all the textboxes which is currently appearing on the page.

please use below code for above condition

Private Sub processTextbox()
For Each ctrl As Control In Page.Controls
If TypeOf ctrl Is TextBox Then
‘do something here
Else
‘do something here
End If
Next
End Sub

Enjoy the coding

same way i check textbox in one page you can check for any control just replace the textbox to any other control.

please let me know if you have any kind of problem in this code.

Now a days in any web appication comman request made by clients is the generates a thumbnail for any product image or user profile image so here is the solution for the generates thumbnail on fly when admin or user add any image.

Private Function GetThumbnailView(ByVal originalImagePath As String, ByVal height As Integer, ByVal width As Integer) As String
‘Consider Image is stored at path like “ProductImage\\Product1.jpg”

‘Now we have created one another folder ProductThumbnail to store thumbnail image of product.
‘So let name of image be same, just change the FolderName while storing image.
Dim thumbnailImagePath As String = originalImagePath.Replace(”ProductImage”, “ProductThumbnail”)
‘If thumbnail Image is not available, generate it.
If Not System.IO.File.Exists(Server.MapPath(thumbnailImagePath)) Then
Dim imThumbnailImage As System.Drawing.Image
Dim OriginalImage As System.Drawing.Image = System.Drawing.Image.FromFile(Server.MapPath(originalImagePath))
imThumbnailImage = OriginalImage.GetThumbnailImage(width, height, New System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback), IntPtr.Zero)
imThumbnailImage.Save(Server.MapPath(thumbnailImagePath), System.Drawing.Imaging.ImageFormat.Jpeg)

imThumbnailImage.Dispose()
OriginalImage.Dispose()
End If
Return thumbnailImagePath
End Function

Public Function ThumbnailCallback() As Boolean
Return False
End Function

Call this function like

GetThumbnailView(”ProductImage\Product1.jpg”, 100, 100)

Enjoy Friends.

in this article i will give you solution which i was finding since 1 year.

normally when we crate any web application project we use the app_code folder to generate single assembly in which all the files in the App_Code folder must be in the same programming language.

but sometimes i feel that if in some complex things i need c# code file and some times i need that i want vb file for the string manupulation and all that so can i place both the languages in same app_code folder.

here is the solution for this complex question

1) Create two folders in App_Code folder name as “CSCODE” and “VBCODE” place c# files in the cscode folder abd vb code files in vbcode folder.

2)add below code in the wb.config file

<compilation debug=”false”>
    <codeSubDirectories>
        <add directoryName=”VBCode” />
        <add directoryName=”CSCode” />
    </codeSubDirectories>
</compilation>

Now please built the website.

Enjoy the code
please reply me on the same post if it will works for you.

i was worked on one problem where i want some place session value in javascript and some place i want database value in javascript code.

so for these all i need i found one simple method for reading any server side values in javascript.

here is the few examples for reading server side values in javascript code.

1) var username=’<%=Session["username"]%>’;

2) var productid=’<%=Response.querystring["pid"]%>’;

lots of people now days i found in internet who still finding a sites which give the functionality to do free sms in whole india.

so here the few lits of sites which provides free sms in whole india please find the links and enjoy it

youmint
way2sms
160by2
sms2mms
indyarocks
atrochatro
sendsmsnow
smsseva

Enjoy Friends please reply on this post if you will link all the links