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
Similar Messages:
May 7, 2015
How to disable editing the data in the cells of datagridview in c#?
View 1 Replies
Dec 21, 2013
I am trying to update values in the GridView but have some issue with the Datetime (which I want to keep Readonly). On updating the GridView, I am getting the following error:
ERROR: "System.FormatException: Input string was not in a correct format."
Database COLUMN:BestillingDato, nVarchar(50), Allow Nulls
HTML Form:
<asp:TextBox ID="txtBestillingDato" runat="server" Width="260px"></asp:TextBox>
GRIDVIEW Table:
<asp:TemplateField HeaderText="Bestilling Dato">
<ItemTemplate>
<asp:Label ID="lblBestillingDato" runat="server" Text='<%# Bind("BestillingDato","{0:d}") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
[Code] .....
View 1 Replies
Mar 5, 2010
I am updating a gridview. Problem is that when I hide certain fields that I do not want the user to update, they lose their values ie. the data is wiped out in the field unless I show them on the grid and make them writeable. Is there a property I need to set for the field to retain the value when the grid is updated or is this in the sql statement?
View 7 Replies
Jun 21, 2010
I have a GridView with two CheckBoxField columns. They both have ReadOnly property set to false, but html code generated for them has attribute disabled="disabled". So the value cannot be changed.
Generated HTML example:
<span disabled="disabled"><input id="ctl00_ContentBody_GridView_ctl02_ctl01" type="checkbox" name="ctl00$ContentBody$GridView$ctl02$ctl01" checked="checked" disabled="disabled" /></span>
how to figure it out?
View 2 Replies
Apr 11, 2010
I need to change ReadOnly from false to true for one column in GridView depending on who the user is. In my particular case it is a BoundField (also I would like to know how to do it for a Template field as well) and DataField is "dteRequired". I would like to code something like that right in the Page_Load handler:
View 8 Replies
May 4, 2010
I have a problem specific to the gridview control, i am using the datasource to generate an update method for the data in my table.
Some of my columns are display only fields so i have set them to "read only = true" Everything seems fine when the page loads but when i click update, the columns that were editable update fine but the ones set to read only have now updated the databasewith a null value. Am i missing something here?
View 5 Replies
Sep 7, 2010
[Code]....
works if the textbox is not readonly. What do i do to get the readonly textbox value?
View 9 Replies
Mar 29, 2011
I have four Itemtemplate textbox with in my Gridview.... i want to set Readonly attribute dynamically only one itemtemplate textbox, how to do that,
I have done one for my gridview footer its working,
DirectCast(GridView1.FooterRow.Cells(2).FindControl("TxtSum"), TextBox).Attributes.Add("readonly", "readonly")
this time i'm expecting for row template textbox.
View 4 Replies
Feb 21, 2010
I am trying to set the readonly property for the columns of a latebound gridview.
My data source is a select SPROC which returns a lookup group of records.
The gridview control is bound when the page loads.
The gridview has an edit control and I would like to allow the editing of specific records.
I cannot find the readonly property of the row columns to set.
I tried this :
[code]...
View 2 Replies
Mar 31, 2010
I have some custom Code to handle the Insert And Edit Mode on the OnRowCommand="CheckTheData" property of the GridViewThe Grid Starts in the "Readonly" mode, click on the edit button and it goed into edit mode for that row My routine ends with:The update is done and the display refreshes, but in the edit mode. If I click the clancel button back to read only mode.How can I get the gridview to redisplay in the read Only mode after the update?
View 1 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
Mar 18, 2010
in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]
View 1 Replies
May 4, 2010
Currently I have something like this, but when I click "update" the record doesn't get updated (but no error is returned).
[Code]....
View 5 Replies
Sep 20, 2015
I have generated a Excel report using C#,which generated fine.now i need to do all of those field is to be noneditable.how could i do it
Here my Export to Excel COde below:
#region Export to Excel
if (dt.Rows.Count > 0)
{
string filename = reportName + ".xls";
[Code]....
View 1 Replies
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
Mar 4, 2011
I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and
rows as columns like below:
EMP1 1 2 3 4
EMP2 1 2 3 4
View 3 Replies
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
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
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
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
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
Jan 20, 2010
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?
[Code]....
View 2 Replies
May 14, 2010
I'm using a GridView to retrieve data from a stored procedure using a SQLDataSource (db is SQL Server 2008). When I compile my application and go to my website, all the data is loaded and shown fine. If I was to add a new entry to the table however (a seperate page on my website has a Wizard control to facilitate this) and then return to the page with the GridView, the new entry doesn't show up.
Looking from SQL Server, the data has been added, but the GridView isn't updating to show it. If I were to recompile the project with F6 and refresh the page, the new data will show up. I tried calling DataBind() on the GridView in the Page Load event, however the issue still remains.
View 5 Replies
