Master help me look at this problem on the DataGridView, I do not understand, please give pointers (thanks)

withsprite

In VS, I used the data source to create a DataSet. After binding to the DataGridView, the groupid field is not displayed on the DataGridView, but the groupid cannot be empty. (The primary key of the table is ID)
When you create a new DataGridView, execute the InsertCommand, and the CommandText is "insert into personlist (groupid, name, sex) values ​​(@ groupid, @ name, @ sex)"
@name and @sex can be entered in the DataGridView cell, what can I do to assign a value to @groupid.
I use a DataSet created by a data source. Can I also use insertCommand.Parameters.Add ("@ groupid", SqlDbType.Int, 4) .Value to assign a value to @groupid?
If so, how can I call the insertCommand command.
If not, how can I deal with this problem?

happycat12

I ’m a novice, I do n’t know if it ’s right. I suggest you bind the DataSet manually instead of binding the DataSet with a data source

迷途精灵

id can use self-increasing type, or take the maximum value in the table and add 1 to the id

withsprite

Upstairs, not the id, but the groupid. In short, it is how to set the value of the column that is not displayed on the DataGridView, and then store it in the database.

迷途精灵

迷途精灵

It ’s really not teachable, ca n’t you be more flexible?
Is it okay if I write the id and replace it with groupid?
The idea has been given to you, do I have to write it down sentence by sentence, even the semicolon?

shygza

When binding to the DataGridView, it is sufficient not to add the groupid attribute column to the Columns property of the DataGridView. groupid column assignment

withsprite

迷途精灵I describe the error, I want to assign TreeView.SelectedNode.Tag to @groupid in insertCommand.CommandText, do not automatically increase.

shygza, I just don’t know how to assign a value to @groupid before executing TableAdapter.Update(). My DataSet is created by a data source? Can you tell me.