Websharp use Instructions (8)

Web dataaccess:





public Interface DataAccess





{





#region Support Property & Method





databasetype databasetype{get;}





idbconnection dbconnection{get;}





PersistenceManager persistencemanager{get;}





idbtransaction BeginTransaction ();





void Open ();





void Close ();





bool Isclosed{get;}











#endregion











#region ExecuteNonQuery











int ExecuteNonQuery (CommandType commandtype, string CommandText);





int ExecuteNonQuery (string commandtext);





int ExecuteNonQuery (string commandtext, Queryparametercollection commandparameters);





int ExecuteNonQuery (CommandType commandtype, string CommandText, Queryparametercollection commandparameters);











#endregion ExecuteNonQuery











#region ExecuteDataset











DataSet ExecuteDataset (CommandType commandtype, string CommandText);





DataSet ExecuteDataset (string commandtext);





DataSet ExecuteDataset (CommandType commandtype, string CommandText, Queryparametercollection commandParameters);





DataSet ExecuteDataset (String commandtext, Queryparametercollection commandparameters);











DataSet ExecuteDataset (CommandType commandtype, string commandtext,string tablename);





DataSet ExecuteDataset (string commandtext,string tablename);





DataSet ExecuteDataset (CommandType commandtype, string CommandText, Queryparametercollection commandparameters, String tablename);





DataSet ExecuteDataset (String commandtext, Queryparametercollection commandparameters,string tableName);











DataSet ExecuteDataset (CommandType commandtype, String Commandtext,dataset ds);





DataSet ExecuteDataset (String commandtext,dataset ds);





DataSet ExecuteDataset (CommandType commandtype, string CommandText, Queryparametercollection commandParameters, DataSet DS);





DataSet ExecuteDataset (String commandtext, Queryparametercollection commandparameters,dataset DS);











DataSet ExecuteDataset (CommandType commandtype, string Commandtext,dataset ds,string tablename);





DataSet ExecuteDataset (string commandtext,dataset ds,string tablename);





DataSet ExecuteDataset (CommandType commandtype, string CommandText, Queryparametercollection commandParameters, DataSet ds,string tablename);





DataSet ExecuteDataset (String commandtext, Queryparametercollection commandparameters,dataset ds,string TableName);











#endregion ExecuteDataset











#region ExecuteReader











IDataReader ExecuteReader (CommandType commandtype, string CommandText);





IDataReader ExecuteReader (string commandtext);





IDataReader ExecuteReader (CommandType commandtype, string CommandText, Queryparametercollection Commandparameters);





IDataReader ExecuteReader (String commandtext, Queryparametercollection commandparameters);











#endregion ExecuteReader











#region ExecuteScalar











Object ExecuteScalar (CommandType commandtype, string CommandText);





Object ExecuteScalar (string commandtext);





Object ExecuteScalar (CommandType commandtype, string CommandText, Queryparametercollection commandparameters);





Object ExecuteScalar (String commandtext, Queryparametercollection commandparameters);











#endregion ExecuteScalar











#region ExecuteXmlReader











XmlReader ExecuteXmlReader (CommandType commandtype, string CommandText);





XmlReader ExecuteXmlReader (string commandtext);





XmlReader ExecuteXmlReader (CommandType commandtype, string CommandText, Queryparametercollection Commandparameters);





XmlReader ExecuteXmlReader (String commandtext, Queryparametercollection commandparameters);











#endregion ExecuteXmlReader





}














2: A demo program developed using WEBSHARP middleware.