Get code in C# at SQL to call a Stored Procedure from C#

you will have to create the procedure written below and run it by passing any Stored Procedure name as a parameter in it .. it will give u code in c# to use that procedure in sql output.=======================================CREATE PROCEDURE CS_Code_Generator(@objName nvarchar(100))AS/*___________________________________________________________________Name: CS Code GeneratorVersion: 1Date: 13/02/2009Author: Rajesh...

Read More

Primary Keys: IDs versus GUIDs

Primary Keys: IDs versus GUIDsPersonally i love uniqueidentifier in which, every unique item waiting to be born.Perhaps that's why I read with great interest recent accounts of people switching their database tables from traditional integer primary keys ...ID Value-- ----- 1 Apple 2 Orange 3 Pear 4 Mango.. to GUID keys.ID Value------------------------------------ -----C87FC84A-EE47-47EE-842C-29E969AC5131...

Read More

set the session expireation time in web.config file

open web.config file of your web applicationyou will have tu set sessionstate timeout = value in minuts like below example....< configuration > < system.web > < sessionState mode="InProc" cookieless="true" timeout="20"/ > < /sessionState > < /system.web >< /configuration &g...

Read More

getting Query-String Values From Javascript

Getting Query-String Values From Javascriptscript type="text/javascript">function GetQueryStrValFor(key){var returnval="";var query = window.location.search.substring(1);var parms = query.split('&');for(var i=0 to parms.length){ var pos = parms[i].indexOf('=');if (pos > 0){if(key==parms[i].substring(0,pos)){returnval= parms[i].substring(pos+1);}}}return returnval;}script&g...

Read More

Invalid Operation Exception when u not run program

to remove above error .....go to solution explorer and check resource folder.. exclude it and then include it again....

Read More