wxy新人小白
2019-11-07 10:42
采纳率: 72.9%
浏览 708

在C#winform中怎么让添加一些参数后,这行数据的ID自动加一

图片说明

 private void btnAdd_Click(object sender, EventArgs e)
        {
            string dbPath = @"D:\历年高考分数.db";
            if (btnName == "添加")
            {
                if (File.Exists(dbPath))
                {

                    string sq = @"Data Source=" + dbPath;
                    m = new SQLiteConnection(sq);
                    m.Open();
                    string sql = "select * from sqlite_master where type='table' and name ='特性'";
                    SQLiteCommand command = new SQLiteCommand(sql, m);//
                    //m.Close();
                    //AddcailiaoPara1(dbPath, "特性");
                    if (command.ExecuteScalar() == null)
                    {
                        m.Close();
                        NewTable1(dbPath, "特性");
                        AddcailiaoPara1(dbPath, "特性");
                    }
                    else
                    {
                        m.Close();
                        AddcailiaoPara1(dbPath, "特性");
                    }

                }
                else
                {
                    NewDbFile(dbPath);
                    NewTable1(dbPath, "特性");
                    AddcailiaoPara1(dbPath, "特性");
                }
                Guanlicailiaoquxian.form1.LoadcailiaoPara();
                DialogResult result = MessageBox.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

        }
        public void AddcailiaoPara1(string dbPath, string tableName)
        {
            string yinsu = "";
            if (radioButton2.Checked == true) { yinsu = "紫外线"; }
            else if (radioButton1.Checked == true) { yinsu = "温度、振动"; }
            string id = ?
            //string tabText = txtName.Text + yinsu;
            //string str = "'" + txtName.Text + "'," + "'" + txtyunxinglicheng.Text + "'," + "'" + txtyingdu.Text + "'," + "'" + txtlashenqiangdu + "'," + "'" + txtladuanshenchanglv + "'," + "'" + yinsu + "'," + "'" + id + "'";
            string str = "'" + txtName.Text + "'," + "'" + txtyunxinglicheng.Text + "'," + "'" + txtyingdu.Text + "'," + "'" + txtlashenqiangdu.Text + "'," + "'" + txtladuanshenchanglv.Text + "'," + "'" + yinsu + "'," + "'" + id + "'";
            string sq = @"Data Source=" + dbPath;
            m = new SQLiteConnection(sq);
            m.Open();
            string sql = "insert into " + tableName + " (传感器型号,运行里程,硬度,拉伸强度,拉断伸长率,因素,材料特性ID) values (" + str + ")";
            SQLiteCommand command = new SQLiteCommand(sql, m);
            command.ExecuteNonQuery();
            m.Close();
        }

怎么让添加一些参数后,这行数据的ID自动加一,以便于以后根据id删除数据
string id那应该怎么写

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • threenewbee 2019-11-07 10:44
    已采纳
    已采纳该答案
    打赏 评论
  • 开局一个bug 2019-11-08 14:04

    添加前查询最后一条数据的id,然后用上一条的id+1再做添加,简单实用

    打赏 评论

相关推荐 更多相似问题