tb_food表的结构如图一:
tb_foodtype表的结构如图二:
//获取tb_foodtype表中的所有数据 private void InitDataTable() { SqlConnection conn = BaseClass.DBConn.CyCon(); SqlCommand cmd = new SqlCommand("select * from tb_foodtype", conn); SqlDataAdapter ada = new SqlDataAdapter(cmd); dt = new DataTable();