A little fun question!

teddy123

Ok. Yes. That's it.
In this case, sometimes an error will be reported!
Report an error called repeated binding data source
Therefore, if you bind in the interface and bind in the code, you can only write one of them, not both of them.

mgcfox

sonicliao

I can't figure out why program binding and design state binding are different.

---------------------------

I did not want to understand.
These two methods should be implemented if the data source of the non-DataSource control is bound in the background
GridView1_RowEditing, GridView1_RowUpdating
But now the DataSource control data source is bound, it looks like it should be the same,
I think something is wrong there, it should be relatively simple.
Hope that the master will give advice.

zhs4276689

Bind again

zhs4276689

support

soulharvest

Mark

mgcfox

I have found the answer:

protected void Page_Init(object sender, EventArgs e)
    {
        this.GridView1.DataSourceID = "AccessDataSource1";
    }

Specified here, but DataSource cannot be used, because other controls cannot be accessed at this time.

sonicliao

mgcfox.
Thank you! really. But there is still a problem.
I modified Select Updata etc. dynamically while the program was running. But Updata seems to have no effect. Because when init is bound back to the original sqldatasource1. Do you have another way?

orclee

GridView1. DataSource = SqlDataSource1;
GridView1. DataBind();
This way of writing is not to bind GridView1 to SqlDataSource1 at all, but only to bind the data obtained after SELECTing SqlDataSource1, and the UPDATE/INSERT/DELETE method is not bound at all.

The correct equivalent:
GridView1.DataSourceID = "SqlDataSource1";
// No need to execute DataBind();

mgcfox

sonicliao
I dynamically modified Select Updata while the program was running. But Updata seems to have no effect. Because it is bound back to the original sqldatasource1 during init. Do you have any other way?

------------------------
I have tested it here, and it is exactly the same as stated in the control.
If you cannot update with Update, see if DataKeyNames is not specified?
When I tested, I dragged the controls to handle everything, then deleted the DataSourceID property of the GridView in the page, and then specified it in the cs file.

奇奇怪怪

To be redefined. .
In 05 there are OnRowCancelingEdit, OnRowUpdating, and so on. .
Go and see the help of this, I tried it in your case. . . I don't want to write the edited code myself. . . But don't want to use the wizard to complete the binding. . .
Finally, write the code honestly. . .