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.
View 4 Replies
Similar Messages:
Jul 5, 2011
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:
Code:
<asp:TemplateField ShowHeader="false">
<ItemTemplate>
<asp:LinkButton ID="lbEdit" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"> </asp:LinkButton>
</ItemTemplate>
[Code] ....
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??
View 1 Replies
Jul 19, 2010
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
View 11 Replies
Oct 14, 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?
View 3 Replies
Feb 12, 2010
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
View 11 Replies
Oct 4, 2010
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 .
View 4 Replies
Dec 14, 2010
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 can i accomplish this?
View 4 Replies
Jan 27, 2010
[Code]....
[Code]....
View 1 Replies
Feb 20, 2011
I have a GridView with 5 fields. Only two of the fields are edittable (the others are READONLY).
I have an UpdateCommand as follows
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NHLPOOL %>"
SelectCommand="SELECT [PlayerID], [Firstname], [lastname], [Goals], [Assists], [Goals]+[Assists] as Points, [AsOfDate] FROM [PlayerStats], [Player] where [PlayerStats].[PlayerID] =[Player].[ID] ORDER BY Points DESC"
UpdateCommand="UPDATE PlayerStats SET Goals =@GOALS, Assists =@ASSISTS, AsofDate=GETDATE() WHERE PLAYERID = @PLAYERID">
</asp:SqlDataSource>
The issue is I want the PLAYERID GV column to be READONLY but I get a runtime error when updating if the PLAYERID is READONLY.
I get the error "
Must declare the scalar variable "@PLAYERID"."
View 1 Replies
Jun 2, 2010
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?
for example,
[Code]....
View 3 Replies
Jun 4, 2010
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?
View 5 Replies
Mar 2, 2010
how to refer shared function in a class , this function itself inside same class
public class cls1
Public Shared Function getDBDate(ByVal pDate As Date) As String
Return Format(pDate, "yyyy-MM-dd")
End Function
Private Function GetDb_Format(ByVal pDateString) As String
Dim d As Date = Me.ParseDate(pDateString)
Return clsDate.getDBDate(d)
End Function
End Class
can i have any other way to use getDbDate function
View 2 Replies
Jul 1, 2010
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?
View 4 Replies
Aug 19, 2010
i would like to know about AutoEventWireup="false".
give me a brief description or a link to refer which gives precise information.
View 3 Replies
Dec 1, 2013
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.
View 4 Replies
Oct 17, 2010
refer to label in aspx from ascx? .......
View 1 Replies
Apr 15, 2010
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.
View 7 Replies
Sep 17, 2010
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.
i want write code in C# (asp.net)
View 1 Replies
Oct 18, 2010
This is my master page code
[Code]....
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 ?
View 2 Replies
Jun 25, 2010
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.
View 1 Replies
Aug 18, 2010
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.
View 1 Replies
Jun 1, 2010
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
View 2 Replies
Nov 9, 2010
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?
[code]....
View 2 Replies
Feb 9, 2010
I came across a Visibility bug with IE 8.0 and AjaxControlToolkit for which the fix is posted in the following URL:[URl] For adapting the above fix,
1. Where can i find the Common.js script file
2. After updating the common.js file, how to reference it in page so that the updated common.js file is downloaded instead of from webresource.axd.
View 3 Replies
Jan 5, 2010
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?
View 4 Replies