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 = "";
}
}
}
}
