Insert same row in database for multiple times

Sivajihero Hero

I need to add a same data multiple times to the database.Its working in sql, but when I apply the querry in asp.net its not working. It shows error near to 'go'. Here is my code.

protected void Button26_Click(object sender, EventArgs e)

{

Control control = null;

if (GridView1.FooterRow != null)

{

control = GridView1.FooterRow;

}

else

{

control = GridView1.Controls[0].Controls[0];

}

string SlNo = (control.FindControl("txtSlNo") as TextBox).Text;

string Code = (control.FindControl("txtcode") as TextBox).Text;

string Qty = (control.FindControl("txtqty") as TextBox).Text;

using (SqlConnection con = new SqlConnection("Data Source=xxxxx;Initial Catalog=xxxxx;User ID=xx;Password=xxxxx"))

{

using (SqlCommand cmd = new SqlCommand())

{

cmd.Connection = con;

cmd.CommandType = CommandType.Text;

cmd.CommandText = "INSERT INTO [Itable1](Num,Code,Qty) VALUES(@Num,@Code,@Qty) go 4 ";

cmd.Parameters.AddWithValue("@CODE", Code);

cmd.Parameters.AddWithValue("@Num", SlNo);

cmd.Parameters.AddWithValue("@Qty", Qty);

con.Open();

cmd.ExecuteNonQuery();

GridView1.DataBind();

BindData();

con.Close();

}

I need to insert this row 4 times in database.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
Accepted answer
Have you debugged the code? That may help you in which case you got 0. However, i have rewrite the code slighlty, try this and let me know:

public void RepeatInsertion(string Code, string SINo, int Qty, int NoOfTime)
        {
            // Loop thru it
            for (int i = 0; i < NoOfTime; i++)
            {
                using (SqlConnection con = new SqlConnection("Data Source=xxxxx;Initial Catalog=xxxxx;User ID=xx;Password=xxxxx"))
                {
                    using (SqlCommand cmd = new SqlCommand())
                    {
                        {
                            cmd.Connection = con;
                            cmd.CommandType = CommandType.Text;
                            cmd.CommandText = "INSERT INTO [Itable1](Num,Code,Qty) VALUES(@Num,@Code,@Qty)";
                            cmd.Parameters.AddWithValue("@CODE", Code);
                            cmd.Parameters.AddWithValue("@Num", SlNo);
                            cmd.Parameters.AddWithValue("@Qty", Qty);
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();
                        }
                    }
                }
            }
        }
        protected void Button26_Click(object sender, EventArgs e)
        {
                Control control = null;
                if (GridView1.FooterRow != null)
                    control = GridView1.FooterRow;
                else
                    control = GridView1.Controls[0].Controls[0];
                string SlNo = (control.FindControl("txtSlNo") as TextBox).Text;
                string Code = (control.FindControl("txtcode") as TextBox).Text;
                string Qty = (control.FindControl("txtqty") as TextBox).Text;
                RepeatInsertion(Code, SlNo, Qty,4);
                GridView1.DataBind();
                BindData();
        }

Hope this helps!
Francis Susaimichael10y ago
You are welcome! Happy to help :)
Sivajihero Hero10y ago
Thank u Francis, its working, thanks a lot for ur help
Sivajihero Hero10y ago
I have added the code like this, So first row will insert and remaining rows are come as 0 0 0 0

protected void Button26_Click(object sender, EventArgs e)
{
for (int i = 0; i < 5; i++)
{
Control control = null;
if (GridView1.FooterRow != null)
{
control = GridView1.FooterRow;
}
else
{
control = GridView1.Controls[0].Controls[0];
}
string SlNo = (control.FindControl("txtSlNo") as TextBox).Text;
string Code = (control.FindControl("txtcode") as TextBox).Text;
string Qty = (control.FindControl("txtqty") as TextBox).Text;
using (SqlConnection con = new SqlConnection("Data Source=XXXXXX;Initial Catalog=xxxxxx;User ID=XX;Password=XXXXX"))
{
using (SqlCommand cmd = new SqlCommand())
{
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO [table1](Num,Code,Qty) VALUES(@Num,@Code,@Qty) ";
cmd.Parameters.AddWithValue("@CODE", Code);
cmd.Parameters.AddWithValue("@Num", SlNo);
cmd.Parameters.AddWithValue("@Qty", Qty);
con.Open();
cmd.ExecuteNonQuery();
GridView1.DataBind();
BindData();
con.Close();
}
}
}
}
}
Francis Susaimichael10y ago
Try this:

public void RepeatInsertion(string Code, string SINo, int Qty,int NoOfTime)
{
// Loop it
for(int i=0;i< NoOfTime; i++)
{
using (SqlConnection con = new SqlConnection("Data Source=xxxxx;Initial Catalog=xxxxx;User ID=xx;Password=xxxxx"))
{
using (SqlCommand cmd = new SqlCommand())
{
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO [Itable1](Num,Code,Qty) VALUES(@Num,@Code,@Qty)";
cmd.Parameters.AddWithValue("@CODE", Code);
cmd.Parameters.AddWithValue("@Num", SlNo);
cmd.Parameters.AddWithValue("@Qty", Qty);
con.Open();
cmd.ExecuteNonQuery();
GridView1.DataBind();
BindData();
con.Close();
}
}
}
Sivajihero Hero10y ago
Could you pls give me the code, how can I ec=xecute it in loop
Ranjit Powar10y ago
Second way is to execute query in for loop without using go.
Sivajihero Hero10y ago
So how can I do this in asp.net? pls help
Francis Susaimichael10y ago
Its working in sql, but when I apply the querry in asp.net its not working.

Because "GO" is not a transact SQL, it will only recognized inside SSMS Editor alone.

The below urls will help you to understand it better:

https://msdn.microsoft.com/en-us/library/ms188037.aspx
http://weblogs.asp.net/jongalloway/sql-using-go-100-to-execute-a-batch-100-times