多线程插入多个表

combuu 2014-04-06 09:15:41

我用多个线程插入多个表，最后提示超过服务期等待时间
不过数据库中都插入了数据，test和test2表中有199条数据，test1中有198条数据
求大神看看哪错了
报错如下

代码：



using System.Collections.Generic;

using System.Data.SqlClient;

using System.Diagnostics;

using System.Linq;

using System.Text;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Threading;



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

{

    public void write(object con)

    {

        Response.Write("线程1执行<br>");

        SqlConnection conn = (SqlConnection)con;

        SqlCommand cmd = conn.CreateCommand();

        for (int i = 1; i < 200; i++)

        {

            cmd.CommandText = "insert into test(name) values ('huhu" + i.ToString() + "')";

            cmd.ExecuteNonQuery();

        }

        Response.Write("线程1执行完毕<br>");

    }



    public void write1(object con)

    {

        Response.Write("线程2执行<br>");

        SqlConnection conn = (SqlConnection)con;

        SqlCommand cmd1 = conn.CreateCommand();

        for (int j = 1; j < 200; j++)

       {

            cmd1.CommandText = "insert into test1(name) values ('huhu" + j.ToString() + "')";

            cmd1.ExecuteNonQuery();

        }

        Response.Write("线程2执行完毕<br>");

    }

    public void write2(object con)

    {

        Response.Write("线程3执行<br>");        

        SqlConnection conn = (SqlConnection)con;

        SqlCommand cmd2 = conn.CreateCommand();

        for (int k = 1; k < 200; k++)

        {

            cmd2.CommandText = "insert into test2(name) values ('huhu" + k.ToString() + "')";

            cmd2.ExecuteNonQuery();

        }

        Response.Write("线程3执行完毕<br>");

    }



    public void btnnn(object sender, EventArgs e)

    {

        



        String ConnectionString = "Data Source=localhost;Initial Catalog=mydb;uid=sa;pwd=sa";

        SqlConnection con = new SqlConnection(ConnectionString);        

        con.Open();          

            Thread thread = new Thread(new ParameterizedThreadStart(write));

            Thread thread1 = new Thread(new ParameterizedThreadStart(write1));

            Thread thread2 = new Thread(new ParameterizedThreadStart(write2));

            thread.Start(con);

            thread1.Start(con);

            thread2.Start(con);

            thread.Join();

            thread1.Join();

            thread2.Join();

            con.Close();

            Response.Write("执行完毕");

    }

}