Thursday, October 30, 2008

HTC TOUCH : Reviews and Price

HTC touch is a great smart phone.It has latest windows mobile operating system.It has all the applications like word,ppt,excel,you can send emails.it has a 2 mega pixel camera and a very unique touch flow.1 gb memory card which is expandable upto 4 gb.
Reliable $1 Web Hosting by 3iX

Lots of great features.a must buy phone if you are looking for a cheap smartphone.In india its costs around rs 15k.

Feel free to post your reviews here....

Thursday, October 23, 2008

GoDaddy Reviews:GoDaddy Web Hosting Review

Webmaters,

if you are looking to get hosting from godaddy.com please think twice before getting a web hosting account from them.Their support is very bad...they always say..this is a coding or 3rd party scripting issue and we can not help.I have atleast 3-4 sites and everyone has some problem.If you are taking windows hosting..pls keep in mind they do not provide remote access to sql server.You have to use their sql server web admin which i feel is not good.so....think twice before going with godaddy.

I will recommend using 3ix...they have very cheap hosting..they have $1 web hosting packages and $3 web hosting packages.They have very good support.I have 2 personal sites with them check below

Reliable $1 Web Hosting by 3iX

Tuesday, October 21, 2008

SRS: Sample SRS Templates

1.Background

This document describes the requirements necessary for the Software Project.

2.Scope

Explain what the software product will do

3.Software Requirement Specification
3.1. System scope

list all the features for which specifications must be created, designed, coded and tested as part of the project.>

3.2. Definitions, Acronyms, Abbreviations

The following is a list of commonly used definitions used throughout this document

5. UI Prototype (Optional)

Attach screen shots and explain control flow.

Reliable $1 Web Hosting by 3iX



6. Assumptions and Dependencies

State any known assumptions and dependencies

7. Non-Functional Requirements

7.1. Environmental Requirements

Hardware and Software requirements

7.2. System Performance Requirements

7.3. Security


7.4. Design and Implementation Constraints

7.5. Standards


8. Evisioned Future Enhancements / Open Issues


9. References

10. Annexures

Friday, October 17, 2008

How to change owner of object/Stored Procedure

to change owner of object/Stored Procedure

exec sp_changeobjectowner 'objectname','username'

for example

exec sp_changeobjectowner 'proc_getallrecords','dbo'

Grant Execute Permission to User in Database:Sql Servers

---Stored Procedure to grant execute permission to user on all stored procedures

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGrantExectoAllStoredProcs] @user sysname

AS
/

SET NOCOUNT ON



DECLARE @CMD1 varchar(8000)

DECLARE @MAXOID int

DECLARE @OwnerName varchar(128)

DECLARE @ObjectName varchar(128)



CREATE TABLE #StoredProcedures

(OID int IDENTITY (1,1),

StoredProcOwner varchar(128) NOT NULL,

StoredProcName varchar(128) NOT NULL)



INSERT INTO #StoredProcedures (StoredProcOwner, StoredProcName)

SELECT u.[Name], o.[Name]

FROM dbo.sysobjects o

INNER JOIN dbo.sysusers u

ON o.uid = u.uid

WHERE o.Type = 'P'

AND o.[Name] NOT LIKE 'dt_%'


SELECT @MAXOID = MAX(OID) FROM #StoredProcedures



WHILE @MAXOID > 0

BEGIN



SELECT @OwnerName = StoredProcOwner,

@ObjectName = StoredProcName

FROM #StoredProcedures

WHERE OID = @MAXOID



SELECT @CMD1 = 'GRANT EXEC ON ' + '[' + @OwnerName + ']' + '.' + '[' + @ObjectName + ']' + ' TO ' + @user


EXEC(@CMD1)



SET @MAXOID = @MAXOID - 1

END



DROP TABLE #StoredProcedures

SET NOCOUNT OFF

Monday, October 13, 2008

code for 301 redirect pages with querystring using asp.net/c#

if you have a page with query string and you want to redirect it using asp.net please check the code below..

string c_absUri = Request.Url.DnsSafeHost;
string c_absPath = Request.Url.AbsolutePath;
//c_absPath = "/test.aspx";

string c_queryString = Request.QueryString.ToString().Length > 0 ? Request.QueryString.ToString() : String.Empty;


if (c_queryString.Contains("sname=")) //where sname is querystring
{

Int32 Countqry = 0;
Int32 qrylength = 0;
qrylength = c_queryString.Length;

Countqry = c_queryString.LastIndexOf("=");
Int32 rem = qrylength - Countqry;


string sname = c_queryString.Substring(Countqry + 1, rem - 1);

sname = sname.Replace("*", "&");
sname = sname.Replace("+", " ");




string newUrl = "http://www.abc.com" + c_absPath;

HttpContext context = HttpContext.Current;
context.Response.Status = "301 Moved Permanently";
context.Response.StatusCode = 301;
context.Response.AddHeader("Location", newUrl);



Response.Redirect(newUrl);
}

Code for 301 Redirect using c#/ASP.NET

if you want to do a 301 permanent redirect using asp.net and c# copy and paste the code in ur global.asax file.

protected void Application_BeginRequest(object sender, EventArgs e)
{
string newpath = "";
string newpath1 = "";


string sOldPath = HttpContext.Current.Request.Url.ToString();
sOldPath =sOldPath.Substring(sOldPath.LastIndexOf("/")+1);
//
if(sOldPath=="Online.aspx")
{
newpath = "http://www.the.com/online-degree.aspx";
HttpApplication app = sender as HttpApplication;

app.Context.Response.RedirectLocation = newpath.ToString();
app.Context.Response.StatusCode = 301;
app.Context.Response.End();

}}

if you have any questions on doing a 301 redirect please let me know.