private void Binding() { DataSet data = new mrateCRUD().getData(); DtGrid.DataSource = data; DtGrid.DataMember = "tblmrate"; }
private void cbCurrency_SelectedIndexChanged(object sender, EventArgs e) { DataSet dsKurs = new mrateCRUD().getData(cbCurrency.Text); if (dsKurs.Tables[0].Rows.Count > 0) { txtKurs.Text = dsKurs.Tables[0].Rows[0]["KURS"].ToString(); } }
private void dtGrid_CellValueChanged(object sender, DataGridViewCellEventArgs e) { var senderGrid = (DataGridView)sender; if (e.ColumnIndex == -1) { return; } else { if (senderGrid.Columns[e.ColumnIndex] == dtGrid.Columns["hCurrency"]) { DataSet dsKurs = new mrateCRUD().getData(Convert.ToString(dtGrid.Rows[e.RowIndex].Cells["hCurrency"].Value)); if (dsKurs.Tables[0].Rows.Count > 0) { dtGrid.Rows[e.RowIndex].Cells["hKurs"].Value = Convert.ToString(dsKurs.Tables[0].Rows[0]["KURS"]); } } } }
private void dtGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e) { // var senderGrid = (DataGridView)sender; if (e.RowIndex >= 0 && senderGrid.Columns[e.ColumnIndex] == dtGrid.Columns["hCurrency"]) { DataSet dsKurs = new mrateCRUD().getData(dtGrid.Rows[e.RowIndex].Cells["hCurrency"].Value.ToString()); if (dsKurs.Tables[0].Rows.Count > 0) { //Conver = (float)Convert.ToDouble(dsConvert.Tables[0].Rows[0]["CONVER"]); dtGrid.Rows[e.RowIndex].Cells["hKurs"].Value = (float)Convert.ToDouble(dsKurs.Tables[0].Rows[0]["KURS"]); } } // int RowIndex = e.RowIndex; int columnIndex = e.ColumnIndex; if (e.ColumnIndex == 1) { bool validation = true; if (dtGrid.Rows[RowIndex].Cells[columnIndex].Value != null && dtGrid.Rows[RowIndex].Cells[columnIndex].Value.ToString().Trim() != "") { string DataToValidate = dtGrid.Rows[RowIndex].Cells[columnIndex].Value.ToString(); foreach (char c in DataToValidate) { if (!char.IsDigit(c)) { validation = false; break; } } if (validation == false) { dtGrid.Rows[RowIndex].Cells[columnIndex].ErrorText = "You Can Only Enter Number here "; dtGrid.Rows[RowIndex].Cells[columnIndex].Value = ""; } } } }