Posts

Showing posts from 2011

Int32 notation vs. int

This not work. public  enum MyEnum : Int32 {     AEnum = 0 } This works. public enum MyEnum : int {     AEnum = 0 } because.... Int32 is class   enum expected only type int,long etc..which are designed. int is c# data type and Int32 is .net data type.

Asp.Net ShortCut Keys

Image
.NET ShortCut Keys   Ctrl + N Opens the New Project Dialogue Box Ctrl + Shift + O Opens the Open File Dialog Box Ctrl + Shift + A Opens Add New Item window Ctrl + D Opens Add Existing Item window Ctrl + S Saves Current Form Ctrl + Shift + S Saves everything from Application Alt + Q Exits Visual Studio. NET Ctrl + Z Undo Ctrl + Shift + Z Redo Ctrl + X Cuts your selection Ctrl + C Copies your selection Ctrl + V Pastes your selection Ctrl + A Selects All Del Deletes your selection Ctrl + F Opens Find window Ctrl + H Opens Find and Replace window Ctrl + Shift + H Opens Replace in Files window Ctrl + Alt + Shift + F12 Opens Find Symbol window F7 Opens Code Designer window Shift + F7 Gets you back to Design View Ctrl + R Opens the Solution Explorer window Ctrl + Alt + S Opens the Server Explorer window Ctrl + Shift + C Opens the Class View window F4 Opens the Properties window Ctrl + Shift + E Opens the Resource view window Ctrl + Alt + X Opens the Toolbar window Shift + Alt + Enter Ta...

If you want to implement fulltext on view you might readt it....

CREATE VIEW [dbo].[FetchStockInformation] WITH SCHEMABINDING AS SELECT     B.BrandName, I.ItemName, C.ItemCatName, S.SubCatName, I.ReOrderLevel, SUM(M.Qty) - SUM(PD.Qty) AS Qty FROM         dbo.tblmrnchild AS M INNER JOIN                       dbo.tblBrandMaster AS B ON B.BrandID = M.BrandId INNER JOIN                       dbo.tblItemMaster AS I ON M.ItemId = I.ItemID INNER JOIN                       dbo.tblCategoryMaster AS C ON M.CategoryId = C.ItemCatID LEFT OUTER JOIN                       dbo.tblSubCategory AS S ON S.SubCatID = M.SubCategoryId LEFT OUTER JOIN                       dbo.tblPurchaseDetailsByUser AS PD ON PD.ItemID = M.ItemId LEFT OUTER JOIN     ...

Validation in Asp.net Windows Application

static void  Main ()           {              Application.Run( new  SimpleValidation());          }          private void  txtName_Validating(object sender, System.ComponentModel.CancelEventArgs e)          {              if  (((TextBox)sender).Text ==  "" )              {                  MessageBox.Show( "You must enter a first and last name." ,  "Invalid Input" , MessageBoxButtons.OK, MessageBoxIcon.Warning);       ...

If you want union of two data table in asp.net then follow this.....

        public DataTable Union(DataTable First, DataTable Second)         {             //Result table             DataTable table = new DataTable("Union");             //Build new columns             DataColumn[] newcolumns = new DataColumn[First.Columns.Count];             for (int i = 0; i < First.Columns.Count; i++)             {                 newcolumns[i] = new DataColumn(                 First.Columns[i].ColumnName, First.C...

SQL SERVER – Find Stored Procedure Related to Table in Database

----Option 1 SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id = so.id WHERE sc. TEXT LIKE '%tablename%' ----Option 2 SELECT DISTINCT o.name , o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id = o.id WHERE c. TEXT LIKE '%tablename%'

If you want to pass table in form of XMLin asp.net

1st build xml data and pass it.... dt.TableName = "MyData"; using (StringWriter sw = new StringWriter())             {                 dt.WriteXml(sw);                 result = sw.ToString().Replace("NewDataSet", "DocumentElement");             } 2nd in proc you can get by select ...  SELECT  cast(colx.query('data(Column1) ') as nvarchar(max)) as Column1,         cast(colx.query('data(Column2) ' )as nvarchar(max)) as Column2,         cast(colx.query('data(Column3) ' )as nvarchar(max)) as Column3        into #Temp from @MyData1.nodes('DocumentElement/MyData') as Tabx(colx)

Register your PAN

www.incometaxindiaefiling.gov.in

unlock data card

http://techalites.com/2008/01/20/how-to-use-reliance-huawei-ec321-datacard-with-tata-indicom/

I fyou want to remain modelpopup even after postback then follow this link...

http://forums.asp.net/t/1186622.aspx

Firebug

https://addons.mozilla.org/en-US/firefox/addon/firebug/

Make income at home

http://indiannewsweekly.com/finance/fd.htm

Access Sql Helper

http://codepaste.net/gay1w6 http://www.sharpdeveloper.net/source/SqlHelper-Source-Code-cs.html

Best Pension Plan...............

Hi Friends, PFRDA introduced new pension scheme for non-govt employee. My request to all of you pls invest in this scheme. It is for you & your spouse's future , a day should not come that we should depend on any one . Pls start early to take the benefits for long term accumulation of wealth. You can start as little as Rs. 500 per month. If you are aged 25 year; retirement age 60 years; your investment Rs. 500 per month; You can have corpus of 31,46,084.48 after your retirement @ 12 % p.a. If you think, you start it latter then see the effect - If you are aged 35 year; retirement age 60 years; your investment Rs. 500 per month; You can have corpus of 9,29,090.4 after your retirement @ 12 % p.a. To achieve same return of Rs. 31.46 lakh, you have to invest Rs. 1700 per month. If you invest above corpus into annuity, you can receive Rs. 29969.89 per month for 15 years i.e. upto your age of 75 years & Rs. 26211.92 per month for 20 years i.e. your age o...
After Master’s degree in Computer Application from IGNOU,I have been in IT industry for 5 years.I’ve gained extensive experience in all aspects of software engineering, including software design,systems architecture, application programming, and QA testing.Currently I’m a sr. software engineer with "IGNIVA SOLUTIONS" and have worked on several software development projects for our clients. As the lead developer, I designed and developed a web-based Project Track system to help IGNIVA SOLUTIONS to increase productivity and better utilization of man hour's. I’m skilled in the latest techniques such as web services and SOA,proficient with the new languages like C#.   I’m always focused on building robust software systems to meet our customer’s needs. One of my major strengths is that I work very hard and continually look for ways to provide the highest quality products and services while reducing the time and costs to complete the project. I am self-motivated and en...