URL Rewriting with URLRewriter.Net Simplest Way

URL Rewriting with URLRewriter.Net Simplest Way

Primary Keys without clustered indexes

sql-server-primary-keys-without-clustered-indexes

What-is-Facebooks-architecture

Facebooks architecture

WCF Tutorials

OverLoading in WebServices and WCF

for WCF: method-overloading-in-wcf

for WebServices: method-overloading-in-WebServices

Binding Generic List<> Class to the Gridview using DataReader or Datatable

Here now we will fetch the data of a table from Database and bind it to Gridview using ListClass.

First Create a Class

public class Buzz
    {
        private string title;


        public string Title
        {
            get { return title; }
            set { title = value; }
        }


        private string desc;


        public string Desc
        {
            get { return desc; }
            set { desc = value; }
        }
    }


    public class BuzzList : List<Buzz>
    { }


In the above Class Buzz,it takes to members title and description.And also we can see another class BuzzList which is inherited from List<Buzz>


Now in the PageLoad

SqlConnection con = new SqlConnection("ur db connectionstring parameters");
 SqlCommand cmd = new MySqlCommand("select * from BUZZ", con);
 //BUZZ is the table in Database
  con.Open();
        try
        {
            BuzzList objBuzzList = new BuzzList();
            
           SqlDataReader dr = cmd.ExecuteReader();


            while (dr.Read())
            {
                Buzz objBuzz = new Buzz();


             objBuzz.Title = dr["TITLE"].ToString(); 
            //TITLE is the Column in BUZZ table
             objBuzz.Desc = dr["DESCRIPTION"].ToString();
            //DESCRIPTION is the Column in BUZZ table


                objBuzzList.Add(objBuzz);
            }


            GridView1.DataSource = objBuzzList;
            GridView1.DataBind();
        }

Differences Between Procedures and Functions

http://www.c-sharpcorner.com/uploadfile/skumaar_mca/differences-between-procedures-and-functions/

Understanding .NET Framework at a glance

http://www.c-sharpcorner.com/UploadFile/chandrakantpp/UnderstandingFrameworkatglance11292005013851AM/UnderstandingFrameworkatglance.aspx

Views in SqlServer

SQL Server excludes an ORDER BY clause from a view to comply with the
ANSI SQL-92 standard. The only time that SQL Server supports an ORDER BY clause in a view is when it is used in conjunction with the TOP keyword. Note that the TOP keyword
is a SQL Server extension to the ANSI SQL-92 standard.
Source: http://dotnetguts.blogspot.in/2007/08/faq-on-view-in-sql-server.html

Difference between ArrayList and List<>

basic-difference-between-arraylist-and-list

Learning RegularExpressions in c#

learning-regex-regular-expression-the-easy-way