A little fun question!

sonicliao

A SqlDataSource, its select insert update delete is set.
Put another gridview
If you set the data source of the GridView through smart tags in the design state: SqlDataSource1. After the program runs, everything works fine. You can perform the above four operations.
However, in the setting state, the data source is not set for the GridView, but is set in the program: Page_Load.
GridView1. DataSource = SqlDataSource1;
GridView1. DataBind ();

Well. Data will not be updated.

Excuse me, why? If I write the binding in other events, how can I see the data every time I refresh the page?

头不晕

Are the parameters set?

yfacmilan

Page_Load binds the data source. You need to write update code and rebind after the update.

wangningly

If you want to bind the gridview in the background and update and delete the relevant code, you cannot use it directly. Provide a delete operation.
protected void GridView1_RowDeleting (object sender, GridViewDeleteEventArgs e)
    {
        int index = e.RowIndex;
        int LogID = (int) GridView1.DataKeys [index] .Value; // take the primary key
        Use this primary key for operations
    }

mgcfox

After working for a long time, but did not figure out the final result, some findings:
To bind the data source of the GridView in the background and update it,
To implement the GridView event OnRowEditing, it will not report an error after adding it, but there is no editing function.
To edit, I guess I have to handle it in the OnRowDataBound event of the GridView.
Add the TextBox or something manually, and then bind the data.
Limited ability, look forward to expert guidance.

leowu797

Put it under the Page_PreInit event

sonicliao

My method is stupid. I can only say that it is implemented, but I don't think it is scientific: that is, manually writing the update code.
Use edittemplate, then when the update operation, manually get the control value, and then use sqldatasource.updata to update.
It's just that stupid.

I can't figure out why program binding is different from design state binding.

德鲁伊

On the button?

qyqy0616

Do you want to select the AllowEdit checkbox and write an OnRowUpdating event!

xing_532

GridView1.DataSourceID = SqlDataSource1;