VS 2008 GridView - How To Refer To The Row That Is Updating
Mar 13, 2010
I'm facing the following issue:
I have a gridview that allows updating. I only want to show the relevant fields to the user. As a result I hide the ID field of the records. But I need this value as a parameter for my update command. Apparently the value is always passed as 0 when the field is set invisible. When the field is set visible, the right value is passed.
I know it is possible to refer to a selected row and its controls, to get their values, even for invisible fields. This is what I want to do when the row is updating, in order to get the ID value of the label control which holds the ID value. How do I refer to the row that is updating? I experienced that the row is not considered 'selected', so the SelectedRow property of the gridview does not do the trick.
Which is the correct event to handle Updating of a row in my gridview. The gridview is bound to an objectdatasource. I added a tamplate field like this to handle editing a row:
No I need to handle the Update Button click.I need to set the ObjectDatasources Update params and call the update method. I'm not sure which is the correct event to do this. IS it gridview_RowUpdating??
i m having sub-grid/Nested Grid concept using grid view control ., i.e., inside grid in sixth cell i m having another grid.,
i n Sub-Grid i m having The Follwing Events OnRowDataBound="Gdclmline1_RowDataBound" OnRowEditing="Gdclmline1_RowEditing" OnSelectedIndexChanging="Gdclmline1_SelectedIndexChanging" OnRowUpdating="Gdclmline1_RowUpdating" ., all the events are working Fine Except OnRowUpdating="Gdclmline1_RowUpdating" this event.,
we are developing the software in Visual Studio 2008 ., our Server is Visual Studio 2010 .,
in my development machine its working fine., but in Server machine its row updating event not working .,
note:- we have used proper conversion method from vs 2008 to vs 2010
I'm using following DropDownList event to select an employee from MS SQL Server 2005 and showing the employee's information on TextBox.
protected void employeeDropDownList_SelectedIndexChanged(object sender, EventArgs e) { EmployeeDAL employeeDAL = new EmployeeDAL(); DataTable dataTable = employeeDAL.GetEmployeeData(); for (int i = 1; i <= dataTable.Rows.Count; i++)......
But the problem is... values of the TextBoxes are not changing. I mean TextBoxes are keeping previous values those were assigned in employeeDropDownList_SelectedIndexChanged event. But why?
why this update is failing? The table is connected to OK and there are appropriate values in the parameters to the subroutine, and yet the record in the table remains unchanged. I am using exactly the same code (with different parameters, obviously) to update another table and this continues to work fine.
Public Shared Sub SaveMathsSettingOptions(ByVal ID As Integer, ByVal Auto As String, ByVal Repeats As Integer, ByVal Weekly As String, ByVal ClassSheets As Integer, ByVal HomeSheets As Integer) Dim con As New MySqlConnection(_connectionString) Dim ret As String Dim sql As String sql = "UPDATE centres SET maths_auto = @maths_auto, maths_auto_reps = @maths_auto_reps, maths_weekly = @maths_weekly, maths_class_sheets = @maths_class_sheets, maths_home_sheets = @maths_home_sheets WHERE centreID = @centreID" Dim cmd As New MySqlCommand(sql, con) cmd.Parameters.AddWithValue("@maths_auto", Auto) cmd.Parameters.AddWithValue("@maths_auto_reps", Repeats) cmd.Parameters.AddWithValue("@maths_weekly", Weekly) cmd.Parameters.AddWithValue("@maths_class_sheets", ClassSheets) cmd.Parameters.AddWithValue("@maths_home_sheets", HomeSheets) cmd.Parameters.AddWithValue("@centreID", ID) Try con.Open() Catch myerror As MySqlException 'MessageBox.Show("Error Connecting to Database: " & myerror.Message) ret = myerror.Message con.Close() Finally con.Dispose() End Try End Sub
I have an excel sheet with 2 tabs and has data in those 2 sheets(sheet1, sheet2) which correspond to different tables in the same database. This excel sheet gets updated daily, I am wiriting a console app( which will later be a batch build). I have to insert the data from the excel sheet to corresponding tables (table1, table2,table3) in database when i run it and and also if the table has the same data already present it should ignore and if there are any modifications done the data it should update the table. I know we can do this using ado.net or LINQ, I am a little new to database based programming .
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.
How do i refer a control id from a different ContentPlaceHolder by using inline code?
I have filterParameters which refer a control (txtSearch). Since it was place in different contentplaceholder (ContentPlaceHolder2) , its id could not be find by it name "txtSearch", is there any inline code syntax can help me?
We have multiple themes and based on the employee login we need to set the themes. And my themes folder including images, style sheets etc resides outside my application ie inside my master page project.When i refer the theme to it i am receiving an error stating its not valid theme.Cant we refer the external themes and set it page.theme?Any idea on this?
When your web.config or app.config file has an appsettings entry, what is the best way to refer to its key in your code file? Developers I have worked with have differing opinions on this. Some say to hard code the string and others suggest that there should be a file containing string constants and in your code, you use the constant as the appsettings key. I would be interested in hearing other opinions on this. What do you do? Why is it the best?
I have a GridView that is populated via a dataset that contain 1 table. I have enabled paging on my GridView.
In my Updating event, I handle the new values and call a store proc to update my database with the new values for the selected row. In order to minimize the call to the DB, instead of getting back a new dataset with the updated values, I simply update the row of the dataset that I have in session with the new values and then I bind back my gridview.
The problem that I have is since I have let's say 5 pages of 10 row... If I update a row on the first page as soon as I click update, the gridview will show the new values. However, if I select page 3 for example, click on update and update the values, once the update is done, the gridview will still be displayed with the old values.
i have couple of aspx pages, both have drop down lists (DDLs) in them. A user first goes to Page1.aspx and choose a value from the DDL-1 and click on Submit button. He is then taken to the Page2.aspx which again has a DDL-2. What I want is to populate the DDL-2 based on what was chosen in DDL-1. I am not able to figure out how to access something that was chosen on a previous page. I believe I need to create a reference to the previous page? Please help me out with this.
I have two server one server runs (windows 2003 server Moodle opensource - PHP url : [URL] and another server contains Course Matterial video(url :[URL]. so user success full login i have transfer to another server. how can i know it is successful login and it is request comes from xxx.yyy.zzz.aaa ip.
Now what I want to do is, using JavaScript, hide the "phMenu" contents in the childpage. For this, I have written a function called " showHideMasterPageContent " in the masterpage which I am calling in the child page.
My trouble is that, I get a null reference since obviously, when I looked at the source, I see that only the contents of phMenu are rendered and not the phMenu control itself. Now how to refer to phMenu in JS ?
My Exe had a reference to a older version of a dll in the GAC both old & new versions are present in the config file i have given the binding redirect setting to refer the new version of the dll , thouhg when exe is running it is still refering to the old version , could some one shed some light here.
I have two Script Controls on a page (actually they are User Controls which implement IScriptControl, but I don't think that's relevant). I have the usual Script Descriptor code so that the server side properties are passed to the client side controls. That works fine.So, I have two text boxes (lets call them A and B) each with some attached Javascript. The Javascript attached to text box A exposes a property "get_SomeValue". In the VB code-behind for text box B (in and around PreRender), I am doing a FindControl to get hold of the ClientId of text box A. Then I am adding an Element Property to the Javascript so that, in theory, the text box B Javascript has a handle to textbox A's Javascript, and so should be able to call its get_SomeValue function. That call is failing - telling me that the method I am calling is not supported.
I'm using the following code to get a list of sites from a database and then show a short extract from the posts. The number of posts shown and the length of the extract is defined in the appsettings of the web.config.
[Code]....
I get the following error:
Index and length must refer to a location within the string. Parameter name: length
I have a public shared function and I'm trying to access the values of a text box and a session variable.
I'm getting the error "Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class."
Is there any way I can get to the values in the textboxes or session variables from within the method?
At first, I had my datalist being populated by my class 'PM' - I did it all inside the Page_Load event. Since there was a dataset being returned, I could assign different variables to fields in the Datatable, like:
[Code]....
Now, for reasons I won't go into here, I'm changing to an ObjectDataSource, using the same method to do the 'Select' of data... How can I do the same variable assigning, with the ObjectDataSource?
