title: How to connect to Database in C# web application
body: <p>I am working in C++ from last four years, and suddenly i am assigned a task to develop a sample web application whose purpose is to fetch data from a sample table and show it in a grid view.</p>
  
  <h1>About Sample Application:</h1>
  
  <p>The application is developed in Visual web Developer 2010under Framework 4.0, using ASP.net with C#.
  The backend database is developed in MS SQL Server 2008</p>
  
  <h1>My Approach:</h1>
  
  <p>Since, i am new to .net world. So i surf over internet and found the typed data set (the most  easier way, i.e using wizards rather than coding) and hence i use type dataset for database connectivity.</p>
  
  <h1>My Question:</h1>
  
  <p>I have faced lot of criticism for using typed data sets :(.  Some one say its not efficent, some one say its harder to extend . . . and so on :(
  Now i only want to ask that what is the best way of making database connectivity (especially, for large scale project). I am only asking this because i an new to this field. However i study from internet and found the another way through coding i.e There exist classes for each thing (DataSet, DataTable, DataRow, Connection etc.). Is it better way? or there exist some thing else.
  Some sample code or a web resource guiding how to do this would be more helpful</p>