protected void Button1_Click(object sender, EventArgs e)
{
System.Collections.ArrayList list = new System.Collections.ArrayList();
list.Add("abc");
list.Add("xyz");
list.Add("pqr");
list.Add("efg");
GridView1.DataSource = list;
GridView1.DataBind();
}
Now when data is bound to the gridview the column name is by default "Items" but I want to change the header text of this column.
How to disable editing the data in the cells of datagridview in c#?
View 1 RepliesI am binding a GridView using a DataSource in asp.net, and i would like to have some hidden BoundFields so I can access those values in my RowDataBound Function. However, when I set Visible="False" on these BoundFields the values do not get set and are always blank in the RowDataBound function.
I've seen some suggestions of setting the style on the BoundField to hidden but this did not work for me either. Ideally I don't even want a column created in the gridview, I just want these values to be hidden so I can access them.
in ASP.NET 4, I have a GridView, which contains a DropDownList in the section. The DropDownList is populating with all of the options I need from a second data source. However, I would like to have each DropDownList in each row have a different SelectedIndex set on default based on data already in the GridView.
View 1 RepliesI want to rename some or all column name header of datatable. How can I done it in loop.
For example datatable has 3 column A,B,C I want to rename it 1,2,3.
I don't want to hardcord it.. Can it be done if I mention somewhere what column to replace with which one and done thru loop.
I have a GridView like this
<asp:GridView ID="gv_FilesList" runat="server" AutoGenerateColumns="false" onrowcommand="gv_FilesList_RowCommand">
<Columns>
<asp:BoundField DataField="f_Id" Visible="false" HeaderText="File Name" />
</Columns>
<Columns>
<asp:BoundField DataField="f_Name" HeaderText="File Name" />
</Columns>
<Columns>
<asp:ButtonField ButtonType="Link" Text="Download" CommandName="DownloadFile" HeaderText="Download" />
</Columns>
</asp:GridView>
Now when I click on the download Button, how can I get the corresponding f_Id in order to get the related data from Database.
I have a grid view control having some bound and template fields as follows
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="ID" Visible="False" />
<asp:TemplateField HeaderText="Question">
<ItemTemplate>
<asp:LinkButton ID="btnques" runat="server" onclick="btnques_Click"
Text='<%# bind("Question") %>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
Now what I want to do is that on the click event of a buttom btnques, I want to access its corressponding boundfield ID's value and to store it in a label.
I have a gridview with Edit and delete lini on it. I want to change the text of "delete".
I don't want to use link button because I have already implemented the code and its working fine. I just want to rename the "delete" text on grid view.
I'm using dynamic columns boundfield and templatefield in gridview, the GV embeded in a panel (autoscroll:auto;width:fixe), I fixed 3 columns to fit the panel's width , when I add exceed the 3 columns the width changes !
View 15 RepliesCan I do something like this:
<asp:BoundField DataField="Field1"
HeaderText='<% IF(Eval("Field2").ToString().SubString(3,4).Equals("Text3"),"Text1","Text2") %>'
SortExpression="Field1" />
With the goal of having the header of Field1 be Text1 when the 4th-7th characters of Field2 = Text3 and Text2 otherwise?
I tried it and it just put "'<%IF(Eval("Field2").ToString().SubString(3,4).Equals("Text3"),"Text1","Text2") %>'" as the actual header string!
i am having a boundfield column and in that column if i entered a string(without spaces) of length 15, there is no problem. But if the string is more than 15, the text is not wrapped. I gave the command column.ItemStyle.Wrap=true; But its not working. I have fixed the width of the column. How to wrap the text in the boundfield if a string more 15 characters.
View 3 RepliesWhen using a simple gridview targeting .net 4.0 if i click the edit button twice it converts to BoundFields to textboxes, but in previous version of .net (3.5 and 2.0) nothing happens (eventhough msdn says it suppose to happen). Have anyone seen this issue?
Code:
<asp:GridView ID="GridView1" AutoGenerateColumns="False" DataKeyNames="Id"
runat="server" onrowediting="GridView1_RowEditing">
<Columns>
<asp:BoundField DataField="Id" HeaderText="ID" Visible="False" />
<asp:BoundField DataField="FirstName" HeaderText="First Name" />
<asp:BoundField DataField="LastName" HeaderText="Last Name" />
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="imageButton" AlternateText="Edit" CausesValidation="false" CommandName="Edit" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
public partial class _Default : System.Web.UI.Page
{
public class Person
{
public string FirstName { get; set; }
public string LastName { get; set; }
[Code....]
I'm trying to programaticaly change the 'headerText' property of a GridView boundfield.
[Code]....
Apparently all goes weel, because i ca see, in a a debug session, the control initial value, and after i change it, the value changes.
In vb.net how can I get the value of a gridview's boundfield value? I'm basically putting a value in that boundfield that I need to access in the RowDeleting event so I can pass that into a stored procedure. I'd be open to also trying to get the value of a control from a template column too if that's a better method?
View 4 RepliesHw cn v assign different width to columns in a datagridview asp.net vb when the autogenerate columns property ="false"
View 1 Repliesi am trying to give a session value in Gridview databound field by using
<asp:BoundField DataField="Papercost" HeaderText="Paper Cost" DataFormatString='<%=Session["CurrencySymbol"]%>'"{0:0.0000}" />
But its a giving error like
Literal content ('<asp:BoundField DataField="Papercost" HeaderText="Paper Cost" DataFormatString="') is not allowed within a 'System.Web.UI.WebControls.DataControlFieldCollection'.
how can i give a session value here?
In My SQl Database table column (named "Enterance_DateTime"), datetime is saved in below format:
2014-03-05 15:17:45 as yyyy-MM-dd HH:mm:ss in ASP.Net
But when I fetch this column in Gridview it shows datetime as below format:
4/5/2013 9:04:06 AM
I want to fetch exact datetime in Gridview what is saved in DB table.I tried using DataFormatString="{0:dd-MM-yyyy}" but is showing only date not time with it. How to achieve it.
I am using gridview with sqldatasource , now i have a column
<asp:gridview ID="MyGrid" runat="server" AutoGenerateColumns="False" datakeynames="Seq"
DataSourceID="ExistingConsPhaseSource" >
<Columns>
<asp:boundfield datafield="Seq" headertext="Seq" readonly="True" Visible="False" sortexpression="Seq" />
<asp:templatefield headertext="Description" sortexpression="Description">
[Code] ....
I also have a button outside gridview , on its click event i want to delete all rows in a grid view. So far i have done like this :
protected void DelAllExisting_OnClick(object sender, EventArgs e) {
foreach (GridViewRow row in ExistingConsPhases.Rows) {
string query =
"UPDATE [dbo].[myTable] SET IsDeleted = 1, DeletedBy = @DeletedBy, DeletedDate = GETDATE(), DeletedByPrefix = @DelPrefix WHERE Seq = @Seq";
SqlCommand comm = new SqlCommand(query,_connection);
comm.Parameters.AddWithValue("@Seq", ???);
comm.ExecuteNonQuery();
_connection.Close();
}
}
What to type instead of ??? I want my bound field of Seq to be place here ? how ?
Can we get a reference to a boundfield column value which has been made invisible ina dynamically created and databound gridview. I am able to get a reference to a
button field which is added to the grid dynamically like this:LinkButton _singleClickButton = (LinkButton)e.Row.Cells[5].Controls[0];
(the button field is the 5th column in the gridview and it is made invisible through visibility property)
DLRepository is a class with method getDLandRules. I am binding the gridview with the list that is returned by method. Now I would like to iterate through the list and add 1 more column to each row that is returned. currently, I am getting an error
GridView1.Rows[row].Cells[7].Text 'GridView1.Rows[row].Cells[7]' threw an exception of type 'System.ArgumentOutOfRangeException' strin
I need to set the HeaderText of GridView BoundField in codebehind file based on a flag at runtime.
I tried setting the column name as
e.Row.Cells[0].Text = "XXXX";
It is worked out but not able to sort that column.
here my requirement is to set the HeaderText programmatically in codebehind and able to sort the column.
I have one two GridViews on a page. One Gridview uses BoundFields inside of the GridView and the Update statement works just fine. The other GridView utilizes TemplateFields due to the fact that Validation Expressions have to be used. I also want This GridView to be able to update the vlues when the user clicks on the Update link on the right side of the GridView. The GridView that uses the BoundFields updates just fine, but the GridView that uses TemplateFields will not update. I have checked and everything is correct other than this difference of BoundField and TemplateField.
View 2 RepliesI I have a GridView attached to a SqlDataSource and all is working well. I also have and edit and delete icon attached to each record in the GridView, and again, all is working well.My problem is when I add a BoundField named 'statusCode', the delete stored procedure fails with:"Procedure or function 'up_delReference' expects parameter '@statusCode', which was not supplied."When I remove the BoundField named 'statusCode' from the GridView list, the delete works fine. I need to show the status in the GridView as the user can chose to see Avtive, Inavtive or Both records and they need to see the status when in Both.Here is the Code:
[Code]....
How we can group data in bound field...
1 1-1-2013 x a 1 1-1-2013 x b
1 1-1-2013 x c
2 2-1-2013 y a 2 2-1-2013 y b
2 2-1-2013 y c
i want to show it in this format...
serialNo date name item
1 1-1-2013 x a b
c
2 2-1-2013 y a b
c
In database I have column date but when i enter date my font end view also display time for every date time remain same 12:00 AM ... I don't want to display date how can I do this?
View 1 Replies