Posts

Showing posts from November, 2022

DotNet Database Development

 *****DATABASE CONNECTIVITY(MIMP)***** HOW TO CONNECT DATABASE IN WEB APPLICATION :- file-> new website->c# -> asp.net empty website->browse->folder name  there are two concept used in data base connectivity  1.connectivity step 2.code step 1.connectivity step step 1:-include data base library    i.sql server -> sqlclient ii.xml -> xml iii.msaccess/exel->oledb how to include library:- syntax:- using system.data.libraryname; step 2:- createdatabase object(before the page load) 1.connection object->connection object is representinng database location. sqlconnection objname; sqlconnection cn; 2.sqlcommand object->sqlcommand objectb represent all query(insert,update,delete,select) sqlcommand objname; sqlcommand cm; 3.sqldatareader object->only use reading data from database.It only used select query. sqldatareader objname; sqldatareader dr; step 3:-break the page reloading process we have to use page load event if(!ispostb...