{
string sqlstr = "Server=PC-201312060007\\MSSQLSERVER2008;User Id=sa;Pwd=sa;DataBase=sqldatabasetest";
SqlConnection con = new SqlConnection(sqlstr);
con.Open();
if (con.State == ConnectionState.Open)
{
MessageBox.Show("sqldatabasetest数据库连接成功", "sql server数据库的连接");
}
else
{
MessageBox.Show("sqldatabasetest数据库连接失败", "sql server数据库的连接");
}
}
private void button2_Click(object sender, EventArgs e)
{
//string reprtpath = Application.StartupPath.Substring(0, Application.StartupPath.Substring(0, Application.StartupPath.LastIndexOf("\\")).LastIndexOf("\\"));
//reprtpath += @"\test.mdb";
//provider这个地方Microsoft.ACE.OLEDB.12.0这个可以,Microsoft.Jet.OLEDB.4.0这个也可以。
string constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + "D:\\Documents\\Visual Studio 2010\\Projects\\数据库sqlserver学习\\数据库sqlserver学习\\bin\\Debug\\test.mdb";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
if (con.State == ConnectionState.Open)
{
MessageBox.Show("access数据库连接成功", "access数据库的连接");
}
else
{
MessageBox.Show("access数据库连接失败", "access数据库的连接");
}
}
private void button3_Click(object sender, EventArgs e)
{
string constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + "D:\\Documents\\Visual Studio 2010\\Projects\\数据库sqlserver学习\\数据库sqlserver学习\\bin\\Debug\\test.accdb";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
if (con.State == ConnectionState.Open)
{
MessageBox.Show("access数据库连接成功", "access数据库的连接");
}
else
{
MessageBox.Show("access数据库连接失败", "access数据库的连接");
}
}
private void button4_Click(object sender, EventArgs e)
{
string sqlstr = "Server=PC-201312060007\\MSSQLSERVER2008;User Id=sa;Pwd=sa;DataBase=sqldatabasetest";
SqlConnection con = new SqlConnection(sqlstr);
con.Open();
SqlCommand cmdd = new SqlCommand("select * from Table1", con);
SqlDataReader drnew = cmdd.ExecuteReader();
if (drnew.HasRows)
{
while (drnew.Read())
{
listBox1.Items.Add(drnew[0].ToString());
listBox1.Items.Add(drnew[1].ToString());
listBox1.Items.Add(drnew[2].ToString());
}
}
}
private void button5_Click(object sender, EventArgs e)
{
//定义连接字符串
string sqlstr = "Server=XJSYJS-ZYW;User Id=sa;Pwd=sa;DataBase=MSSQLSERVER2008";
//创建并打开连接
SqlConnection con = new SqlConnection(sqlstr);
con.Open();
//定义datatable和dataset
DataTable dt = new DataTable("test");
dt.Clear();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
//使用sqlcommand提交查询命令
string sqlins = "insert into Table1 values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')";
SqlCommand insertcommand = new SqlCommand(sqlins, con);
int i = insertcommand.ExecuteNonQuery();
if (i < 0)
{
MessageBox.Show("tian jia shi bai");
}
//获取数据适配器
SqlDataAdapter insertsqlda = new SqlDataAdapter();
insertsqlda.SelectCommand = insertcommand;
SqlCommand querycommand = new SqlCommand("select * from Table1", con);
SqlDataAdapter querysqlda = new SqlDataAdapter();
querysqlda.SelectCommand = querycommand;
//填充dataset和datatable
insertsqlda.Fill(ds);
querysqlda.Fill(dt);
//绑定dataset数据
MessageBox.Show(ds.Tables[0].TableName.ToString());
listBox2.DataSource = ds.Tables[0].DefaultView;
listBox2.DisplayMember = "第j列";
dataGridView1.DataSource = dt.DefaultView;
//断开连接
con.Close();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
//定义连接字符串
string sqlstr = "Server=XJSYJS-ZYW;User Id=sa;Pwd=sa;DataBase=MSSQLSERVER2008";
//创建并打开连接
SqlConnection con = new SqlConnection(sqlstr);
con.Open();
//定义datatable和dataset
DataTable dt = new DataTable("test");
dt.Clear();
DataSet ds = new DataSet("good");
ds.Tables.Add(dt);
/* //使用sqlcommand提交查询命令
string sqlins = "insert into Table1 values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')";
SqlCommand insertcommand = new SqlCommand(sqlins, con);
int i = insertcommand.ExecuteNonQuery();
if (i < 0)
{
MessageBox.Show("tian jia shi bai");
}
//获取数据适配器
SqlDataAdapter insertsqlda = new SqlDataAdapter();
insertsqlda.SelectCommand = insertcommand;
* */
SqlCommand querycommand = new SqlCommand("select * from 国家级$", con);
SqlDataAdapter querysqlda = new SqlDataAdapter();
querysqlda.SelectCommand = querycommand;
//填充dataset和datatable
// insertsqlda.Fill(ds);
querysqlda.Fill(dt);
//绑定dataset数据
dataGridView1.DataSource = dt.DefaultView;
//赋值行列数
textBoxhang.Text= dataGridView1.RowCount.ToString();
textBoxlie.Text = dataGridView1.ColumnCount.ToString();
textBoxdatasetname.Text = ds.DataSetName.ToString();
//断开连接
con.Close();
}
}