static SqlConnection GetConnection()
{
SqlConnection con = new SqlConnection();
con.ConnectionString = LoadConfig.GetConnStrings();
con.Open();
return(con);
}
public static SqlConnection GetConnection()
{
if (con == null)
{
con = new SqlConnection();
con.ConnectionString = LoadConfig.GetConnStrings();
con.Open();
}
return(con);
}
public static void Run()
{
con = new SqlConnection();
con.ConnectionString = LoadConfig.GetConnStrings();
con.Open();
com = new SqlCommand();
com.Connection = con;
com.CommandTimeout = 180;
RunSingleThread();
RunMultiThread();
}
private void ShowData_Load(object sender, EventArgs e)
{
//先打开两个类库文件
SqlConnection con = new SqlConnection();
// con.ConnectionString = "server=505-03;database=ttt;user=sa;pwd=123";
con.ConnectionString = LoadConfig.GetConnStrings();
con.Open();
/*
* SqlDataAdapter 对象。 用于填充DataSet （数据集）。
* SqlDataReader 对象。 从数据库中读取流..
* 后面要做增删改查还需要用到 DataSet 对象。
*/
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.Text;
com.CommandText = "SELECT * FROM [User]";
SqlDataReader dr = com.ExecuteReader();//执行SQL语句
dr.Close();
DataSet dataSet = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select top 1000 * from [user] order by id", con); //绑定的sql命令
adapter.Fill(dataSet, "userinfo"); //将数据获取后装载到dataSet中，当作一张表存储在内存中
DataTable dt = dataSet.Tables["userinfo"];
data_grid.DataSource = dt;
int index = 1;
foreach (DataRow drow in dt.Rows)
{
//Console.WriteLine(index++ + ":" + drow["id"] + "-" + drow["name"] + "-" + drow["age"] + "");
}
//for (int i = 500; i < 100000; i++)
//{
// Random r = new Random();
// int age = r.Next(60);
// char[] str = "abcdefghijklmnopqrstuvwxyz".ToArray();
// string name = "" + str[r.Next(str.Length)] + str[r.Next(str.Length)] + str[r.Next(str.Length)];
// string sql = "INSERT INTO [User] ([ID] ,[name] ,[age]) VALUES ("+i+",'"+name+"',"+age+")";
// adapter.SelectCommand= new SqlCommand(sql, con);
// adapter.Fill(dataSet,"insert");
//}
con.Close();//关闭数据库
}
public static void Run()
{
//先打开两个类库文件
SqlConnection con = new SqlConnection();
// con.ConnectionString = "server=505-03;database=ttt;user=sa;pwd=123";
con.ConnectionString = LoadConfig.GetConnStrings();
con.Open();
SqlTransaction tran = con.BeginTransaction();
new Thread(new ThreadStart(() => {
tran.Commit();
})).Start();
//tran.Dispose();
SqlTransaction tran1 = con.BeginTransaction();
bool flag = tran.Equals(tran1);
/*
* SqlDataAdapter 对象。 用于填充DataSet （数据集）。
* SqlDataReader 对象。 从数据库中读取流..
* 后面要做增删改查还需要用到 DataSet 对象。
*/
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.Text;
com.CommandText = "SELECT * FROM [User]";
SqlDataReader dr = com.ExecuteReader();//执行SQL语句
dr.Close();
DataSet dataSet = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select top 100 * from [user]", con); //绑定的sql命令
adapter.Fill(dataSet, "userinfo"); //将数据获取后装载到dataSet中，当作一张表存储在内存中
DataTable dt = dataSet.Tables[0];
Form f = new ShowData();
f.Show();
int index = 1;
foreach (DataRow drow in dt.Rows)
{
Console.WriteLine(index++ + ":" + drow["id"] + "-" + drow["name"] + "-" + drow["age"] + "");
}
//for (int i = 500; i < 100000; i++)
//{
// Random r = new Random();
// int age = r.Next(60);
// char[] str = "abcdefghijklmnopqrstuvwxyz".ToArray();
// string name = "" + str[r.Next(str.Length)] + str[r.Next(str.Length)] + str[r.Next(str.Length)];
// string sql = "INSERT INTO [User] ([ID] ,[name] ,[age]) VALUES ("+i+",'"+name+"',"+age+")";
// adapter.SelectCommand= new SqlCommand(sql, con);
// adapter.Fill(dataSet,"insert");
//}
con.Close();//关闭数据库
}
