protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox type = ASPxGridView1.FindEditFormLayoutItemTemplateControl("lab") as ASPxComboBox;
cn.Open();
string req = "select Id from EventFamilly where Label= '" + type.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(req, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
e.NewValues["EventFamilly_Id"] = dr["Id"].ToString();
}
cn.Close();
ASPxComboBox EventNature = ASPxGridView1.FindEditFormLayoutItemTemplateControl("EventNature") as ASPxComboBox;
cn.Open();
string req1 = "select Id from EventNature where Label= '" + EventNature.SelectedItem.ToString() + "'";
SqlCommand cmd1 = new SqlCommand(req1, cn);
SqlDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
e.NewValues["IdEventNature"] = dr1["Id"].ToString();
}
cn.Close();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox NaturalPerson = ASPxGridView1.FindEditFormLayoutItemTemplateControl("PersonnePysique") as ASPxComboBox;
cn.Open();
string req = "select Id from NaturalPerson where FirstName= '" + NaturalPerson.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(req, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
e.NewValues["PersonnePysique_Id"] = dr["Id"].ToString();
}
cn.Close();
ASPxComboBox Adresse = ASPxGridView1.FindEditFormLayoutItemTemplateControl("Adresse") as ASPxComboBox;
cn.Open();
string req1 = "select Id from Adresse where Code= '" + Adresse.SelectedItem.ToString() + "'";
SqlCommand cmd1 = new SqlCommand(req1, cn);
SqlDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
e.NewValues["Adresse_Id"] = dr1["Id"].ToString();
}
cn.Close();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox Good = ASPxGridView1.FindEditFormLayoutItemTemplateControl("Good") as ASPxComboBox;
cn.Open();
string req = "select Id from Good where TypeCode= '" + Good.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(req, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
e.NewValues["Good_Id"] = dr["Id"].ToString();
}
cn.Close();
ASPxComboBox Adresse = ASPxGridView1.FindEditFormLayoutItemTemplateControl("Adresse") as ASPxComboBox;
cn.Open();
string req1 = "select Id from Adresse where Code= '" + Adresse.SelectedItem.ToString() + "'";
SqlCommand cmd1 = new SqlCommand(req1, cn);
SqlDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
e.NewValues["Adresse_Id"] = dr1["Id"].ToString();
}
cn.Close();
}
