How to fetch values from a table in sql database to web application

Question

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;} hi Friendsthere is one table is sql i.e Employee with 4 fields psno empname salary dobso I should write web application to edit that table and to update that table .. Please Help regarding this.. Thanks

Tulasi · Answer

Hi Use ADO.net concepts 1) use ado.net concepts to get data from DB 2) Bind it to Gridview 3) use UpdateCommandDeleteCommandEditCommand event have a look at this link http://csharpdotnetfreak.blogspot.com/2009/05/gridview-sqldatasource-insert-enew linkdit.html

Sam Hobbs · Answer

Note that you don't need to go to any other web site; this web site has very many very useful articles about use of databases.

Satishchandra TN · Answer

Hi Vidya .. Thanks for your Reply.. Its really worked.