C#连接到数据库
小弟刚刚开始学用C#来实现对数据库的连接访问。老师给了一段代码
namespace AdoTest
{
public partial class Form1 : Form
{
private SqlDataReader dr;
private DataSet ds;
private BindingSource bs;
public Form1()
{
InitializeComponent();
ds = new DataSet();
bs = new BindingSource();
}
private void ChuShiHua()
{
string ssql= "select * from student";
//SqlCommand cmd=new SqlCommand(ssql,cn);
SqlDataAdapter ad = new SqlDataAdapter(ssql,ConfigurationManager.ConnectionStrings["connString"].ConnectionString);
ds.Clear();
ad.Fill(ds, "student");
//textBox2.Text = ds.Tables["student"].Rows[0]["sname"].ToString();
bs.DataSource = ds;
bs.DataMember ="student";
bindingNavigator1.BindingSource = bs;
dataGridView1.DataSource = bs;
//dataGridView1.DataSource = ds.Tables["student"];
//textBox1.DataBindings.Add("Text", ds.Tables["student"], "sno");
//bindingSource1.DataSource = ds.Tables["student"];
//bindingNavigator1.BindingSource=new BindingSource(ds,"student");
//bindingNavigator1.BindingSource.DataMember="student";
}
private SqlDataReader dr;
private DataSet ds;
private BindingSource bs;
不明白这三行的作用,为什么要放在开头以及用PRIVATE,求大神解答,谢谢!
[解决办法]
声明变量。PRIVATE私有的,表示只能在这个类里面使用,别的类即使能调用当前类,也调用不了这些PRIVATE的变量。
[解决办法]
C#共有六种访问控制修饰符
default:default在类内部为private,在class内为internal
public:能见度最高,在任何地方均可见
private:只有在类内部可见,它是可访问性最低的修饰符
internal:在程序集内部可以进行访问,程序集外部不能进行访问(internal与protected internal的区别:当父类与子类在同一程序集时,internal成员可见,当子类与父类不在同一程序集时,子类不能访问父类的internal成员,但是子类可以访问父类的protected internal成员)
protected:保护的,它的可访问性第二低,仅次于private
protected internal:C#唯一组合修饰符