目前,我将datagrid1实现了绑定!代码如下:
SqlConnection sql = new SqlConnection(Form1.sqlstr);
if (treeView1.SelectedNode.Name == "全部")
{
name = "select id,xq,tq,rq,sj,rq+' '+sj as rqsj,bt,nr from bjb where rq='" + m1.SelectionStart.ToShortDateString() + "' and fl='" + node + "'";
}
else
{ name = "select id,xq,tq,rq,sj,rq+' '+sj as rqsj,bt,nr from bjb where fl='" + node + "' and rq='" + m1.SelectionStart.ToShortDateString() + "'";
}
SqlDataAdapter sda = new SqlDataAdapter(name, sql); ds = new DataSet();
sql.Open();
SqlCommand sqlc = new SqlCommand(name, sql);
sda.Fill(ds, "t1");
dataGrid1.SetDataBinding(ds, "t1"); SqlDataReader sdr = sqlc.ExecuteReader();
if (sdr.Read())
{
dateTimePicker1.Enabled = true;
mb1.Enabled = true;
comboBox3.Enabled = true;
comboBox4.Enabled = true;
textBox1.Enabled = true;
richTextBox1.Enabled = true;
///////////////////////////////////////////////////
label7.DataBindings.Add("text", ds, "t1.id");
comboBox3.DataBindings.Add("text", ds, "t1.xq");
comboBox4.DataBindings.Add("text", ds, "t1.tq");
/////////////////////
dateTimePicker1.DataBindings.Add("text", ds, "t1.rq");
mb1.DataBindings.Add("text", ds, "t1.sj");
textBox1.DataBindings.Add("text", ds, "t1.bt");
richTextBox1.DataBindings.Add("text", ds, "t1.nr"); }
完了,现在有一个‘新建’按钮,单击的事件代码为:
dateTimePicker1.Enabled = true;
mb1.Enabled = true;
comboBox3.Enabled = true;
comboBox4.Enabled = true;
textBox1.Enabled = true;
richTextBox1.Enabled = true;
DataRow dr = ds.Tables["t1"].NewRow();
ds.Tables["t1"].Rows.Add(dr);
为什么,点击‘新建’以后,datagrid1中最左侧的小箭头还是在第一行啊?没有自动跳到新增加的这行上?这是为什么??
请帮忙解决!谢谢!
SqlConnection sql = new SqlConnection(Form1.sqlstr);
if (treeView1.SelectedNode.Name == "全部")
{
name = "select id,xq,tq,rq,sj,rq+' '+sj as rqsj,bt,nr from bjb where rq='" + m1.SelectionStart.ToShortDateString() + "' and fl='" + node + "'";
}
else
{ name = "select id,xq,tq,rq,sj,rq+' '+sj as rqsj,bt,nr from bjb where fl='" + node + "' and rq='" + m1.SelectionStart.ToShortDateString() + "'";
}
SqlDataAdapter sda = new SqlDataAdapter(name, sql); ds = new DataSet();
sql.Open();
SqlCommand sqlc = new SqlCommand(name, sql);
sda.Fill(ds, "t1");
dataGrid1.SetDataBinding(ds, "t1"); SqlDataReader sdr = sqlc.ExecuteReader();
if (sdr.Read())
{
dateTimePicker1.Enabled = true;
mb1.Enabled = true;
comboBox3.Enabled = true;
comboBox4.Enabled = true;
textBox1.Enabled = true;
richTextBox1.Enabled = true;
///////////////////////////////////////////////////
label7.DataBindings.Add("text", ds, "t1.id");
comboBox3.DataBindings.Add("text", ds, "t1.xq");
comboBox4.DataBindings.Add("text", ds, "t1.tq");
/////////////////////
dateTimePicker1.DataBindings.Add("text", ds, "t1.rq");
mb1.DataBindings.Add("text", ds, "t1.sj");
textBox1.DataBindings.Add("text", ds, "t1.bt");
richTextBox1.DataBindings.Add("text", ds, "t1.nr"); }
完了,现在有一个‘新建’按钮,单击的事件代码为:
dateTimePicker1.Enabled = true;
mb1.Enabled = true;
comboBox3.Enabled = true;
comboBox4.Enabled = true;
textBox1.Enabled = true;
richTextBox1.Enabled = true;
DataRow dr = ds.Tables["t1"].NewRow();
ds.Tables["t1"].Rows.Add(dr);
为什么,点击‘新建’以后,datagrid1中最左侧的小箭头还是在第一行啊?没有自动跳到新增加的这行上?这是为什么??
请帮忙解决!谢谢!
也可以解决!