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();//关闭数据库 }