private void connect_Click(object sender, EventArgs e) { DateTime beforDT = DateTime.Now; string con; //获取数据库信息 con = "Server=" + server.Text.ToString() + ";Database=" + database.Text.ToString() + ";user id=" + username.Text.ToString() + ";password="******";"; //获取数据库信息 con1 = new SqlConnection(con); //连接数据库 try //连接异常处理 { con1.Open(); } catch { MessageBox.Show("Error!"); return; } tabname = tablename.Text.ToString(); //获取目标表名 select = "select * from " + tabname + ";"; //构造查询 //Console.WriteLine("123"); myda = new SqlDataAdapter(select, con); //查询所有数据 date1 = new DataSet(); myda.Fill(date1, tabname); DataColumn[] keys = new DataColumn[1]; keys[0] = date1.Tables[0].Columns["id"]; date1.Tables[0].PrimaryKey = keys; dataGridView1.DataSource = date1.Tables[0]; //将dt的第 0 个表显示到 datagridview1 ROW.Text = date1.Tables[0].Rows.Count.ToString(); //显示最大行数 COL.Text = date1.Tables[0].Columns.Count.ToString(); //显示最大列数 ROW.Show(); COL.Show(); DateTime afterDT = DateTime.Now; TimeSpan ts = afterDT.Subtract(beforDT); //MessageBox.Show("水印添加完成!"); Console.WriteLine("DateTime总共花费{0}ms.", ts.TotalMilliseconds); }