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"); } }
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(); }