本文介绍了相同数据库两个不同的表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用两个不同的表将数据插入到我的数据库中。我有一个错误在这个范围内已经定义了一个名为'insCmd'的局部变量。我支持这一部分。如何将数据插入一个表中,将其他数据插入另一个表中?
I am trying to insert data into my database with two different tables. I have an error "A local variable named 'insCmd' is already defined in this scope. I under stand this part. How can I have the data to be inserted into one table and the other data inserted into another table?
using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Drawing;
using System.Text;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Data.SqlClient;
using System.Configuration;
using System.Drawing.Printing;
public partial class FTEEnrollmentInformation : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PassConnectionString"].ConnectionString);
con.Open();
string insCmd = "Insert into TableFTE (FT_UNDERGR, FT_GRAD, FTE_UNDERG, FTE_GRAD, NON_CREDIT, TOTAL_FTE, FCFTUHC, FCFTPBHC, FCPTUHC, FCPTBHC, NCHC) values (@FT_UNDERGR, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTBHC, @NCHC)";
string insCmd = "Insert into TableGRADRATE (ASTUDENTS, ACOMPLETED, ATRANSFERS, BSTUDENTS, BCOMPLETED, BTRANSDERS, YEAR, DATE) values (@ASTUDENTS, @ACOMPLETED, @ATRANSFERS, @BSTUDENTS, @BCOMPLETED, @BTRANSDERS, @YEAR, @DATE)";
SqlCommand insertUser = new SqlCommand(insCmd, con);
insertUser.Parameters.AddWithValue("@FT_UNDERGR", TextBoxFTUG.Text);
insertUser.Parameters.AddWithValue("@FT_GRAD", TextBoxFTG.Text);
insertUser.Parameters.AddWithValue("@FTE_UNDERG", TextBoxTHUGDR.Text);
insertUser.Parameters.AddWithValue("@FTE_GRAD", TextBoxTHGDR.Text);
insertUser.Parameters.AddWithValue("@NON_CREDIT", TextBoxNCCDR.Text);
insertUser.Parameters.AddWithValue("@TOTAL_FTE", TextBoxTCNC.Text);
insertUser.Parameters.AddWithValue("@FCFTUHC", TextBoxTNFUG.Text);
insertUser.Parameters.AddWithValue("@FCFTPBHC", TextBoxTNFG.Text);
insertUser.Parameters.AddWithValue("@FCPTUHC", TextBoxTNCPUG.Text);
insertUser.Parameters.AddWithValue("@FCPTBHC", TextBoxTNCPG.Text);
insertUser.Parameters.AddWithValue("@NCHC", TextBoxTNNCC.Text);
insertUser.Parameters.AddWithValue("@ASTUDENTS", TextBoxTNUGSC.Text);
insertUser.Parameters.AddWithValue("@ACOMPLETED", TextBoxTNUGSCD.Text);
insertUser.Parameters.AddWithValue("@ATRANSFERS", TextBoxTTOUG.Text);
insertUser.Parameters.AddWithValue("@BSTUDENTS", TextBoxTNGSC.Text);
insertUser.Parameters.AddWithValue("@BCOMPLETED", TextBoxTNGSCD.Text);
insertUser.Parameters.AddWithValue("@BTRANSDERS", TextBoxTTOG.Text);
insertUser.Parameters.AddWithValue("@YEAR", TextBoxYEAR.Text);
insertUser.Parameters.AddWithValue("@DATE", TextBoxDATE.Text);
try
{
insertUser.ExecuteNonQuery();
con.Close();
Response.Redirect("FinancialProfileFormA.aspx");
}
catch (Exception er)
{
Response.Write("You Have Successfully Submitted the Information!!!");
}
finally
{
}
}
public class PCPrint : System.Drawing.Printing.PrintDocument
{
}
protected void ButtonPrint_Click(object sender, EventArgs e)
{
}
}
推荐答案
string insCmd = "Insert into TableFTE (FT_UNDERGR, FT_GRAD, FTE_UNDERG, FTE_GRAD, NON_CREDIT, TOTAL_FTE, FCFTUHC, FCFTPBHC, FCPTUHC, FCPTBHC, NCHC) values (@FT_UNDERGR, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTBHC, @NCHC)";
string insCmd = "Insert into TableGRADRATE (ASTUDENTS, ACOMPLETED, ATRANSFERS, BSTUDENTS, BCOMPLETED, BTRANSDERS, YEAR, DATE) values (@ASTUDENTS, @ACOMPLETED, @ATRANSFERS, @BSTUDENTS, @BCOMPLETED, @BTRANSDERS, @YEAR, @DATE)";
to
to
string insCmd = "Insert into TableFTE (FT_UNDERGR, FT_GRAD, FTE_UNDERG, FTE_GRAD, NON_CREDIT, TOTAL_FTE, FCFTUHC, FCFTPBHC, FCPTUHC, FCPTBHC, NCHC) values (@FT_UNDERGR, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTBHC, @NCHC); Insert into TableGRADRATE (ASTUDENTS, ACOMPLETED, ATRANSFERS, BSTUDENTS, BCOMPLETED, BTRANSDERS, YEAR, DATE) values (@ASTUDENTS, @ACOMPLETED, @ATRANSFERS, @BSTUDENTS, @BCOMPLETED, @BTRANSDERS, @YEAR, @DATE);";
并告诉我这是否有效。
and let me know whether this works or not.
这篇关于相同数据库两个不同的表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!