删除一列 再添加一列 怎样让自动增长列从上一列的值累加啊?
就是删除了id(自增长)为3的一列数据
再添加id还是3
删除一列 再添加一列 怎样让自动增长列从上一列的值累加啊?
答案:2 悬赏:70
解决时间 2021-02-03 01:03
- 提问者网友:无依无靠的距离
- 2021-02-02 22:15
最佳答案
- 二级知识专家网友:木子香沫兮
- 2021-02-02 23:35
private void Form1_Load(object sender, EventArgs e)
{
DataBound();
}
///
/// 绑定数据
///
private void DataBound()
{
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=123321;database=pubs");
SqlDataAdapter da = new SqlDataAdapter("select * from jobs");
DataSet ds=new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
}
///
/// 删除按钮
///
///
///
private void button1_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells["选择"].EditedFormattedValue.ToString().Equals("True"))
{
//删除吧
DataBound();
}
}
}
///
/// 全选+反选
///
///
///
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (this.checkBox1.Checked)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
this.dataGridView1.Rows[i].Cells["选择"].Value = true;
}
}
else
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
this.dataGridView1.Rows[i].Cells["选择"].Value = false;
}
}
}
哈哈!专门为你写的!感动吧!
不明白就发消息呗!
{
DataBound();
}
///
/// 绑定数据
///
private void DataBound()
{
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=123321;database=pubs");
SqlDataAdapter da = new SqlDataAdapter("select * from jobs");
DataSet ds=new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
}
///
/// 删除按钮
///
///
///
private void button1_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells["选择"].EditedFormattedValue.ToString().Equals("True"))
{
//删除吧
DataBound();
}
}
}
///
/// 全选+反选
///
///
///
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (this.checkBox1.Checked)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
this.dataGridView1.Rows[i].Cells["选择"].Value = true;
}
}
else
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
this.dataGridView1.Rows[i].Cells["选择"].Value = false;
}
}
}
哈哈!专门为你写的!感动吧!
不明白就发消息呗!
全部回答
- 1楼网友:抱不住太阳的深海
- 2021-02-02 23:40
你好!
计数值也变跟着删除1就行了啊
打字不易,采纳哦!
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯