skip to content »

Updating is not supported by data source sqldatasource1 unless updatecommand

When the event makes it back to the server, to have the Button cause the Grid View and thus the Sql Data Source to trigger the Delete Command the Command Name on the Button must be the well-known value "Delete".-Brock When you use a Sql Data Source to hook up data to a Grid View it seems to be to be very inflexible.

updating is not supported by data source sqldatasource1 unless updatecommand-48updating is not supported by data source sqldatasource1 unless updatecommand-71

lv2 now problem is inserting record in nested list view see error...For a live example that demonstrates automatic data source operations, see Automatic operations.And go here to check for the right connection string, if the one I pasted will not work.I tried the connection string you currently suggested, but it's still the same error..Check these two out: Connecting to a Local SQL Server Express Instance: I tried again the two strings , but still the error says: A network-related or instance-specific error occurred while establishing a connection to SQL Server.-------------- One more thing to mention: Go to SQL Server Management Studio, Right click on the database, select properties, select Security, Click ON I got the connection string in this reference is the database i created at SQL Server Management Studion, it contains 4 tables dbo.login, dbo.cart, dbo.userdetails,and dbo.dresses.

If so, you must include "SQLExpress" keyword in the conn.string.

Whenever I do this with a Sql Data Source, I get the error 'Deleting is not supported by data source 'Sql Data Source1' unless Delete Command is specified.' Which means I have to specify a sproc or text to use as the Delete and I can't use my popup etc. Here is my code : protected void Grid View1_Row Data Bound(object sender, Grid View Row Event Args e) protected void Grid View1_Row Command(object sender, Grid View Command Event Args e) { if (e.

Command Name == "Delete") *** Sent via Developersdex You can always use a Template Column and put your own Button with a On Client Click property where you use a prompt().

providers that do not support named parameters in SQL statements and instead use the '? In those cases you should define parameters in the order specified in the associated SQL statement.

events before it executes the SQL statement for the corresponding command property.

I've been working on our Software Analysis Development project for how many days and sleepless nights, the application is an Online Shopping.