/* Public Methods */
public void save()
{
DBHelper dbhelper = new DBHelper();
string insertstr = buildStringForInsert();
dbhelper.ExecuteNonQuery(insertstr);
dbhelper.close();
}
private void OK_Click_1(object sender, EventArgs e)
{
DBHelper dbhelper = new DBHelper();
string string1 = "insert into UserRole(UserRole) values('" + UserRole.Text + "')";
dbhelper.ExecuteNonQuery(string1);
dbhelper.close();
this.Close();
}
/* Public Methods */
public void save()
{
// Create DBHelper's Instance
DBHelper dbhelper = new DBHelper();
// Get insert string
string insertstr = buildStringForInsert();
// Insert into DB
dbhelper.ExecuteNonQuery(insertstr);
// Close DB Helper
dbhelper.close();
}
public List<object> get()
{
List<object> retColl = new List<object>();
// Create DBHelper's Instance
DBHelper dbhelper = new DBHelper();
// Get query string
string insertstr = buildStringForQuery();
// Get from DB
OleDbDataReader dr = dbhelper.ExecuteQuery(insertstr);
// Get rows and convert them to user collection
if (dr.HasRows)
{
while (dr.Read())
{
retColl.Add(convertFromReader(dr));
}
}
// Close DB Helper
dbhelper.close();
return retColl;
}
