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:
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
  • 91
  • 1
  • 3
  • 10
0
votes
0 answers

Gridview using sqldatasource

Im 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
  • 37
  • 1
  • 7
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
  • 11,461
  • 20
  • 72
  • 111
0
votes
2 answers

How to set parameters for SqlDataSource UpdateCommand

For a Gridview: I am trying to use a stored procedure for the first time in a SQLDataSource for the UpdateCommand:
Baxter
  • 5,633
  • 24
  • 69
  • 105
0
votes
2 answers

Gridview updatecommand not working with 2 worded database columns

Here is a working version of the gridview updatecommand
kev670
  • 810
  • 2
  • 18
  • 37
-1
votes
2 answers

How to change values of column of DataTable and show only in DataGrid not updating actual table of database

I 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
  • 922
  • 1
  • 12
  • 40