public frmCusOrder() { InitializeComponent(); bussinessclass bc = new bussinessclass(); DataSet ds = new DataSet(); ds = bc.Orders_GetList(); dgview.DataSource = ds; dgview.DataMember = "Orders"; DataSet dscity = new DataSet(); dscity = bc.City_GetList(); cmbbeginning.DataSource = dscity.Tables["City"]; cmbbeginning.DisplayMember = "Name"; cmbbeginning.ValueMember = "Code"; cmbdestination.DataSource = dscity.Tables["City"]; cmbdestination.DisplayMember = "Name"; cmbdestination.ValueMember = "Code"; DataSet dsvehicle = new DataSet(); dsvehicle = bc.Vehicle_GetList(); cmbvehicle.DataSource = dsvehicle.Tables[0]; cmbvehicle.DisplayMember = "Title"; cmbvehicle.ValueMember = "ID"; }
public frmCustomerInfo() { InitializeComponent(); bussinessclass bc = new bussinessclass(); DataSet ds1 = new DataSet(); ds1 = bc.Customer_GetList(); dgview.DataSource = ds1; dgview.DataMember = "Customer"; DataSet dscity = new DataSet(); dscity = bc.City_GetList(); cmbBCity.DataSource = dscity.Tables["City"]; cmbBCity.DisplayMember = "Name"; cmbBCity.ValueMember = "Code"; cmbLcity.DataSource = dscity.Tables["City"]; cmbLcity.DisplayMember = "Name"; cmbLcity.ValueMember = "Code"; cmbBProvince.DisplayMember = "فارس"; cmbBProvince.ValueMember = "1"; cmbLProvince.DisplayMember = "فارس"; cmbLProvince.ValueMember = "1"; cmbLPart.DisplayMember = "مرکزی"; cmbbPart.ValueMember = "1"; cmbLPart.DisplayMember = "مرکزی"; cmbLPart.ValueMember = "1"; cmbbvillage.DisplayMember = "مرکزی"; cmbbvillage.ValueMember = "1"; cmbLVillage.DisplayMember = "مرکزی"; cmbLVillage.ValueMember = "1"; //-------------------------------- }
private void btnView_Click(object sender, EventArgs e) { bussinessclass bc = new bussinessclass(); DataSet dscity = new DataSet(); DataSet dscity1 = new DataSet(); dscity = bc.City_GetList(); dscity1 = bc.City_GetList(); txtid1.Text = dgview.SelectedRows[0].Cells[0].Value.ToString(); txttitle1.Text = dgview.SelectedRows[0].Cells[1].Value.ToString(); txtdescription.Text = dgview.SelectedRows[0].Cells[2].Value.ToString(); cmbvehicle.Text = dgview.SelectedRows[0].Cells[4].Value.ToString(); txtprice.Text = dgview.SelectedRows[0].Cells[5].Value.ToString(); txtmaxnumber.Text = dgview.SelectedRows[0].Cells[6].Value.ToString(); string tbeginning = ""; int vbeginning; for (int i = 0; i < Convert.ToInt32(dscity.Tables[0].Rows.Count); i++) { vbeginning = Convert.ToInt32(dgview.SelectedRows[0].Cells[7].Value.ToString()); if (vbeginning == Convert.ToInt32(dscity.Tables[0].Rows[i]["Code"])) { tbeginning = dscity.Tables[0].Rows[i]["Name"].ToString(); } } cmbbeginning.Text = tbeginning; string tdestination = ""; int vdestination; for (int i = 0; i < Convert.ToInt32(dscity1.Tables[0].Rows.Count); i++) { vdestination = Convert.ToInt32(dgview.SelectedRows[0].Cells[8].Value.ToString()); if (vdestination == Convert.ToInt32(dscity1.Tables[0].Rows[i]["Code"])) { tdestination = dscity1.Tables[0].Rows[i]["Name"].ToString(); } } cmbdestination.Text = tdestination; txtdate.Text = dgview.SelectedRows[0].Cells[9].Value.ToString(); txttime.Text = dgview.SelectedRows[0].Cells[10].Value.ToString(); txtstatus.Text = dgview.SelectedRows[0].Cells[11].Value.ToString(); }