C#连接数据库

//查询
try
{
      string sql = "select * from table";
      string constr = "server=.;database=DB_Name;user id=sa;password=123";
      SqlConnection objConnection = new SqlConnection(constr);
      objConnection.Open();
      SqlDataAdapter da = new SqlDataAdapter(sql, objConnection);
      DataSet ds = new DataSet();
      da.Fill(ds);
      objConnection.Close();
      Console.WriteLine(ds.Tables[0].Rows[0][0].ToString());
}
catch (Exception ee)
{
      Console.WriteLine(ee.ToString());
}


添加删除修改
try
{
      string sql = "update table set fields = value";
      string constr = "server=.;database=DB_Name;user id=sa;password=123";
      SqlConnection objConnection = new SqlConnection(constr);
      objConnection.Open();
      SqlCommand cmd = new SqlCommand(sql，objConnection);
      int res = cmd.ExecuteNonQuery();
      objConnection.Close();
      Console.WriteLine(res.ToString());
}
catch (Exception ee)
{
      Console.WriteLine(ee.ToString());
}