Web Forms :: DropDownList And Gridview For Updating Data / How To Get The Text Not The Value

May 3, 2010

i have a DropDownlist in my GridView that is bind to another DataSource than the GridView.

For the display it is working well but when I want to update datas I m stuck. Something is wrong and I don't know why.

[Code]....

I am stocking in the Database the value of the dsDroit but when I want to update the field I just know how to get the text not the value.

View 9 Replies


Similar Messages:

Forms Data Controls :: Updating Using Dropdownlist In GridView?

Feb 23, 2010

I was used TextBox in the GridView Then I Replace this textBox with Dropdownlist

and i fetched all the data from the database using DataSource in Editing Mode

But The problem is when i choose item from the dropdownlist to update it,it returns to Empty

(with No values) in the DropDownList??whats the problem?

[code]....

View 5 Replies

Forms Data Controls :: Updating A Row In A Gridview With A Dropdownlist

Oct 15, 2010

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.

[Code]....

View 3 Replies

Forms Data Controls :: Updating A DropDownList In The GridView Using Databinding?

Mar 24, 2010

I am trying to create a Gridview in which I can update the Project Officer name in the Gridview from a DropDownList.

The Project Officer DDL comes from a seperate query (SqlProjectOfficerName) as the other information (SqlDataSource1)... as you can see below.

When I select EDIT, the DDL appears and I can select from the list of Project Officers, but when I select UPDATE, the name of the Project Officer doesnot change.

review the code below and assist as appropriate to write the Project Officer's name back to the table.

[Code]....

View 13 Replies

Forms Data Controls :: Updating Database Using Dropdownlist In Gridview

Nov 14, 2010

I have Gridview like that:

[Code]....

I bind data to GV in this way:

[Code]....

No problem with that. Now, Id like to update the database with the dropdownlist in gridview, I wrote a method in this way:

[Code]....

The problem is when I click on the edit button there is nothing in the dropdownlist, its empty

View 6 Replies

Forms Data Controls :: Updating Gridview With Static Dropdownlist

Feb 10, 2010

I can't get my gridview to update? Inserting and deleting work fine. Here is my code:

[code]....

View 6 Replies

Forms Data Controls :: DropDownList Not Updating Inside Gridview

Mar 27, 2010

[Code]....

DropDownList not updating inside gridview

View 3 Replies

Forms Data Controls :: Updating Dropdownlist Only In A Specific Cell In GridView

Mar 11, 2011

I have a situation where i need to update my Dropdownlist templatefield inside a GridView....but only for a specific cell. I have seen codes like this to loop through the whole GridView and update every rows in a specific column, but how do i do it if i only want to update one specific cell ? (If i know the index information of the cell, for example, I know i want to update the dropdownlist on Column 3 and Row 2)

foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
this.WorkTypeDDL = ((DropDownList)row.FindControl("WorkTypeList"));
this.WorkTypeDDL.DataSource = AL;
this.WorkTypeDDL.DataBind();
//more codes blah blah blah//
}
}

View 3 Replies

Forms Data Controls :: Get The Text Of Dropdownlist Inside A Gridview?

Dec 27, 2010

i want to calculate no of dropdownlist whose text has been changed and get the value of ist column so as to update the database

View 6 Replies

Web Forms :: Updating Text Field Rather Than Gridview?

Feb 26, 2011

I was able to get the code below to give me the value I want from my SQL table however it has to display it in a gridview so I assume that something in the code acutally makes the result a data source rather than a string value.

[Code]....

View 9 Replies

Dropdownlist On Gridview Updating Only First Value To The Database

Dec 8, 2010

I have a grid view and have five dropdownlist on it. I have edit update and cancel edit buttons on each row.

Drop down list is updating the database, but only first value in the dropdownlist even when user select second, third or any other value from the dropdownlist.

What could possible be the reason for this. Here is my row Edit/ CancelEdit and Updating Events.

[code]....

View 2 Replies

Forms Data Controls :: Dropdownlist Is Not Updating The Table?

Oct 15, 2010

[Code]....

Dropdownlist is not updating the table

View 3 Replies

Forms Data Controls :: Updating Formview And DropDownList?

Mar 26, 2010

One of the fields on my formview is a dropdownlist. When I go into edit mode the dropdownlist gets set to the correct value and works fine up to this point. Problem is I just can't see how to get the newly selected value of the dropdownlist to persist to the database when update is clicked. The DDL is a category list and I want to allow changing of the category for each record. Like I said I have it working so it displays the correct category for the record but if I change the DDL (change category) the new selected value doesn't get updated in the database. It just keeps using the binded value that was originally assigned to the selected value of the DDL. see code snippit

[Code]....

The above snippet is how I am binding the DDL. Now to not bore you with a ton of code paste I use various events of the formview to make sure the value displayed in the DDL is correct for the record that I am viewing at the time. All that works just fine. Where I need some pointers is the when I enter edit mode and change the DDL from say fire to ice it isn't getting persited to the database, all other info in the record gets updated just fine but the DDL never changes. I have tried several angles to getting this working and TBH my brain is yelling BREAK TIME.

View 2 Replies

Web Forms :: Display Default Text In DropdownList Which Is In Gridview

Dec 27, 2011

URL....If in the dropdownlist before making selection if i want to display like this -----Select a city------How can i do it?

View 1 Replies

Forms Data Controls :: How To Update Parent Gridview After Updating Child Gridview

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

Forms Data Controls :: Updating GridView Based On Computation In Another GridView

Jan 27, 2010

[Code]....

[Code]....

View 1 Replies

Forms Data Controls :: Updating GridView With GridView Columns That Are Readonly

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

Web Forms :: Text Box Text Not Updating?

Mar 10, 2011

I have created a question form which has a text box where a user can type their question. During testing, I can add text to the box and use the Sql Insert command to add a record in my sql database table.I need to have the text box list a series of question to which the user provides the answer. So in the onLoad event of the page I have specified me.txtQuestion = "the contents to be displayed by default as questions". This works fine, when I open the question page, the question text box has the correct pre-defined content.My issue now is that when I change the content of that text box, weather it be adding or deleting text and I save the record, it is always the default text that is saved. It's like I need to do a refresh of the text box prior to saving...Does anyone have some ideas as to how I would accomplish this?

View 3 Replies

Web Forms :: Dropdownlist Not Updating Dynamically?

Mar 3, 2011

I have a Dropdownlist in my form as an example as below.

The Dropdownlist items are pulled out from the database table.

When a user Clicks 'Save Template', A new row is created in the database, BUT the dropdownlist items

remains the same :( I want the list to be dynamic so that the user doesn't have to press F5 for updating the list.

View 4 Replies

Forms Data Controls :: Gridview Is Not Updating Anything?

Jan 28, 2010

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.

View 7 Replies

Forms Data Controls :: How To Get Text Item From Dropdownlist

Dec 27, 2010

how to Get Text Item from Dropdownlist

View 7 Replies

Web Forms :: Updating Bound Column When DropDownList?

May 17, 2010

I have a DataGrid with a TemplateColumn containing an asp:DropDownList and a BoundColumn. I'd like to have a VB.NET handler for when the selected item in the DropDownList changes. I'd like this handler to also update the value in the BoundColumn with the value of the newly selected item in the DropDownList.

Can someone point me to some resources I can examine to learn how to do this?

If the handler for the selection changing can give me the value of the NEWLY selected item, it should just be a matter of accessing the cell for my BoundColumn in the same row and writing to it. I do not know the syntax to achieve this.

View 3 Replies

Forms Data Controls :: Updating A Cell In A Gridview

Sep 7, 2010

I have a gridview and I want to update a cell with a session variable username. In the Gridview1_RowEditing event I have this code :

GridView1.Rows(e.NewEditIndex).Cells(5).Text = Session("username")

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.

View 5 Replies

Forms Data Controls :: Gridview Not Updating Record?

Jun 6, 2010

I am trying to update gridview record, i am not getting any error but its not updating the record either.

[Code]....

View 4 Replies

Forms Data Controls :: Updating All Rows In Gridview

Jul 30, 2010

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

UPDATE SimpData SET store_nbr = @store_nbr, date = @date, data_type = @data_type, acct_1 = @acct_1, amt_1 = @amt_1, acct_2 = @acct_2, amt_2 = @amt_2, acct_3 = @acct_3, amt_3 = @amt_3, cheque_nbr = @cheque_nbr, cheque_amt = @cheque_amt, gst_hst = @gst_hst, qst = @qst, comments = @comments, uploaded = @uploaded

Here is my gridview

<asp:GridView
ID="GridView1"
runat="server"
CellPadding="4"
Font-Names="Arial"
ForeColor="#333333"
GridLines="None"
Font-Size="Smaller"
Width="100%"
AllowPaging="True"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
OnRowCommand="GridView1_RowCommand"
OnRowEditing="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating"
AutoGenerateColumns="False"
DataSourceID="SqlDataSource1"
OnRowDataBound="GridView1_RowDataBound">
<RowStyle
BackColor="#EFF3FB"
/>
<FooterStyle
BackColor="#507CD1"
Font-Bold="True"
ForeColor="White"
/>
<PagerStyle
BackColor="#2461BF"
ForeColor="White"
HorizontalAlign="Center"
/>
<SelectedRowStyle
BackColor="#D1DDF1"
Font-Bold="True"
ForeColor="#333333"
/>
<HeaderStyle
BackColor="#507CD1"
Font-Bold="True"
ForeColor="White"
Font-Size="Smaller"
/>
<EditRowStyle
BackColor="#2461BF"
/>
<AlternatingRowStyle
BackColor="White"
/>
<Columns>
<asp:ButtonField
ButtonType="Button"
CommandName="Select"
HeaderText="Select item to delete"
ShowHeader="True"
Text="Delete">
<ControlStyle
Font-Size="Smaller"
/>
</asp:ButtonField>
<asp:CommandField
ShowEditButton="True"
/>
<asp:ButtonField
ButtonType="Button"
CommandName="Select"
HeaderText="Select item to upload"
ShowHeader="True"
Text="Upload">
<ControlStyle
Font-Size="Smaller"
/>
</asp:ButtonField>
<asp:BoundField
DataField="store_nbr"
HeaderText="Store Number"
SortExpression="store_nbr"
/>...............

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved