Esempio n. 1
0
 private void dgvOrderDetail_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e)
 {
     if ((dgvOrderDetail.Rows.Count != 0))
     {
         e.Row.Cells["OrderId"].Value  = txtOrderID.Text;
         e.Row.Cells["DetailId"].Value = DBClass.GetIdByQuery("SELECT IDENT_CURRENT('OrderDetail')+1");
     }
 }
Esempio n. 2
0
        private void NewRecord()
        {
            ClearRecord();

            int maxid = DBClass.GetIdByQuery("SELECT IDENT_CURRENT('OrderMain')+1");

            txtOrderID.Text = maxid.ToString();

            txtOrderDate.Text = System.DateTime.Now.ToShortDateString();
            if (dsForCombo.Tables["Customer"].Rows.Count > 0)
            {
                //txtCustmorid.Text = dsForCombo.Tables["Customer"].Rows[0]["CustomerID"].ToString();
                //cmbcustomername.SelectedValue = txtCustmorid.Text;
            }

            dsMain.Tables["OrderDetail"].DefaultView.RowFilter = "";
            dsMain.Tables["OrderDetail"].DefaultView.RowFilter = " Orderid=" + int.Parse(txtOrderID.Text);
            dgvOrderDetail.DataSource = dsMain.Tables["OrderDetail"].DefaultView;

            Enable_Disable_Controls(false);
            cmbcustomername.Focus();
        }