将数据插入数据库两次，其他数据库中没有数据。 [英] Insert data into database twice and no data in other database.

问题描述

我有一个表单，当单击提交按钮时，它会获取数据并将其插入三个数据库。当用户单击提交按钮时，在两个表中有两个插入，每个表应该有一个插入。最后一张表根本没有得到任何数据。我做错了什么？



<前lang =c＃> 受保护 void ButtonSubmit_Click（ object sender，EventArgs e）
{
SqlConnection con = new SqlConnection（System.Configuration.ConfigurationManager.ConnectionStrings [ HotConnectionString ] .ConnectionString）;
con.Open（）;

SqlCommand cmd = new SqlCommand（ 插入表22（USERID，TOTAL_REVE，DATE，FINYR，INSTRUCTIO，RESEARCH，PUBLIC_SER，ACADEMIC_S，STUDENT_SE，INSTITUTIO，PHYSICAL_P，NET_AID，AUXILIARY_，HOSPITALS，INDEPENDEN，OTHEREXP，TOTASSETS，TOTLIABILITY，NoNEXPPERMRESASSETS，EXPENDABLE，UNRNETASSETS，TOTALREV ，TUITFEES，CURRDEBT，LONGTERMDEBT，TOTALNETASSETS）值（@USID，@ TOTAL_REVE，@ DATE，@ FINYR，@ INSTRUCTIO，@ RESEARCH，@ Public_SER，@ ACADEMIC_S，@ STUDENT_SE，@ INSTITUTIO，@ PHYSICAL_P，@ NET_AID，@ AUXILIARY_， @HOSPITALS，@ INDEPENDEN，@OTHEREXP，@ TOTASSETS，@ TOTLIABILITY，@ NoNEXPPERMRESASSETS，@ EXPENDABLE，@ UNRNETASSETS，@ TOTALREV，@ TOTITES，@ CURRDEBT，@ LongterMDEBT，@ TOTALNETASSETS）插入表23（USERID，TOTAL_REVE，DATE，FINYR ，INSTRUCTIO，RESEARCH，PUBLIC_SER，ACADEMIC_S，STUDENT_SE，INSTITUTIO，PHYSICAL_P，NET_AID，AUXILIARY_，HOSPITALS，INDEPENDEN，OTHEREXP，TOTASSETS ，TOTLIABILITY，NoNEXPPERMRESASSETS，EXPENDABLE，UNRNETASSETS，TOTALREV，TITITFEES，CURRDEBT，LONGTERMDEBT，TOTALNETASSETS）值（@USID，@ TOTAL_REVE，@ DATE，@ FINYR，@ INSTRUCTIO，@ RESEARCH，@ Public_SER，@ ACADEMIC_S，@ STUDENT_SE，@ INSTITUTIO ，@ PHYSICAL_P，@ NET_AID，@ AUXILIARY_，@ HEALTHPITALS，@ INDEPENDEN，@ OTEXEXP，@ TOTASSETS，@ TOTLIABILITY，@ NoNEXPPERMRESASSETS，@ EXPENDABLE，@ UNRNETASSETS，@ TOTALREV，@ TUITFEES，@ CURRDEBT，@ LongterMDEBT，@ TOTALNETASSETS）插入到表24（USERID，FirstName，MiddleName，LastName，Prefix，Suffix，Salutation，Title，Address1，Address2，City，State，Zip，Country，Phone，Fax，Email，DATE，accessLevel）值（@USIDID，@ FirstName，@ MiddleName，@ LastName，@ Prefix，@ Suffix，@ Sututation，@ Title，@ Address1，@ Address2，@ City，@ State，@ Zip，@ Country，@ Phone，@ Afax，@ Email，@ DATE，@ accessLevel） ，con）;

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue（ @ TOTAL_REVE，TextBoxTRIR.Text ）;
cmd.Parameters.AddWithValue（ @ USERID，TextBoxUSERID.Text）;
cmd.Parameters.AddWithValue（ @ INSTRUCTIO，TextBoxInstr.Text）;
cmd.Parameters.AddWithValue（ @ RESEARCH，TextBoxRes.Text）;
cmd.Parameters.AddWithValue（ @ PUBLIC_SER，TextBoxPubS.Text）;
cmd.Parameters.AddWithValue（ @ ACADEMIC_S，TextBoxAcad.Text）;
cmd.Parameters.AddWithValue（ @ STUDENT_SE，TextBoxStudS.Text）;
cmd.Parameters.AddWithValue（ @ INSTITUTIO，TextBoxInstiS.Text）;
cmd.Parameters.AddWithValue（ @ PHYSICAL_P，TextBoxOperM.Text）;
cmd.Parameters.AddWithValue（ @ NET_AID，TextBoxNGAS.Text）;
cmd.Parameters.AddWithValue（ @ AUXILIARY _，TextBoxAuxE.Text）;
cmd.Parameters.AddWithValue（ @ HOSPITALS，TextBoxHosS.Text）;
cmd.Parameters.AddWithValue（ @ INDEPENDEN，TextBoxIndeO.Text）;
cmd.Parameters.AddWithValue（ @ OTHEREXP，TextBoxOE.Text）;
cmd.Parameters.AddWithValue（ @ TOTASSETS，TextBoxTA.Text）;
cmd.Parameters.AddWithValue（ @ TOTLIABILITY，TextBoxTL.Text）;
cmd.Parameters.AddWithValue（ @NoNEXPPERMRESASSETS，TextBoxNPRNA.Text）;
cmd.Parameters.AddWithValue（ @ EXPENDABLE，TextBoxETRNA.Text）;
cmd.Parameters.AddWithValue（ @ UNRNETASSETS，TextBoxTUNA.Text）;
cmd.Parameters.AddWithValue（ @ TOTALREV，TextBoxTR.Text）;
cmd.Parameters.AddWithValue（ @ TUITFEES，TextBoxTFN.Text）;
cmd.Parameters.AddWithValue（ @ CURRDEBT，TextBoxCD.Text）;
cmd.Parameters.AddWithValue（ @ LONGTERMDEBT，TextBoxLTD.Text）;
cmd.Parameters.AddWithValue（ @ TOTALNETASSETS，TextBoxTNA.Text）;
cmd.Parameters.AddWithValue（ @ FINYR，TextBoxDATE2.Text）;
cmd.Parameters.AddWithValue（ @ DATE，TextBoxDATE.Text）;

cmd.Parameters.AddWithValue（ @ FirstName，TextBoxFName.Text ）;
cmd.Parameters.AddWithValue（ @ LastName，TextBoxLName.Text）;
cmd.Parameters.AddWithValue（ @ MiddleName，TextBoxMName.Text）;
cmd.Parameters.AddWithValue（ @ Prefix，TextBoxPrefix.Text）;
cmd.Parameters.AddWithValue（ @ Suffix，TextBoxSuffix.Text）;
cmd.Parameters.AddWithValue（ @ Salutation，TextBoxSal.Text）;
cmd.Parameters.AddWithValue（ @ Title，TextBoxTitle.Text）;
cmd.Parameters.AddWithValue（ @ Address1，TextBoxMA1.Text）;
cmd.Parameters.AddWithValue（ @ Address2，TextBoxMA2.Text）;
cmd.Parameters.AddWithValue（ @ City，TextBoxCity.Text）;
cmd.Parameters.AddWithValue（ @ State，TextBoxState.Text）;
cmd.Parameters.AddWithValue（ @ Zip，TextBoxZip.Text）;
cmd.Parameters.AddWithValue（ @ Country，TextBoxCoun.Text）;
cmd.Parameters.AddWithValue（ @ Phone，TextBoxTN.Text）;
cmd.Parameters.AddWithValue（ @ Fax，TextBoxFN.Text）;
cmd.Parameters.AddWithValue（ @ Email，TextBoxEA.Text）;
cmd.Parameters.AddWithValue（ @ accessLevel，TextBoxaccessLevel.Text）;

cmd.ExecuteNonQuery（）;
con.Close（）;

解决方案

你必须在三个插入语句之间插入'GO'关键字



和其他一个分号的解决方案;解决问题的三个判断之间..

在每个插入语句后添加分号

ie

 SqlCommand cmd =  new  SqlCommand（ 插入表22（ USERID，TOTAL_REVE，DATE，FINYR，INSTRUCTIO，RESEARCH，PUBLIC_SER，ACADEMIC_S，STUDENT_SE，INSTITUTIO，PHYSICAL_P，NET_AID，AUXILIARY_，HOSPITALS，INDEPENDEN，OTHEREXP，TOTASSETS，TOTLIABILITY，NoNEXPPERMRESASSETS，EXPORABLE，UNRNETASSETS，TOTALREV，TUITFEES，CURRDEBT，LONGTERMDEBT， TOTALNETASSETS）值（@USIDID，@ TOTAL_REVE，@ DATE，@ FINYR，@ INSTRUCTIO，@ RESEARCH，@ Public_SER，@ ACADEMIC_S，@ STUDENT_SE，@ INSTITUTIO，@ PHYSICAL_P，@ NET_AID，@ AUXILIARY_，@ HEALTHPITALS，@ INDEPENDEN，@ OTHEREXP，@ TOTASSETS，@ TOTLIABILITY，@ NoNEXPPERMRESASSETS，@ EXPENDABLE，@ UNRNETASSETS，@ TOTALREV，@ TUITFEES，@ CURRDEBT，@ LongterMDEBT，@ TOTALNETASSETS）;插入表23（USERID，TOTAL_REVE，DATE，FINY） R，INSTRUCTIO，RESEARCH，PUBLIC_SER，ACADEMIC_S，STUDENT_SE，INSTITUTIO，PHYSICAL_P，NET_AID，AUXILIARY_，HOSPITALS，INDEPENDEN，OTHEREXP，TOTASSETS，TOTLIABILITY，NoNEXPPERMRESASSETS，EXPENDABLE，UNRNETASSETS，TOTALREV，TITITFEES，CURRDEBT，LONGTERMDEBT，TOTALNETASSETS）值（@USERID ，@ TOTAL_REVE，@ DATE，@ FINYR，@ INSTRUCTIO，@ RESEARCH，@ Public_SER，@ ACADEMIC_S，@ STUDENT_SE，@ INSTITUTIO，@ PHYSICAL_P，@ NET_AID，@ AUXILIARY _，@ HEALTHPITALS，@ INDEPENDEN，@ OTEXEXP，@ TOTASSETS，@ TOTLIABILITY，@ NoNEXPPERMRESASSETS，@ EXPENDABLE，@ UNRNETASSETS，@ TOTALREV，@ TUITFEES，@ CURRDEBT，@ LongterMDEBT，@ TOTALNETASSETS）;插入表24（USERID，FirstName，MiddleName，LastName，Prefix，Suffix，Salutation，Title，Address1，Address2，City，State，Zip，Country，Phone，Fax，Email，DATE，accessLevel）值（@USIDID，@ FirstName， @ MiddleName，@ LastName，@ Prefix，@ Suffix，@ Sututation，@ Title，@ Address1，@ Address2，@ City，@ State，@ Zip，@ Country，@ Phone，@ Fax，@ Email，@ Date，@ accessLevel ）;，con）; 
 

I have a form that takes data and inserts it into three databases when the submit button is clicked. When a user clicks the submit button there are two inserts in two of the tables where there should be one insert per table. The last table is not getting any data at all. What did I do wrong?

protected void ButtonSubmit_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HotConnectionString"].ConnectionString);
        con.Open();

        SqlCommand cmd = new SqlCommand("Insert into Table22 (USERID, TOTAL_REVE, DATE, FINYR, INSTRUCTIO, RESEARCH, PUBLIC_SER, ACADEMIC_S, STUDENT_SE, INSTITUTIO, PHYSICAL_P, NET_AID, AUXILIARY_, HOSPITALS, INDEPENDEN, OTHEREXP, TOTASSETS, TOTLIABILITY, NoNEXPPERMRESASSETS, EXPENDABLE, UNRNETASSETS, TOTALREV, TUITFEES, CURRDEBT, LONGTERMDEBT, TOTALNETASSETS) values (@USERID, @TOTAL_REVE, @DATE, @FINYR, @INSTRUCTIO, @RESEARCH, @PUBLIC_SER, @ACADEMIC_S, @STUDENT_SE, @INSTITUTIO, @PHYSICAL_P, @NET_AID, @AUXILIARY_, @HOSPITALS, @INDEPENDEN, @OTHEREXP, @TOTASSETS, @TOTLIABILITY, @NoNEXPPERMRESASSETS, @EXPENDABLE, @UNRNETASSETS, @TOTALREV, @TUITFEES, @CURRDEBT, @LONGTERMDEBT, @TOTALNETASSETS)Insert into Table23 (USERID, TOTAL_REVE, DATE, FINYR, INSTRUCTIO, RESEARCH, PUBLIC_SER, ACADEMIC_S, STUDENT_SE, INSTITUTIO, PHYSICAL_P, NET_AID, AUXILIARY_, HOSPITALS, INDEPENDEN, OTHEREXP, TOTASSETS, TOTLIABILITY, NoNEXPPERMRESASSETS, EXPENDABLE, UNRNETASSETS, TOTALREV, TUITFEES, CURRDEBT, LONGTERMDEBT, TOTALNETASSETS) values (@USERID, @TOTAL_REVE, @DATE, @FINYR, @INSTRUCTIO, @RESEARCH, @PUBLIC_SER, @ACADEMIC_S, @STUDENT_SE, @INSTITUTIO, @PHYSICAL_P, @NET_AID, @AUXILIARY_, @HOSPITALS, @INDEPENDEN, @OTHEREXP, @TOTASSETS, @TOTLIABILITY, @NoNEXPPERMRESASSETS, @EXPENDABLE, @UNRNETASSETS, @TOTALREV, @TUITFEES, @CURRDEBT, @LONGTERMDEBT, @TOTALNETASSETS)Insert into Table24 (USERID, FirstName, MiddleName, LastName, Prefix, Suffix, Salutation, Title, Address1, Address2, City, State, Zip, Country, Phone, Fax, Email, DATE, accessLevel) values (@USERID, @FirstName, @MiddleName, @LastName, @Prefix, @Suffix, @Salutation, @Title, @Address1, @Address2, @City, @State, @Zip, @Country, @Phone, @Fax, @Email, @DATE, @accessLevel)", con);

        cmd.CommandType = CommandType.Text;

        cmd.Parameters.AddWithValue("@TOTAL_REVE", TextBoxTRIR.Text);
        cmd.Parameters.AddWithValue("@USERID", TextBoxUSERID.Text);
        cmd.Parameters.AddWithValue("@INSTRUCTIO", TextBoxInstr.Text);
        cmd.Parameters.AddWithValue("@RESEARCH", TextBoxRes.Text);
        cmd.Parameters.AddWithValue("@PUBLIC_SER", TextBoxPubS.Text);
        cmd.Parameters.AddWithValue("@ACADEMIC_S", TextBoxAcad.Text);
        cmd.Parameters.AddWithValue("@STUDENT_SE", TextBoxStudS.Text);
        cmd.Parameters.AddWithValue("@INSTITUTIO", TextBoxInstiS.Text);
        cmd.Parameters.AddWithValue("@PHYSICAL_P", TextBoxOperM.Text);
        cmd.Parameters.AddWithValue("@NET_AID", TextBoxNGAS.Text);
        cmd.Parameters.AddWithValue("@AUXILIARY_", TextBoxAuxE.Text);
        cmd.Parameters.AddWithValue("@HOSPITALS", TextBoxHosS.Text);
        cmd.Parameters.AddWithValue("@INDEPENDEN", TextBoxIndeO.Text);
        cmd.Parameters.AddWithValue("@OTHEREXP", TextBoxOE.Text);
        cmd.Parameters.AddWithValue("@TOTASSETS", TextBoxTA.Text);
        cmd.Parameters.AddWithValue("@TOTLIABILITY", TextBoxTL.Text);
        cmd.Parameters.AddWithValue("@NoNEXPPERMRESASSETS", TextBoxNPRNA.Text);
        cmd.Parameters.AddWithValue("@EXPENDABLE", TextBoxETRNA.Text);
        cmd.Parameters.AddWithValue("@UNRNETASSETS", TextBoxTUNA.Text);
        cmd.Parameters.AddWithValue("@TOTALREV", TextBoxTR.Text);
        cmd.Parameters.AddWithValue("@TUITFEES", TextBoxTFN.Text);
        cmd.Parameters.AddWithValue("@CURRDEBT", TextBoxCD.Text);
        cmd.Parameters.AddWithValue("@LONGTERMDEBT", TextBoxLTD.Text);
        cmd.Parameters.AddWithValue("@TOTALNETASSETS", TextBoxTNA.Text);
        cmd.Parameters.AddWithValue("@FINYR", TextBoxDATE2.Text);
        cmd.Parameters.AddWithValue("@DATE", TextBoxDATE.Text);

        cmd.Parameters.AddWithValue("@FirstName", TextBoxFName.Text);
        cmd.Parameters.AddWithValue("@LastName", TextBoxLName.Text);
        cmd.Parameters.AddWithValue("@MiddleName", TextBoxMName.Text);
        cmd.Parameters.AddWithValue("@Prefix", TextBoxPrefix.Text);
        cmd.Parameters.AddWithValue("@Suffix", TextBoxSuffix.Text);
        cmd.Parameters.AddWithValue("@Salutation", TextBoxSal.Text);
        cmd.Parameters.AddWithValue("@Title", TextBoxTitle.Text);
        cmd.Parameters.AddWithValue("@Address1", TextBoxMA1.Text);
        cmd.Parameters.AddWithValue("@Address2", TextBoxMA2.Text);
        cmd.Parameters.AddWithValue("@City", TextBoxCity.Text);
        cmd.Parameters.AddWithValue("@State", TextBoxState.Text);
        cmd.Parameters.AddWithValue("@Zip", TextBoxZip.Text);
        cmd.Parameters.AddWithValue("@Country", TextBoxCoun.Text);
        cmd.Parameters.AddWithValue("@Phone", TextBoxTN.Text);
        cmd.Parameters.AddWithValue("@Fax", TextBoxFN.Text);
        cmd.Parameters.AddWithValue("@Email", TextBoxEA.Text);
        cmd.Parameters.AddWithValue("@accessLevel", TextBoxaccessLevel.Text);

        cmd.ExecuteNonQuery();
        con.Close();

解决方案

You Have to insert 'GO' Keyword between three insert statments

and other one solution to put semicolon ; between three statments to resolve the problems..

Put semicolons after each insert statement
i.e

SqlCommand cmd = new SqlCommand("Insert into Table22 (USERID, TOTAL_REVE, DATE, FINYR, INSTRUCTIO, RESEARCH, PUBLIC_SER, ACADEMIC_S, STUDENT_SE, INSTITUTIO, PHYSICAL_P, NET_AID, AUXILIARY_, HOSPITALS, INDEPENDEN, OTHEREXP, TOTASSETS, TOTLIABILITY, NoNEXPPERMRESASSETS, EXPENDABLE, UNRNETASSETS, TOTALREV, TUITFEES, CURRDEBT, LONGTERMDEBT, TOTALNETASSETS) values (@USERID, @TOTAL_REVE, @DATE, @FINYR, @INSTRUCTIO, @RESEARCH, @PUBLIC_SER, @ACADEMIC_S, @STUDENT_SE, @INSTITUTIO, @PHYSICAL_P, @NET_AID, @AUXILIARY_, @HOSPITALS, @INDEPENDEN, @OTHEREXP, @TOTASSETS, @TOTLIABILITY, @NoNEXPPERMRESASSETS, @EXPENDABLE, @UNRNETASSETS, @TOTALREV, @TUITFEES, @CURRDEBT, @LONGTERMDEBT, @TOTALNETASSETS); Insert into Table23 (USERID, TOTAL_REVE, DATE, FINYR, INSTRUCTIO, RESEARCH, PUBLIC_SER, ACADEMIC_S, STUDENT_SE, INSTITUTIO, PHYSICAL_P, NET_AID, AUXILIARY_, HOSPITALS, INDEPENDEN, OTHEREXP, TOTASSETS, TOTLIABILITY, NoNEXPPERMRESASSETS, EXPENDABLE, UNRNETASSETS, TOTALREV, TUITFEES, CURRDEBT, LONGTERMDEBT, TOTALNETASSETS) values (@USERID, @TOTAL_REVE, @DATE, @FINYR, @INSTRUCTIO, @RESEARCH, @PUBLIC_SER, @ACADEMIC_S, @STUDENT_SE, @INSTITUTIO, @PHYSICAL_P, @NET_AID, @AUXILIARY_, @HOSPITALS, @INDEPENDEN, @OTHEREXP, @TOTASSETS, @TOTLIABILITY, @NoNEXPPERMRESASSETS, @EXPENDABLE, @UNRNETASSETS, @TOTALREV, @TUITFEES, @CURRDEBT, @LONGTERMDEBT, @TOTALNETASSETS); Insert into Table24 (USERID, FirstName, MiddleName, LastName, Prefix, Suffix, Salutation, Title, Address1, Address2, City, State, Zip, Country, Phone, Fax, Email, DATE, accessLevel) values (@USERID, @FirstName, @MiddleName, @LastName, @Prefix, @Suffix, @Salutation, @Title, @Address1, @Address2, @City, @State, @Zip, @Country, @Phone, @Fax, @Email, @DATE, @accessLevel);", con);

这篇关于将数据插入数据库两次，其他数据库中没有数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！