Multiple insert data to database using ASP.NET web form

Question

I want to insert multiple data to database by code like this :

protected void btnInsert_Click(object sender, EventArgs e)
        {
            int i = 0;
            gvHitung.DataBind();
            int Loop = gvHitung.Rows.Count;
            while (i < Loop)
            {
                DataView dv = (DataView)sdsHitung.Select(DataSourceSelectArguments.Empty);
                DataRowView drv = dv[i];
                string Kd_Modul = drv["Kd_Modul"].ToString();
                sdsDataNilai.InsertParameters.Add("Binusian_Id",tbBinId.Text);
                sdsDataNilai.InsertParameters.Add("Kd_Jurusan",tbKdJur.Text);
                sdsDataNilai.InsertParameters.Add("Angkatan",tbAngkatan.Text);
                sdsDataNilai.InsertParameters.Add("Kd_Modul",Kd_Modul);
                sdsDataNilai.Insert();
                i++;
            }
            gvDataNilai.DataBind();
        }

but finally got error message

"The variable name '@Binusian_Id' has already been declared. Variable names must be unique within a query batch or stored procedure."

when I redebug the program, I just saw I record saved. do you have any idea?

Soner Gönül · Accepted Answer · 2014-05-09 11:12:02Z

1

Because in every iteration in your while statement, you try add these parameters one by one again.

It is ok in the first iteration because it doesn't have any parameter at the begining. But in second iteration, your command already has these parameters. That's why you get error like;

Hey buddy, your command has already have a parameter called @Binusian_Id, why do you want to add the same parameter again?

You need clear your parameters with SqlParameterCollection.Clear method before you add them again like;

sdsDataNilai.InsertParameters.Clear();
sdsDataNilai.InsertParameters.Add("Binusian_Id",tbBinId.Text);
sdsDataNilai.InsertParameters.Add("Kd_Jurusan",tbKdJur.Text);
sdsDataNilai.InsertParameters.Add("Angkatan",tbAngkatan.Text);
sdsDataNilai.InsertParameters.Add("Kd_Modul",Kd_Modul);

edited May 9, 2014 at 11:12

answered May 9, 2014 at 10:49

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple insert data to database using ASP.NET web form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related