I am getting the following error when I try to update my record in a GridView. I am using a DataObjectSource and its grabbing the update from a DAL. This is the error:Index (zero based) must be greater than or equal to zero and less than the size of the argument list.This is my code where it says the error is:
[Code]....
I am not sure if I am in the right spot here because this really doesn't have to do any datacontrol but hopefully somone can give me a hand with this.
Basically I have a bunch of TextBox controls on a page that are displaying the data I want but when I try to run an UPDATE query on the record I get nothing. The record values don't update and I don't appear to get any exceptions.....I am actually kinda really baffled on this one, here is what I have for the update code: [Code]....
Btw, if there is an easier way to do this with a control I am up for suggestions as I am just going off of some of my old VB6 ways
I have the query to retrieve selected record in textbox. How to use this query to update record: I want when I enter sumit in textbox1 and click submit button then the record with ID 1 will be updated to name sumit
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT TOP 1 Name FROM Table1 Order by Id DESC", SQLData)
SQLData.Open()
Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
If dtrReader.HasRows Then
While dtrReader.Read()
TextBox1.Text = dtrReader("Name")
End While
Else
Response.Write("No customer found for the supplied ID.")
End If
dtrReader.Close()
SQLData.Close()
I am having a problem with setting a flag on sucessful completion of a record in a stored proc. I am using following code. stored proc: Update where condition.
if @@RowCount=1
update table
set ItemReviewed=1
where condition.....
select @Count=@@rowcount
here the problem is i do have 2 update statments in a single proc..if one is sucessful then its setting if others failed...I want to check both are sucessful. @count will return the bool to my code where i can move on to the next record. if some testing @@rowcount is not feasible one to use...Itemreviewed is bit field.
Inside many of my records, I have some HTML - - inside the HTML, I have a particular tag:
<code>
I'd like to change only that code to:
<pre>
But I don't want to change any other text inside any records...
What sql can I use to do something like this?
I can't for the life of me remember how to do this and I'm sure someone will answer this pretty quickly. I need to insert or update a record based on if it exists so in the SP I need to do:
SELECT * FROM table1 WHERE LinkedID = @ID Then I need to check if any rows were returned and apply it to an if statement which is where my mind is blocked.
I'm having trouble with an SQL statement. I want to have one statement that checks to see if it a record exists. If it does, then update it and if it doesnt then insert a new one in the server. Here is what I have so far:
[Code]....
I have a website where i already have User / Roles mechanism. What i am after is the if user update certain record i will include his username against that record thats easy enough. But if that row have multiple coulmns i want to save which coulmn he/she updated?How can i compare old and new data have save this information?
View 3 RepliesI am working on developing a .net application with c#. I have a remote DB server with sql server 2008. I have a process (exe) that writes to several tables including MSH table. I have anr sproc that updates message id in the MSH table. The update sproc is fired after the write process. When I put some break points in my code and run it through the debugger, the update srpoc always updates the record in the MSH table amd looks like everything is working fine. But when I remove the breakpoints and just run the application, I find that the records are not updated.. I run through the debugger again with breakpoints and copy the update command and parameters to test it running directly on sql server management studio query window, it works. No exceptions thrown, but update sproc does not work without the debugger with breakpoints on. Any clues what I should be looking for to troubleshoot?
View 4 Repliesi have in asp.net a few textboxes and i wish to update my database with the values that they encapsulate. The problem is that it doesn't work and although it doesn't work, the syntax seems correct and there are no errors present . Here is my linkbutton:
<asp:linkbutton id="clickOnSave" runat="server"
onclick="Save_Click" Text="Save Profile" />
and my update function
protected void Save_Click(object sender, EventArgs e)
{
SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = "DataSource=.\SQLEXPRESS;AttachDbFilename=C:\Users\alex\Documents\seeubook_db.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
con.Open();
String commandString = "UPDATE users SET last_name='" + Text4.Text.Trim() + "' , first_name='" + Textbox1.Text.Trim() + "' , about_me='" + Textbox5.Text.Trim() + "' , where_i_live='" + Textbox2.Text.Trim() + "' , where_i_was_born='" + Textbox3.Text.Trim() + "' , work_place='" + Textbox4.Text.Trim() + "' WHERE email='" + Session["user"] + "'";
SqlCommand sqlCmd = new SqlCommand(commandString, con);
sqlCmd.ExecuteNonQuery();
con.Close();
}
I have a button click event code block in which data should be updated to my database. After stepping through the code, the ExecuteNonQuery() executes, but no data in my database is changed. I don't think there is a problem with my code although I will include it just-in-case.
[Code]....
I'm confident that my command text and my parameter adding is correct.
I have a stored procedure which works with a temp table, and a regular sql server permanent table.en I perform an update in the stored procedure on my permanent table or temp table, the update doesnot occur? If I just manually execute the udpate code (Lines 19&20) then the update will occur. However it does not occur
in my stored procedure when I execute it from my C#. The other sql will execute but not the update?
Here is the sqldatasource config code: <asp:SqlDataSource ID="SqlDataSource1" runat="server"
View 1 RepliesThe users of my webapplication are validated using database connection. This requires each user is a sql server database user. While logging their validity is checking by trying to create a connection using userid and password entered by the user. If connection opens successfully, it is a valid user. I also have a page in application to change the password, where sp_password is used to updated database password.
string connectionString = ConfigurationManager.AppSettings["DBServerName"];
//try to create a new connection dynamically using user id and password
connectionString = connectionString + User ID=" + userId + ";Password=" + password;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
}
The problem is after i change password, and logout and try to login, i am able to login using old passwd also. The line of code which creates and open connection succeeds with both old and new password. If i stop and run the application again this works.
For right now, the View Account for an individual user has the following setup on the aspx page.
[Code]....
In the MembershipUserODS file i have the following:
[Code]....
And in the code behind page i have this...
[Code]....
The page posts, when you click the update button, but the data never changes / updates.
the site normally works fine in all popular browsers including firefox, chrome, safari and ie.
but doesn't work in ie 8 when it's redirected via a proxy server and it gives an error saying
"Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near 'DOCTYPE html PUB'."
Ajax I have used update progress. its working fine on local system, but not on web server. Actually pagepostbacks.on server there is IIS7.
View 5 RepliesI have written a script to write several values to an Access Database Table, but I need to ammend i so it checks for two values (Asset and LName) to see if they match if they do it updates the record if not it writes a new record, my script so far is as follows :
[Code]....
I'm just stuck as I can't work out the best way to do it,
I use the following coding to show a form for receiving the original record and it works:
[Code]....
And then I set the controller for edit page as the following:
[Code]....
Although it does not show any error and return to the index page, it cannot update the record because I can see the original record in the index page. Is there any mistakes I made?
I have tested the record insertion and it works. Therefore, I think it is not the problem on the database write permission.
I've been playing around with MVC lately, and was wondering how you could do this:
I have a view that displays a list of products, and against each product is a list of categories (in a combobox). I'm trying to find out how you can update a product's category when you select a category in the list. I know you could do something fairly simple with jQuery, but I'm trying to understand how submitting forms works with MVC.
Here's what I currently have:
[Code]....
But I'm not sure how to tell the controller what product needs to be updated when the form is submitted.
Here is my coding.
--------------------------------
<asp:GridView ID="gvMaster" runat="server" AutoGenerateColumns="false" CssClass="Login">
<Columns> [code]...
I clicked the edit link button the "test" will shown in the textbox.I am change to "testing" and i will click the Update button.But it store in test.i update datetime also.The datetime has been updated..How to i update the record?..
Reason: The Form again post.So i enter with the "state=edit" and the data retrieve from the DB i will shown in the Field.After the Updation function is working.So the textbox value set into the DB value.
I am impoting data from CSV file to my sql server database.
I successfully get data into datatable and using the SqlBulkCopy method to import data into database.
It's working fine.
But i want that if record id is exists then update the record do not insert that record.
updating data in the gridview by using AJAX?
Once values are entered into textboxes and saved into Database, then gridview has to update the new changes. And not by using the ajax updatepanel
We have a simple SQL Server database with an ASP.NET front end.
I can easily update a record from my browser.
Another person cannot: he edits the field and hits the "update" button, but the change is not propagated to the database. The old value remains. He is using Internet Explorer. I checked the database, and his change is not propagated. There is no error thrown.
He WAS able to edit in May. Today he can't. but I can.
I can even update it with the Google Chrome browser.
I'm using SqlDataSource and GridView
UpdateCommand
="UPDATE [MyTable] SET [Name] = @Name, [Description] = @Description, [CreatedDate] = @CreatedDate WHERE [Id] = @Id;">
when I'm trying update, I get error:"Cannot insert the value NULL into column 'CreatedDate'"
GridView displays all fileds correct includes CreatedDate.