Last post May 14, 2018 07:44 AM by Fei Han - MSFT
May 03, 2018 07:06 PM|RuthlessRoth|LINK
I am moving the data from one SQL server 2015 to 2012. Made a new table in 2012 with a different name and exported the data.
I had to manually set the IDnum to increment by 1 and set the primary key.
Those setting did not come over when I exported the data from one server to the other.
On the 2015 server I used export and change the destination tables name to a new one
I changed the SQL connection to the new server in the web page..
List page lists our vendors and contact information. Simple grid with delete and edit functions
I can successfully add a new vendor to the list using the Add page. A separate pagfe for adding vendors.
I can delete the vendor from the table using the delete button in the grid of the listing page.
But I can not edit it. It opens the edit grid and appears to do everything correct but the database entry does not get changed.
I am using a IDnum field type int and is the primary key for the table. Wondering if there is a setting for the new table I missed that was on the old table in 2005 SQL
May 05, 2018 01:14 AM|Brando ZWZ|LINK
According to your description, we couldn't directly find the reason why your girdview edit template doesn't work well.
I suggest you could try below way to troubleshoot by yourself,
Firstly, I suggest you could run update sql query directly in the sql server management studio.
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;
If it could update the data inside the sql database, that means there are something wrong with the girdview generate update sql query.
I suggest you could use sql server profile to trance the gridview update query.
More details about how to trance the sql query, you could refer to below article.
May 09, 2018 04:28 PM|RuthlessRoth|LINK
Good idea. The results are I can update the table
update VendorInfo9ish set company ='QQQQQQQQQQQQQQQQQQ' where idnum=308 succeeds
I had to add the key to the table when I copied it over. I set idnum as the key.
I forgot how to set up a watch on a variable so I can see if it is getting loaded correctly.
Do you have a link to info that can help me set up a watch in VS 2015?
May 14, 2018 07:44 AM|Fei Han - MSFT|LINK
how to set up a watch on a variable so I can see if it is getting loaded correctly.
If you’d like to check and trace the values of variables while Debugging in visual studio, you can check