这是一个用C#连接数据库的代码的一部分,数据库中表名是“菜单”,我是新手,求这几行代码的含义的说明,谢谢
using System.Data.SqlClient;
using System.Configuration;……
……
private DataSet ds;
private BindingSource bs;
…………
ds = new DataSet();
bs = new BindingSource();
private void ChuShiHua()
{
string ssql = "select * from 菜单";
SqlDataAdapter ad = new SqlDataAdapter(ssql, "Data Source=PC2011102615VKX;Initial Catalog=sunny饭店;Integrated Security=True");
ds.Clear();
ad.Fill(ds, "菜单");
bs.DataSource = ds;
bs.DataMember = "菜单";
bindingNavigator1.BindingSource = bs;
dataGridView1.DataSource = bs; }
}
}
using System.Data.SqlClient;
using System.Configuration;……
……
private DataSet ds;
private BindingSource bs;
…………
ds = new DataSet();
bs = new BindingSource();
private void ChuShiHua()
{
string ssql = "select * from 菜单";
SqlDataAdapter ad = new SqlDataAdapter(ssql, "Data Source=PC2011102615VKX;Initial Catalog=sunny饭店;Integrated Security=True");
ds.Clear();
ad.Fill(ds, "菜单");
bs.DataSource = ds;
bs.DataMember = "菜单";
bindingNavigator1.BindingSource = bs;
dataGridView1.DataSource = bs; }
}
}
private void ChuShiHua()
{
//从菜单表获取所有的数据
string ssql = "select * from 菜单";
//将这些数据填充适配器 adapter
SqlDataAdapter ad = new SqlDataAdapter(ssql, "Data Source=PC2011102615VKX;Initial Catalog=sunny饭店;Integrated Security=True");
//先清空数据集
ds.Clear();
//将适配器的数据填充到数据集中
ad.Fill(ds, "菜单");
//以下是将数据集与控件绑定的操作
bs.DataSource = ds;
bs.DataMember = "菜单";
bindingNavigator1.BindingSource = bs;
dataGridView1.DataSource = bs; }
从数据库里面搜索数据通过数据适配器存储到dateset的内存表中,然后绑定到dataGridView1数据源中