Rapid development of vs.net + c # programs (-)

1. Existing database (SQL) tables to quickly generate tools for corresponding stored procedures. SQLPilot.exe
SQLPilot.exe this program is written by a friend of CCF, please refer to the http://bbs.et8.net/bbs/showthread.php? T = 534183
Ii. tools for generating a list, basic query, advanced query, inserting a new row, deleting and editing the asp.net page using existing database tables Asp. Net Maker
Http://www.hkvstore.com/aspnetmaker/
1. Database Operations
The following code is C:
Header file:
Using System; using System. Web. UI; using System. Globalization; using System. Data; using System. Data. SqlClient; namespace ns_db {public class c_db: UserControl {
// ******************************* // Return the database connection string //********************************
Public string ewConnStr () {return "Password = *****; Persist Security Info = True; User ID = sa; Initial Catalog = ******; data Source =
(Local) ";} // End ewConnStr
//************************************** * ************* // Return a DataView according to Connection String & SQL //************ **************************************** **
Public DataView ewDataView (string sConn, string sSQL) {try {
// Create a new Connection Object SqlConnection oConn = new SqlConnection (sConn );
// Create a new DataAdapter using the Connection Object and SQL statement SqlDataAdapter oDa = new SqlDataAdapter (sSQL, oConn );
// Create a new DataSet Object to fill with Data DataSet oDs = new DataSet ();