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);
}
