通过一键式按钮动态多次在数据库中插入数据 [英] Insert data in database multiple times dynamically by one-click-button

问题描述

我想通过单击按钮一次插入数据，其中有一个下拉列表选择了数字和两个文本框。我选择下拉列表编号[例如2]并在两个文本框中输入数据然后单击插入按钮一次。数据在数据库表中保存多行，从下拉列表中选择多少个数字。例如 -



dropdown-list = 2,3,4; //选择任意数字在数据库表中插入多行



textbox =data; //输入数据

textbox =data; //输入数据





- 我怎么能解决这个问题，请有人给我一个完美的想法???



我尝试过：

I want to insert data by clicking button one times where there have a dropdown list selected number and two textboxes. i select dropdown list numbers [ex. 2] and give input data in two textboxes then click insert button one times. data save in the database table multiple rows, how many numbers select from dropdown list. for example-

dropdown-list = 2,3,4 ; // select any number for insert multiple rows in the database table

textbox= "data" ; // input data
textbox= "data" ; // input data


-- how can i solve this problem, please anyone give me a perfect idea???

What I have tried:

protected void ButtonArngeOffpk_Click(object sender, EventArgs e)
{
   SqlCommand insert = new SqlCommand("insert into TableAdvOffPeak(Adv_Name, Duration) values(@Adv_Name, @Duration)", con);
   insert.Parameters.AddWithValue("@Adv_Name", TextBoxCmpName.Text);
   insert.Parameters.AddWithValue("@Duration", TextBoxDrtion.Text);
        try
        {
            con.Open();
            insert.ExecuteNonQuery();

        }
        catch
        {
            con.Close();
        }
        }

推荐答案

试试这个

Try this

protected void ButtonArngeOffpk_Click(object sender, EventArgs e)
       {

           string value = DropDownList1.SelectedItem.Text;  // Get the dropdown value
           int count = 0;
           int.TryParse(value, out count);  // cast the value to integer

           for (int i = 0; i < count; i++)  // iterate it for the N times
           {

               SqlCommand insert = new SqlCommand("insert into TableAdvOffPeak(Adv_Name, Duration) values(@Adv_Name, @Duration)", con);
               insert.Parameters.AddWithValue("@Adv_Name", TextBoxCmpName.Text);
               insert.Parameters.AddWithValue("@Duration", TextBoxDrtion.Text);
               try
               {
                   con.Open();
                   insert.ExecuteNonQuery();
                   con.Close();

               }
               catch
               {

               }

           }
       }

简单地说，从下拉列表中选择一个循环吧

见下面的代码片段

Simply, put a loop on selected number from dropdownlist
see below snippet

int iCount = convert.ToInt16(dropdownlist1.value);
//loop on counter
for(int i=0; i<icount;>{
   //your insert script goes here 
}

这篇关于通过一键式按钮动态多次在数据库中插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！