Stack Overflow
Stack Overflow

Questions tagged [updatecommand]

47 questions
1
vote
1 answer

Cannot set primary key properly for table in vb.net

I've run into a bit of trouble guys. After days of labouring, debugging and researching, im on the 3rd to last line and im stuck. This isnt the full code, but the relevant parts. Dim dbProvider As String Dim dbSource As String Dim con As…
Mohjo
  • 37
  • 2
  • 7
1
vote
2 answers

Using OleDbDataAdapter to update a DataTable C#

I have been trying to use OleDbDataAdapter to update a DataTable but got confused about the commands. Since I sometimes get info from diffrent tables I can't use a CommandBuilder. So I have tried to create the commands on my on but found it hard…
gavra
  • 93
  • 1
  • 2
  • 11
0
votes
1 answer

Syntax error using INNER JOIN and SqlDataSource with MySQL

I am trying to write an update command that joins 2 tables using an SqlDataSource. I have it working with 1 table, but when I put my INNER JOIN syntax in I get thrown an error. It says "My syntax is wrong. Check MySql manual for correct syntax" Here…
EB.
  • 2,627
  • 8
  • 35
  • 55
0
votes
1 answer

Update or insert null value in uniqueidentifier column

I have a SQL Server database with a table that has a uniqueidentifier column InputID that allows null values. In my C# project, I am passing the value of InputID as object InputID to my SqlDataAdapter and there I am parsing the object as Guid if it…
Rico Strydom
  • 537
  • 1
  • 6
  • 26
0
votes
2 answers

Gridview not executing UpdateCommand

It is very funny because I use the same structure of code in 2 different projects and 1 one of them works fine but the other will just not even execute. Here is the asp.net code (BulkEditGridview is an extended control that uses gridview as base…
George
  • 163
  • 2
  • 13
0
votes
1 answer

Update Command to update multiple rows in database from ComboBox Selected Value

I know there is a lot of information out there regarding using SQL adapter to update multiple rows in the database from a Datagrid but I can't seem to find a solution after trying many different approaches. I have a SelectionChange event that…
ethanjames.2342
  • 73
  • 8
0
votes
1 answer

sql datahandling with vb.net update command

Hi Friend I Have a SqlDataBase in Which It Have Three Fields Namely **" mc , amount , customername "** Now I am Update this Fileds Using Upadte command In vb.net Form now Wat I Need is I Want To Add This New Value While Updating With the Previous…
MUKESH
  • 69
  • 1
  • 7
  • 18
0
votes
1 answer

ASPxGridView update command trigger via postback

I have a gridview with showeditbutton and shownewbutton enabled. How can i trigger post back on the page whenever a new row is added/updated ? Is there any properties similar to autopostback that can apply in gridviewcommand ? Thanks in…
Vanquisher
  • 35
  • 8
0
votes
1 answer

SqlDataSource InsertCommand and UpdateCommand throwing "illegal variable name/number""

I am trying to insert and update the table through SqlDataSource
Black
  • 1
  • 1
  • 1
  • 4
0
votes
1 answer

datepicker updating from itemtemplate

I have code to update a date from a sqldatasource updateCommand. Code:
E.D.
  • 215
  • 3
  • 16
0
votes
1 answer

NodeJS command line does not recognise 'install'

screenshot of nodeJs command line My node.js command line says 'install' is not recognised as an internal/external command when I try to update it, according to the installation instructions from a third party website. Do I need to worry about…
Rashida Islam
  • 1
  • 2
0
votes
2 answers

VB.NET - SQL UpdateCommand for table without primary key in Gridview

1) What's the syntax for a Update query for a table without a primary key in vb.net for a gridview with a checkbox? Disclaimer: Frustratingly, adding a primary key is not an option. My program is a small program in a much larger system with poor…
Brian McCarthy
  • 4,658
  • 16
  • 49
  • 66
0
votes
1 answer

update records with special conditions nhibernate

I have a table(InquiryTable) and first of all I select some records from it, after I extract these records from database, I update them into database. but I need to know how I can do these two commands simultaneously(merge them in one) by…
Elnaz Yousefi
  • 195
  • 1
  • 3
  • 17
0
votes
1 answer

Update Command not firing after Edit/Save

I have a page that is not firing the update command when making changes to the information. I have several other pages that are working just fine and I am not seeing a difference in the coding that would cause the Update to not fire when selecting…
Mike C
  • 63
  • 1
  • 11
0
votes
1 answer

Updating calculated columns in a mssql server database by Datagridview using vb.net

I have a VB.net script that puts information into a table in MSSQL database. I managed to update datas by using only datagridview. Now I am trying to figure out how to update another column in same table that refers a calculation between two other…
Macukadam
  • 45
  • 2
  • 12
1
2
3 4