I am just starting to use linq to sql for data access. It is working fine for read only. But it does not work for update. I have been reading the threads over several forums. It is clear that anonymous types (in my case var) cannot be updated. I cannot find what I should replace the var with and where I find it.
Below is the code. The exception is
Error 1 Property or indexer 'AnonymousType#1.date_last_logon' cannot be assigned to -- it is read only
fmcsaDataContext db = new fmcsaDataContext(); // DataTable _UserTable; UserModel _UserModel = new UserModel(); var users = from u in db.FMCSA_USERs where u.USER_NAME == pName && u.ACTIVE == true select new { date_last_logon = u.DATE_LAST_LOGON, date_current_logon = u.DATE_CURRENT_LOGON, failed_login = u.FAILED_LOGIN, }; if (users.Count() == 0) return null; foreach (var user in users) { user.date_last_logon = user.date_current_logon; }
My project includes a grid view with some updtable fields, some fields throw an error on update and some do not and it does not really make sense. WORK_STATION_ID does not cause an error, ROOM _ID cause an error, both are int? (I am using c#) and for update I use the code liste below.
I have a parent gridview which has a child gridview in the itemsTemplate. Both are binded to different SqlDataSources. I can successfully update and delete rows in the child gridview. After updating in the child gridview, some related data in the parent gridview are not updated automatically. So i have placed ParentGridview.Databind() in the rowupdated event of child gridview. But it doesnt look working.
I am using LINQ to SQL and on my DetailsView it updates fine but with my gridview it is not. Both I used template fields so I am not sure what the issue is?
[Code]....
[Code]....
[Code]....
I have been doing a lot of reading and searching and I cannot figure out why this is not working for me.
I have an asp.net page with a gridview control on it but I want to allow the user to also be able to update the selected row from a series of textboxes. I simply need the code for a button click event to do this.
button is called button1 textbox is called textbox1 gridview control is named gridview1 record to be modified is in 3rd column called PlayerName
The row to be edited will always be the only record shown and will always be selected by code I've already written. I will also need to know if the record must be set to edit mode to make the button click code work.
I'm just wondering if anyone has come across a good, easy method for updating a SQL Server 2000 DB table using the edit feature in GridView. The catch here is that I need it to encrypt, send to database, then decrypt when the page calls it to be displayed. I have successfully implemented an insert method using FormView with encryption. For some reason, I just can't seem to figure out the edit/update.
I have a gridview based on a sqldatasource that has some colums from which two colums showing the data of two fields: field1 and field2. field1 is an ID which should not be updated and therefore it is readonly=true. The sql-query from the sqldatasource is:
SelectCommand="SELECT field1, field2 from anyView"
What I want is, that when a row is updated, then the value from field1 should be copied to field2 The update-query is:
UpdateCommand="UPDATE myTable SET field2=@field2 WHERE field1=@field1"
My idea was, that the @field2 paramter gets the value from the query string out of field1:
But this does not work. Is there an easy way to copy the data from field1 to field2 when updating the row? In addition, is this possible, even if field2 ist not shown in the gridview (i.e. field2 is selected in the query but is not a field in the gridview but should be updated with value of field1).
I'm using ADO.Net code to access and update the data from the database. I'm using GridView for presentation. I wish to preserve old values of all the columns while updaing the records.
I'm using Code behind and not d Data Source controls. I wish to list the old records once record is updated.
It does not give me any errors and seems to work but the grid view cell do not take this session. When I'm clicking on the edit hyperlink this event is triggered.
Having a bit of difficulty working this gridview update problem out - I have managed to get edit/update function working but instead of only updating the current gridview row it is updating the whole table I believe this is due to a missing where statement on my Update statement - to single out the row index of my grid row.When I configure my sql datasource I am using custom statements Here is my update statement
I have a gridview that holds 4 columns. in the fourth column there is a DropDownlist that holds three items.
I want my users to select one of the values and when they do the auto post back (which is set to true) should execute a method that updates the database selected row. But do i use the selectedindexchanged of the DDL or the Gridview? My head is totally thrashed so i imagine its really simple and im just over thinking it.
i wanted to refresh the gridview once user enters values and clicks update button. But its not updating. If i change my selection to pop up gridview, then it is showing the updated values. I dont know where i am doing wrong. can any one suggest changes in my code?