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?
iam using asp.net2.0 with c#
the print out paper size is like shops printer small size
i want to print current date,transfer no and two colums from gridview
ItemKey and quantity
[Code]....
How to update a colums value of a Row in a gridview on Row Command Event Handler. I am using a SQL Datasource.
[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 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[Code]....
works if the textbox is not readonly. What do i do to get the readonly textbox value?
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.
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]...
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 RepliesI have a data bound gridview, all columns except 1 need to be formated in % {0:p2} , if i explicitly define the colms its simple, but I need to do 6 grids and even if i cut an past it makes much more (14 colms) markup then i would like, is there another way?
View 2 RepliesHow can I set my Checkboxlist in tree columns?
This is my SqlDataSource
[Code]....
This is my CheckBoxList
[Code]....
How to disable editing the data in the cells of datagridview in c#?
View 1 Repliesin my application i have to sort the gridview columns. here i set the showheader property of gridview to false.
i have link buttons on the top of the corresponding gridview columns.
here i had bind the DataField to the link button as
<asp:LinkButton ID="lbcontactperson" Text='<%#Bind("contactperson") %>' runat="server">ContactPerson</asp:LinkButton>
my requirement is when i click the link button the corresponding colums will be sorted.
how can we do this.
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] .....
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]....
i have apage with datarepeater, and the repeater has a data source. and in the repeater i have atext box control
i want to give it the value from the data source coulomn ("question column")
like this:txtQuestion.Text = rptrQuestions.DataSource.Columns["Question"].(here is the problem)
what can i write after (Columns["Question"]) to see the value for this column?
Is it possible to to check while uploading pdf file that it is read only?
if it is possible than how to do that using c#??
I want to set colums, TemplateFied,HeaderTemplate,ItemTemplate with (LinkButton-Text,CommandName,Onclick etc) Here I am showing my code t_name table name it is varable,I want to set various table contains various field,Then I want generate Dynamically Gridview with the above properties.
string str = System.Configuration.ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
SqlConnection con = new SqlConnection(str);
SqlCommand cmd;
SqlDataAdapter ad = new SqlDataAdapter();
con.Open();
cmd = new SqlCommand(“select * from t_name”, con)
ad.SelectCommand = cmd;
DataSet ds = new DataSet();
ad.Fill(ds, t_name);
GridView1.DataSource = ds;
GridView1.DataBind();
there are 2 pages (SummaryGridviewPage.aspx and FormviewPage.aspx) there are insert, item and update templates in the FormviewPage 1st case - there is no problem to insert new record, select and update action in the FormviewPage
2nd case - However, there is problem when i select a record in GV and direct to FormviewPage for edit this code is added in Formviewpage to open the record at readonly mode, no problem
Private Sub RF_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
If Session("RecordID") <> "" Then ' to check New or Old record
SqlDataSourceRF.SelectParameters.Item("New_ID").DefaultValue = Session("RecordID")
FormViewProject.ChangeMode(FormViewMode.ReadOnly)
End If
End Sub
however, no record if go further from readonly to edit mode then Code is added to the Edit button
Protected Sub BtnEdit_Click(ByVal sender As Object, ByVal e As EventArgs)
FormViewProject.ChangeMode(FormViewMode.Edit)
SqlDataSourceRF.SelectParameters.Item("New_ID").DefaultValue = Session("RecordID")
FormViewProject.DataBind()
End Sub
Now edit problem is solved but when go back to the 1st case (new record, and then edit) Now new record can be inserted, and then show it in readonly mode. but then try to go to edit mode, no record show i think BtnEdit_Click code is conflicted with the built-in "Edit" command Could anyone show me some info how formview retrieve specific record in a proper way?
I have a FormView bound to an ObjectDataSource that is bound to a business logic object. The business logic object has a Readonly field called "Id". When I try to update the formview, I get the following error message: The 'Id' property on the type specified by the DataObjectTypeName property in ObjectDataSource 'ObjectDataSourceNewsArticle' is readonly and its value cannot be set. How do I get the ObjectDataSource or the FormView to recognise that the id field is readonly, and to not try to update it?
View 3 RepliesI'm using a formview in Insert mode with an AccessDataSource. I want to switch to readonly mode upon insertion to let the user confirm the input worked, then give them the option to insert a new record. If I set the DefaultMode to Insert, then after the first record is inserted, I get a new blank insertion form (no confirmation). If I set the DefaultMode to ReadOnly, after insertion, I get a blank form (presumably because I am not on the record just inserted).
How do I get the just inserted record to display? If I need to set the ID of the formview to the just inserted record OnInserted, how do I get that given I'm using an AccessDataSource?
I've got a problem with DetailsView. I've ot Edit Mode, and when i push "Update" button i would like to switch to "ReadOnly" Mode.sView2.ChangeMode(DetailsViewMode.ReadOnly) doesn't work :/
View 3 RepliesI have set a couple of my DetailsView fields to readonly=true. In Update mode the fields are readonly but in Insert mode they are not readonly. What do I do to set it to readonly or blank (no field for entry)?
View 1 RepliesI 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?
One of the few fields that have their ReadOnly property equal to True then Edit and Update the value field is empty ReadOnly property is recorded.I also have a ReadOnly property and its value is not empty. (GridView to the SqlDataSource is connected)
View 1 Replies