百科游戏 手游攻略
大家好,关于bindingnavigator1很多朋友都还不太明白,今天小编就来为大家分享关于c#中bindingNavigator的用法是什么,求示范……的知识,希望对各位有所帮助!
c#中的bindingNavigator
比如:bindingNavigator1.BindingSource=BindingSource1;
bindingNavigator中的按钮事件
privatevoidtoolStripButton1_Click(objectsender,EventArgse)
{
try
{
this.BindingSource1.MoveFirst//第一条
//this.BindingSource1.MoveLast//最后一条
//this.BindingSource1.MoveNext//下一条
//this.BindingSource1.MovePrevious;//上一条
}
catch(ExceptionE)
{
MessageBox.Show("错误:"+E.Message);
}
}
c#中bindingNavigator的用法是什么,求示范……
在界面上放入bindingNavigator1,dataGridView1,button1,button2,textBox1控件,加入引用
usingSystem.Data.OracleClient;没有就自己添加引用
privateBindingSourcemyBindingSource=newBindingSource();
OracleConnectionconn=newOracleConnection("DataSource=xxx;PersistSecurityInfo=True;UserID=xxx;Password=xxx");
privatevoidForm1_Load(objectsender,EventArgse)
{
stringsql3="select*fromxxxx";
OracleCommandcmd3=newOracleCommand(sql3,conn);
OracleDataAdapteroda=newOracleDataAdapter(cmd3);
DataSetds=newDataSet();
oda.Fill(ds);
myBindingSource.DataSource=ds.Tables[0];//绑定数据源
this.bindingNavigator1.BindingSource=myBindingSource;//数据源跟bindingNavigator1控件相连
this.dataGridView1.DataSource=myBindingSource;//数据源跟dataGridView1控件相连
this.textBox1.DataBindings.Add("Text",myBindingSource,"IP");//数据源跟textBox1控件相连
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
myBindingSource.MoveNext();
}
privatevoidbutton2_Click(objectsender,EventArgse)
{
myBindingSource.MovePrevious();
}
C#中的bindingNavigator控件
BindingSource的使用
BindingSourcebs=newBindingSource();//声明绑定类
using(SqlConnectionconn=newSqlConnection(strConnecion))
{
try
{
conn.Open();//打开联结
SqlCommandcomm=conn.CreateCommand();
comm.CommandText="select*fromCustomers";//选择要查找的表
SqlDataAdapterda=newSqlDataAdapter();//声明适配器
DataSetds=newDataSet();//声明数据集
da.SelectCommand=comm;//将适配器与数据集关连
da.Fill(ds);//将表中数据填入数据集中
bs.DataSource=ds.Tables[0];//将绑定数据源中的数据连接到数据集中去.
dataGridView1.DataSource=bs;//绑定控件dataGridView
bindingNavigator1.BindingSource=bs;//绑定控件bindingNavigator
textBox1.DataBindings.Add("Text",bs,"CompanyName",true);//绑定控件textBox
comboBox1.DataSource=bs;////绑定控件comboBox
comboBox1.DisplayMember="City";//comboBox前台显示的值
comboBox1.ValueMember="City";//comboBox后台实际绑定的值
}
catch(SqlExceptionex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
好了,文章到这里就结束啦,如果本次分享的bindingnavigator1和c#中bindingNavigator的用法是什么,求示范……问题对您有所帮助,还望关注下本站哦!
- 最近发表