如何使用c＃和asp.net中的.edmx文件更新mysql数据库 [英] how to update mysql database using .edmx file in c# and asp.net

问题描述

您好，



我是软件开发人员，现在我正在尝试使用实体数据模型作为连接从mysql数据库更新数据，但是没有问题，之后编译没有显示错误。



有我的代码。



protected void AlterCustomerButton_Click（对象发送者） ，EventArgs e）

{



int IdClient = Convert.ToInt32（Request.QueryString [ClientID]）;

var query = from cl in context.clients orderby cl.NomProprietaire select cl;



foreach（查询中的var详细信息）{



if（detail.ClientID == IdClient）{



detail.NumeroIdentificationFiscal = NumIdent.Text;

detail.NomProprietaire = Nom.Text;

detail.Province = DropDownList5.SelectedValue;

detail.NumCNI = cni.Text;

detail.CategorieProprietaire = DropDownList1.SelectedValue;



// Vider les zones de saisies

NumIdent.Text =;

Nom.Text =;

DropDownList5.Text =;

cni.Text =;

DropDownList1 .Text =;



}

}

// Appliquer les modification sur sur client dont l 'identifiant == IdClient

context.SaveChanges（）;

string script ="< script language ='JavaScript'> alert（'client mofifie avec succes'）;< / script>" ;;



ClientScript.RegisterClientScriptBlock（this.GetType（），" script"，script ）;

Response.Redirect（"〜/ Forms / WebForm1.aspx"）;





}

欢迎所有帮助。

Hello,

I am software developper, now i am trying to update data from mysql database using entity data model as connection, but there is no issue and after compulation there is no error shown.

There is my code.

protected void AlterCustomerButton_Click(object sender, EventArgs e)
{

int IdClient= Convert.ToInt32(Request.QueryString["ClientID"]);
var query = from cl in context.clients orderby cl.NomProprietaire select cl;

foreach(var detail in query){

if(detail.ClientID==IdClient){

detail.NumeroIdentificationFiscal = NumIdent.Text;
detail.NomProprietaire = Nom.Text;
detail.Province = DropDownList5.SelectedValue;
detail.NumCNI = cni.Text;
detail.CategorieProprietaire = DropDownList1.SelectedValue;

//Vider les zones de saisies
NumIdent.Text="";
Nom.Text="";
DropDownList5.Text="";
cni.Text="";
DropDownList1.Text="";

}
}
//Appliquer les modifications sur le client dont l'identifiant==IdClient
context.SaveChanges();
string script = "<script language='JavaScript'> alert('Client mofifie avec succes');</script>";

ClientScript.RegisterClientScriptBlock(this.GetType(), "script", script);
Response.Redirect("~/Forms/WebForm1.aspx");


}
Please all help is welcome.

推荐答案

int IdClient= Convert.ToInt32(Request.QueryString["ClientID"]);
var query = (from cl in context.clients 
            Where cl.ClientID==IdClient select cl).SingleOrDefault();
 
if(query!=null){
 
query.NumeroIdentificationFiscal = NumIdent.Text;
query.NomProprietaire = Nom.Text;
query.Province = DropDownList5.SelectedValue;
query.NumCNI = cni.Text;
query.CategorieProprietaire = DropDownList1.SelectedValue;
context.SaveChanges();
 
//Vider les zones de saisies
NumIdent.Text="";
Nom.Text="";
DropDownList5.Text="";
cni.Text="";
DropDownList1.Text="";
 
}

这篇关于如何使用c＃和asp.net中的.edmx文件更新mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！