protected void Button2_Click(object sender, EventArgs e) { //实例化数据访问类 NorthwindDataAccess nda = new NorthwindDataAccess(); GridView1.DataSource = nda.GetCustOrdersDetails(10248); GridView1.DataBind(); }
private void countButton_Click(object sender, EventArgs e) { int count; try { count = NorthwindDataAccess.CountShippers(); shipperCountLabel.Text = count.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
protected void Button1_Click(object sender, EventArgs e) { //实例化数据访问类 NorthwindDataAccess nda = new NorthwindDataAccess(); //获取数据源 GridView1.DataSource = nda.GetProducts(); //数据绑定 try { GridView1.DataBind(); } catch (SqlException ex) { Label1.Text = "数据访问出错,错误消息是:" + ex.Message; } }
/// <summary> /// This method shows the use of the datareader /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void fillButton_Click(object sender, EventArgs e) { try { //set the cursor to the hour glass this.Cursor = Cursors.WaitCursor; customerComboBox.DataSource = NorthwindDataAccess.GetCustomers(""); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { //reset cursor this.Cursor = Cursors.Default; } }
private void add1Button_Click(object sender, EventArgs e) { int rowsInserted; try { rowsInserted = NorthwindDataAccess.AddShipper(companyNameTextBox.Text, phoneTextBox.Text); if (rowsInserted == 1) { MessageBox.Show("You have successfully added a Shipper."); //clear the text from the textboxes companyNameTextBox.Clear(); phoneTextBox.Clear(); } else { MessageBox.Show("Your Shipper has NOT been added to the database."); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public virtual int GetIntId(T entity) { var newId = NorthwindDataAccess.LoadData <int>(SqlQuery).FirstOrDefault(); return(newId); }
public virtual int Delete(int id) { return(NorthwindDataAccess.ExecuteQuery(SqlQuery, id)); }
public virtual async Task <IEnumerable <T> > GetAllAsync() { return(await NorthwindDataAccess.LoadDataAsync <T>(SqlQuery)); }
public virtual IEnumerable <T> GetAll() { return(NorthwindDataAccess.LoadData <T>(SqlQuery)); }
public virtual async Task <T> GetAsync(int id) { var data = await NorthwindDataAccess.LoadDataAsync <T>(SqlQuery); return(data.FirstOrDefault()); }
public virtual T Get(int id) { return(NorthwindDataAccess.LoadData <T>(SqlQuery).FirstOrDefault()); }
public virtual int Add(T entity) { return(NorthwindDataAccess.ExecuteQuery <T>(SqlQuery, entity)); }