PUBLIC CLASS DBMANAGE {PUBLIC DBMANAGE () {// // TODO: Add Constructor Logic //} Public SqlConnection getConnection () // Establish a database connection {SQLCONNECTION CN = New SQLConnection (); cn.connectionstring = system. Configuration.ConfigurationSettings.AppSettings [ "conn"]; cn.Open (); return cn;} public void delid (int intId, string strTable, SqlConnection cn) {SqlCommand DeleteCmd = new SqlCommand ( "delete from" strTable "where id = " intId, cn); DeleteCmd.ExecuteNonQuery ();} public void ExecuteSql (string strSql, SqlConnection cn) // sql command no return value {SqlCommand ExecuteCmd = new SqlCommand (strSql, cn); ExecuteCmd.ExecuteNonQuery ( EXECUTECMD.DISPOSPOSE ();
public void UpdateTb (string strTbName, string strFieldsName, string strValue, int intId, SqlConnection cn) {SqlCommand UpdateCmd = new SqlCommand ( "update strTbName set" strFieldsName "=" strValue "where Id =" intId.ToString (), cn); updateCmd.ExecuteNonQuery ();} public DataSet FillDs (string strSql, SqlConnection cn) {SqlDataAdapter FillDsAdapter = new SqlDataAdapter (strSql, cn); FillDsAdapter.SelectCommand.CommandType = CommandType.Text; DataSet ds = new DataSet (); FillDsAdapter.Fill (ds); FillDsAdapter.Dispose (); return ds;} public DataSet FillDs (string strSql, SqlConnection cn, string srcTable) {SqlDataAdapter FillDsAdapter = new SqlDataAdapter (strSql, cn); FillDsAdapter.SelectCommand.CommandType = CommandType. Text; DataSet ds = new DataSet (); FillDsAdapter.Fill (ds, srcTable); FillDsAdapter.Dispose (); return ds;} public string GetString (string strSql, SqlConnection cn) // Get string {string strGetString = "" SqlDataAdapter FillDsadapter = New SqlDataAdapter (STRS QL, CN); FillDsadapter.selectCommand.commandType = commandType.text; DataSet DS = New Dataset (); FillDsadapter.Fill (DS); if (ds.tables [0] .rows.count == 1) {strGetString = DS .Tables [0]. ROWS [0] [0] .tostring ();} else {strgetstring = null;} filldsadapter.dispose (); ds.dispose (); Return strGetstring;}
