Questions tagged [updatecommand]
47 questions
0
votes
1 answer
SqlDataSource UpdateParameters - Input string was not in a correct format
I have inherited some ASP.NET code that I need to update which has resulted in my needing to change the ASP SqlDataSource's UpdateCommandType from a string (hard coded SQL Update statement) to a stored procedure containing the Update statement.
The…

CJH
- 1,266
- 2
- 27
- 61
0
votes
1 answer
unable to update in gridview when require validation occur in textbox
I want to modify items in gridview by update command but in same page i have also a textbox with required validation.
i'm unable to update in gridview when require validation occur in textbox Control
And Source Code here...
…

KKDev
- 141
- 1
- 3
- 17
0
votes
0 answers
Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column
I have set PK for all Admin tables. They were working fine in the website.
It's still working in the VM, when I debug the application using F5.
But the same code when deployed to IIS website, throwing this error all of the sudden. I didn't change…

Jay
- 11
- 2
0
votes
1 answer
(Object reference not set to an instance of an object) on updating sql table
I'm trying to update a field in a table of the database when I keep getting the following error
Object reference not set to an instance of an object.
Code:
public void WILF(string whatIsPlaying)
{
using (SqlConnection con = new…

CodeMonkey
- 2,511
- 4
- 27
- 38
0
votes
3 answers
How to automatically click "update" button in asp.net control?
I used asp.net server side control to display and modify data in database, the control is just like this one:
http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/alleditablecolumns/defaultcs.aspx
what I want to do is after I click the…

MemoryLeak
- 7,322
- 23
- 90
- 133
0
votes
1 answer
Add Unique Column Name to Access Database via Application - C#
I have a program which records ID,Name,TimeIn,TimeOut. On the first scan of a card it record the id,name and timein, and then on second swipe it adds to the timeout column. I am trying to get it to add another "TimeIn" column on the third swipe, so…

Ryan Gillooly
- 315
- 1
- 5
- 20
0
votes
0 answers
Incorrect syntax near 'int' when using updatecommand on a gridview
I have a problem that when ever I try to update a record in the database using gridview update event handler and an updatecommand in sqldatascource
I get the following exception
Incorrect syntax near 'int'.
the weird thing is when I reload the page…

Scarnet
- 738
- 2
- 11
- 36
0
votes
1 answer
Function or procedure has too many arguments specified when I'm using a SqlDataSource's UpdateCommand
I'm using a gridview with editing and updating enabled and using the UpdateCommand in the SqlDataSource to update the data. But whenever I try to update a record I get the exception
Function or procedure has too many arguments specified
Code: …

Scarnet
- 738
- 2
- 11
- 36
0
votes
1 answer
UpdateCommand problem in a TemplateField in asp.net GridView
I have the following grid:
asp.net
gridview
datagridview
updatecommand
controlparameter

Shankar
- 1,634
- 1
- 18
- 23
0
votes
1 answer
Update command can't find the correct value of the control
I have created a table in side the edititemtamlate of grid view.
<%-- --%>
…
![]()
Hiral Bavisi
0
votes
0 answers
Gridview using sqldatasourceIm working using Gridview and Sqldatasource, so , when Im tried to use the updatecommand, but when I clicked on, nothing happen, so, if I save a new record and after click on update command button , so , it works well. do you have any idea about…
![]()
Jeil
0
votes
1 answer
does update command to mongodb database from python returns result of query(e.g. boolean or integer)I'm very new to Python. In my script I have written code to update MongoDB database.
def mongoInsert(userData, collection):
mconn = Connection(MONGODB_HOST,MONGODB_PORT)
mdb = mconn[MONGODB_DBNAME]
col = mdb[collection]
#The below…
![]()
Shirish Herwade
0
votes
2 answers
How to set parameters for SqlDataSource UpdateCommandFor a Gridview:
I am trying to use a stored procedure for the first time in a SQLDataSource for the UpdateCommand:
![]()
Baxter
0
votes
2 answers
Gridview updatecommand not working with 2 worded database columnsHere is a working version of the gridview updatecommand
![]()
kev670
-1
votes
2 answers
How to change values of column of DataTable and show only in DataGrid not updating actual table of databaseI have a column with encrypted name(all other columns are not encrypted) in SQL Database table. And I have to decrypt the column with encrypted name to show in DataGrid to users of my application but the actual table of SQL database should not be…
![]()
Kay Lee
|