Inserting DropDownList item into SQL Database

•浏览 1

Inserting DropDownList item into SQL Database

我有一个 DropDownList，其中填充了来自 SQL 表的数据。在网络表单中，当用户从该列表中选择一个项目时，我希望它将所选的选项插入另一个 SQL 表中，除了 DropDownLists

之外的所有内容都有效

我试过了：

cmd.Parameters.AddWithValue("@*", ddl*.SelectedValue);

cmd.Parameters.AddWithValue("@*", ddl*.SelectedItem.Text);

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Windows.Forms;

using System.Data;

using System.Configuration;

using System.Text;

using System.Drawing;



namespace VXUK2

{

  public partial class booking_system : System.Web.UI.Page

  {

    protected void Page_Load(object sender, EventArgs e)

    {



      // SQL Query For DropDownList1 (CIT Company)

        SqlConnection con = new SqlConnection();

        con.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\****;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con.Open();

        SqlCommand cmd = new SqlCommand("Select CIT_ID, CIT_CompanyName from CIT_Details", con);

        ddlCITCompany.DataSource = cmd.ExecuteReader();

        ddlCITCompany.DataTextField ="CIT_CompanyName";

        ddlCITCompany.DataValueField ="CIT_ID";

        ddlCITCompany.DataBind();



      // SQL Query for DropDownList2 (Site Details)

        SqlConnection con2 = new SqlConnection();

        con2.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\***;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con2.Open();

        SqlCommand cmd2 = new SqlCommand("Select Site_ID, Site_Name from Site_Details", con2);

        ddlVisitingCentre.DataSource = cmd2.ExecuteReader();

        ddlVisitingCentre.DataTextField ="Site_Name";

        ddlVisitingCentre.DataValueField ="Site_ID";

        ddlVisitingCentre.DataBind();



    }



    protected void Submit2_Click(object sender, EventArgs e)



    {



      //LocalDB Connection & Execution String

        SqlConnection con = new SqlConnection();

        con.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\***;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con.Open();

        String st ="INSERT INTO Booking_Data (Visiting_Centre, Expected_Arrival_Date, Expected_Arrival_Time, Actual_Arrival_Date, Actual_Arrival_Time, CIT_Company, Driver_Name, Vehicle_Registration, Supplied_Password, Delivery_In, Delivery_Out, Time_Booked_In, Time_Booked_Out) values (@Visiting_Centre, @Expected_Arrival_Date, @Expected_Arrival_Time, @Actual_Arrival_Date, @Actual_Arrival_Time, @CIT_Company, @Driver_Name, @Vehicle_Registration, @Supplied_Password, @Delivery_In, @Delivery_Out, @Time_Booked_In, @Time_Booked_Out)";

        SqlCommand cmd = new SqlCommand(st, con);



        cmd.Parameters.AddWithValue("@Visiting_Centre", ddlVisitingCentre.SelectedValue);

        cmd.Parameters.AddWithValue("@Expected_Arrival_Date", txtExpectedArrivalDate.Text);

        cmd.Parameters.AddWithValue("@Expected_Arrival_Time", txtExpectedArrivalTime.Text);

        cmd.Parameters.AddWithValue("@Actual_Arrival_Date", txtActualArrivalDate.Text);

        cmd.Parameters.AddWithValue("@Actual_Arrival_Time", txtActualArrivalTime.Text);

        cmd.Parameters.AddWithValue("@CIT_Company", ddlCITCompany.SelectedValue);

        cmd.Parameters.AddWithValue("@Driver_Name", txtDriverName.Text);

        cmd.Parameters.AddWithValue("@Vehicle_Registration", txtVehicleRegistration.Text);

        cmd.Parameters.AddWithValue("@Supplied_Password", txtSuppliedPassword.Text);

        cmd.Parameters.AddWithValue("@Delivery_In", txtDeliveryIn.Text);

        cmd.Parameters.AddWithValue("@Delivery_Out", txtDeliveryOut.Text);

        cmd.Parameters.AddWithValue("@Time_Booked_In", txtTimeBookedIn.Text);

        cmd.Parameters.AddWithValue("@Time_Booked_Out", txtTimeBookedOut.Text);

        cmd.ExecuteNonQuery();

        con.Close();
    protected void Page_Load(object sender, EventArgs e)

    {

      if(!IsPostBack)

      {

        //Your Code

      }



    }

等

cmd.Parameters.AddWithValue("@*", ddl*.SelectedValue);

cmd.Parameters.AddWithValue("@*", ddl*.SelectedItem.Text);

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Windows.Forms;

using System.Data;

using System.Configuration;

using System.Text;

using System.Drawing;



namespace VXUK2

{

  public partial class booking_system : System.Web.UI.Page

  {

    protected void Page_Load(object sender, EventArgs e)

    {



      // SQL Query For DropDownList1 (CIT Company)

        SqlConnection con = new SqlConnection();

        con.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\****;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con.Open();

        SqlCommand cmd = new SqlCommand("Select CIT_ID, CIT_CompanyName from CIT_Details", con);

        ddlCITCompany.DataSource = cmd.ExecuteReader();

        ddlCITCompany.DataTextField ="CIT_CompanyName";

        ddlCITCompany.DataValueField ="CIT_ID";

        ddlCITCompany.DataBind();



      // SQL Query for DropDownList2 (Site Details)

        SqlConnection con2 = new SqlConnection();

        con2.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\***;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con2.Open();

        SqlCommand cmd2 = new SqlCommand("Select Site_ID, Site_Name from Site_Details", con2);

        ddlVisitingCentre.DataSource = cmd2.ExecuteReader();

        ddlVisitingCentre.DataTextField ="Site_Name";

        ddlVisitingCentre.DataValueField ="Site_ID";

        ddlVisitingCentre.DataBind();



    }



    protected void Submit2_Click(object sender, EventArgs e)



    {



      //LocalDB Connection & Execution String

        SqlConnection con = new SqlConnection();

        con.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\***;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con.Open();

        String st ="INSERT INTO Booking_Data (Visiting_Centre, Expected_Arrival_Date, Expected_Arrival_Time, Actual_Arrival_Date, Actual_Arrival_Time, CIT_Company, Driver_Name, Vehicle_Registration, Supplied_Password, Delivery_In, Delivery_Out, Time_Booked_In, Time_Booked_Out) values (@Visiting_Centre, @Expected_Arrival_Date, @Expected_Arrival_Time, @Actual_Arrival_Date, @Actual_Arrival_Time, @CIT_Company, @Driver_Name, @Vehicle_Registration, @Supplied_Password, @Delivery_In, @Delivery_Out, @Time_Booked_In, @Time_Booked_Out)";

        SqlCommand cmd = new SqlCommand(st, con);



        cmd.Parameters.AddWithValue("@Visiting_Centre", ddlVisitingCentre.SelectedValue);

        cmd.Parameters.AddWithValue("@Expected_Arrival_Date", txtExpectedArrivalDate.Text);

        cmd.Parameters.AddWithValue("@Expected_Arrival_Time", txtExpectedArrivalTime.Text);

        cmd.Parameters.AddWithValue("@Actual_Arrival_Date", txtActualArrivalDate.Text);

        cmd.Parameters.AddWithValue("@Actual_Arrival_Time", txtActualArrivalTime.Text);

        cmd.Parameters.AddWithValue("@CIT_Company", ddlCITCompany.SelectedValue);

        cmd.Parameters.AddWithValue("@Driver_Name", txtDriverName.Text);

        cmd.Parameters.AddWithValue("@Vehicle_Registration", txtVehicleRegistration.Text);

        cmd.Parameters.AddWithValue("@Supplied_Password", txtSuppliedPassword.Text);

        cmd.Parameters.AddWithValue("@Delivery_In", txtDeliveryIn.Text);

        cmd.Parameters.AddWithValue("@Delivery_Out", txtDeliveryOut.Text);

        cmd.Parameters.AddWithValue("@Time_Booked_In", txtTimeBookedIn.Text);

        cmd.Parameters.AddWithValue("@Time_Booked_Out", txtTimeBookedOut.Text);

        cmd.ExecuteNonQuery();

        con.Close();
    protected void Page_Load(object sender, EventArgs e)

    {

      if(!IsPostBack)

      {

        //Your Code

      }



    }

你必须添加 not isPostBack 因为每次调用它的函数都会重新加载整个网页，所以每次你可以看到第一个数据被选中。

通过添加 !IsPostBack 页面将不会隐式重新加载数据。

这可以解决您在选择数据时遇到的问题。

cmd.Parameters.AddWithValue("@*", ddl*.SelectedValue);

cmd.Parameters.AddWithValue("@*", ddl*.SelectedItem.Text);

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Windows.Forms;

using System.Data;

using System.Configuration;

using System.Text;

using System.Drawing;



namespace VXUK2

{

  public partial class booking_system : System.Web.UI.Page

  {

    protected void Page_Load(object sender, EventArgs e)

    {



      // SQL Query For DropDownList1 (CIT Company)

        SqlConnection con = new SqlConnection();

        con.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\****;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con.Open();

        SqlCommand cmd = new SqlCommand("Select CIT_ID, CIT_CompanyName from CIT_Details", con);

        ddlCITCompany.DataSource = cmd.ExecuteReader();

        ddlCITCompany.DataTextField ="CIT_CompanyName";

        ddlCITCompany.DataValueField ="CIT_ID";

        ddlCITCompany.DataBind();



      // SQL Query for DropDownList2 (Site Details)

        SqlConnection con2 = new SqlConnection();

        con2.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\***;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con2.Open();

        SqlCommand cmd2 = new SqlCommand("Select Site_ID, Site_Name from Site_Details", con2);

        ddlVisitingCentre.DataSource = cmd2.ExecuteReader();

        ddlVisitingCentre.DataTextField ="Site_Name";

        ddlVisitingCentre.DataValueField ="Site_ID";

        ddlVisitingCentre.DataBind();



    }



    protected void Submit2_Click(object sender, EventArgs e)



    {



      //LocalDB Connection & Execution String

        SqlConnection con = new SqlConnection();

        con.ConnectionString = ("Data Source=(LocalDB)\\\\MSSQLLocalDB;AttachDbFilename=C:\\\\***;Persist Security Info=True;User ID=***;Password=****;Connect Timeout=30");

        con.Open();

        String st ="INSERT INTO Booking_Data (Visiting_Centre, Expected_Arrival_Date, Expected_Arrival_Time, Actual_Arrival_Date, Actual_Arrival_Time, CIT_Company, Driver_Name, Vehicle_Registration, Supplied_Password, Delivery_In, Delivery_Out, Time_Booked_In, Time_Booked_Out) values (@Visiting_Centre, @Expected_Arrival_Date, @Expected_Arrival_Time, @Actual_Arrival_Date, @Actual_Arrival_Time, @CIT_Company, @Driver_Name, @Vehicle_Registration, @Supplied_Password, @Delivery_In, @Delivery_Out, @Time_Booked_In, @Time_Booked_Out)";

        SqlCommand cmd = new SqlCommand(st, con);



        cmd.Parameters.AddWithValue("@Visiting_Centre", ddlVisitingCentre.SelectedValue);

        cmd.Parameters.AddWithValue("@Expected_Arrival_Date", txtExpectedArrivalDate.Text);

        cmd.Parameters.AddWithValue("@Expected_Arrival_Time", txtExpectedArrivalTime.Text);

        cmd.Parameters.AddWithValue("@Actual_Arrival_Date", txtActualArrivalDate.Text);

        cmd.Parameters.AddWithValue("@Actual_Arrival_Time", txtActualArrivalTime.Text);

        cmd.Parameters.AddWithValue("@CIT_Company", ddlCITCompany.SelectedValue);

        cmd.Parameters.AddWithValue("@Driver_Name", txtDriverName.Text);

        cmd.Parameters.AddWithValue("@Vehicle_Registration", txtVehicleRegistration.Text);

        cmd.Parameters.AddWithValue("@Supplied_Password", txtSuppliedPassword.Text);

        cmd.Parameters.AddWithValue("@Delivery_In", txtDeliveryIn.Text);

        cmd.Parameters.AddWithValue("@Delivery_Out", txtDeliveryOut.Text);

        cmd.Parameters.AddWithValue("@Time_Booked_In", txtTimeBookedIn.Text);

        cmd.Parameters.AddWithValue("@Time_Booked_Out", txtTimeBookedOut.Text);

        cmd.ExecuteNonQuery();

        con.Close();
    protected void Page_Load(object sender, EventArgs e)

    {

      if(!IsPostBack)

      {

        //Your Code

      }



    }
赞 (0)
« 上一篇
下一篇 »

相关推荐

  • Spring部署设置openshift

    Springdeploymentsettingsopenshift我有一个问题让我抓狂了三天。我根据OpenShift帐户上的教程部署了spring-eap6-quickstart代码。我已配置调试选项，并且已将Eclipse工作区与OpehShift服务器同步-服务器上的一切工作正常，但在Eclipse中出现无法消除的错误。我有这个错误：cvc-complex-type.2.4.a:Invali…
    2025-04-161

  • 检查Java中正则表达式中模式的第n次出现

    CheckfornthoccurrenceofpatterninregularexpressioninJava本问题已经有最佳答案，请猛点这里访问。我想使用Java正则表达式检查输入字符串中特定模式的第n次出现。你能建议怎么做吗？这应该可以工作：MatchResultfindNthOccurance(intn,Patternp,CharSequencesrc){Matcherm=p.matcher…
    2025-04-161

  • 如何让 JTable 停留在已编辑的单元格上

    HowtohaveJTablestayingontheeditedcell如果有人编辑JTable的单元格内容并按Enter，则内容会被修改并且表格选择会移动到下一行。是否可以禁止JTable在单元格编辑后转到下一行？原因是我的程序使用ListSelectionListener在单元格选择上同步了其他一些小部件，并且我不想在编辑当前单元格后选择下一行。Enter的默认绑定是名为selectNext…
    2025-04-161

  • Weblogic 12c 部署

    Weblogic12cdeploy我正在尝试将我的应用程序从Tomcat迁移到Weblogic12.2.1.3.0。我能够毫无错误地部署应用程序，但我遇到了与持久性提供程序相关的运行时错误。这是堆栈跟踪：javax.validation.ValidationException:CalltoTraversableResolver.isReachable()threwanexceptionatorg.…
    2025-04-161

  • Resteasy Content-Type 默认值

    ResteasyContent-Typedefaults我正在使用Resteasy编写一个可以返回JSON和XML的应用程序，但可以选择默认为XML。这是我的方法：@GET@Path("/content")@Produces({MediaType.APPLICATION_XML,MediaType.APPLICATION_JSON})publicStringcontentListRequestXm…
    2025-04-161

  • 代码不会停止运行，在 Java 中

    thecodedoesn'tstoprunning,inJava我正在用Java解决项目Euler中的问题10，即"Thesumoftheprimesbelow10is2+3+5+7=17.Findthesumofalltheprimesbelowtwomillion."我的代码是packageprojecteuler_1;importjava.math.BigInteger;importjava…
    2025-04-161

  • Out of memory java heap space

    Outofmemoryjavaheapspace我正在尝试将大量文件从服务器发送到多个客户端。当我尝试发送大小为700mb的文件时，它显示了"OutOfMemoryjavaheapspace"错误。我正在使用Netbeans7.1.2版本。我还在属性中尝试了VMoption。但仍然发生同样的错误。我认为阅读整个文件存在一些问题。下面的代码最多可用于300mb。请给我一些建议。提前致谢publicc…
    2025-04-161

  • Log4j 记录到共享日志文件

    Log4jLoggingtoaSharedLogFile有没有办法将log4j日志记录事件写入也被其他应用程序写入的日志文件。其他应用程序可以是非Java应用程序。有什么缺点？锁定问题？格式化？Log4j有一个SocketAppender，它将向服务发送事件，您可以自己实现或使用与Log4j捆绑的简单实现。它还支持syslogd和Windows事件日志，这对于尝试将日志输出与来自非Java应用程序…
    2025-04-161
手机版技术脚本