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.
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]....
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]....
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]....
I have Gridview like that:
[Code]....
I bind data to GV in this way:
[Code]....
No problem with that. Now, I´d 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, it´s empty
I can't get my gridview to update? Inserting and deleting work fine. Here is my code:
[code]....
[Code]....
DropDownList not updating inside gridview
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//
}
}
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 RepliesI 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]....
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]....
[Code]....
Dropdownlist is not updating the table
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.
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 RepliesI 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?
[Code]....
[Code]....
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"."
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 RepliesI 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.
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.
how to Get Text Item from Dropdownlist
View 7 RepliesI 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.
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.
I am trying to update gridview record, i am not getting any error but its not updating the record either.
[Code]....
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"
/>...............