Forms Data Controls :: Dynamically Adding A Column To A Datagrid?
May 18, 2010i am kind of new in the .net world. I would like to know how you can add a link column with an image to a datagriid.
P.S. i am using Visual studio 2005.
i am kind of new in the .net world. I would like to know how you can add a link column with an image to a datagriid.
P.S. i am using Visual studio 2005.
I have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
I have a situation where I currently have a HyperLinkColumn control that I would like to modify to have a Label or simple text appear in the same column as the hyperlink. I tried setting this in the ItemCreated event but encountered the following error message
View 3 RepliesI want to dynamically bind dataset values into datagrid's header datafield.
Is it possible? To be more clear, when you click on datagrid's (Collection) from properties window, you get selected columns created from Bound column. So in those columns I want to dynamically display dataset's table values in those columns.
i.e like ds.Tables[0].Rows[0][0].
Is it possible to do it in Datagrid ItemDataBound function like,
e.Item.Cells[1].Text = ds.Tables[0].Rows[0][0]
or something like this? I know the above code is wrong and wont work since I tried it out and while building it throwed error saying, Cannot implicitly convert type 'object' to 'string'.
am binding a gridview to datatable ...and now i want to add a linkbutton/hyperlink as one of the columns in gridview (similar to checkbox field) ...am adding the Lbtn inside a template field ,but i want that column to come as last column ..but its coming as first column,,,how to acheive that??
moreover ,whn i clk on eack linkbutton a pop-up window has to come with submit and save and close buttons and functionality(is it better to use linkbutton or hyperlink??)...am using vs 2005
I have basically something like this:
<asp:datagrid id="DGrid" runat="server" AutoGenerateColumns="false">
<asp:TemplateColumn HeaderText="Stuff">
<ItemTemplate>
<asp:PlaceHolder id="PH" runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
</asp:datagrid>
I need to add a Button to the PlaceHolder depending on the values of the data I am binding. At the moment I am adding the Button after the data is bound in Page_Load. The problem is that the data binding methods are not called in postbacks, so the Button disappears when I click on it.
Problem is that I need to know some attributes of the grid item to create the Button, so I cannot create it before the data has been bound.
I have a datagrid which I only want the maintenance column to be editable (the other fields are only editable to admins at a different web page)
I've only just started messing with asp/SQL and would be very grateful for the help :)
Below is my code. I have tried messing with the update queries and it seems to mess up everytime some way or another. I'v
[Code]....
I've got a typed dataset that populates programmatically based upon dropdown selections from the user, and then is bound to a datagrid. One of the cols is a bit type (indicating whether or not that record is "active"). I would like that datagrid col to be exposed to the user as a bunch of checkboxes, which the user could turn on and off as needed, and then update the entire recordset according upon clicking Submit.
Is converting a dg column into checkboxes a straightforward thing to do?
how to sort DataGrid column. (Say like FirstName) I have done snippet like: (see Bold text) For HTML :
<asp:DataGrid ID="dtgCustomerSearch" runat="server" AllowSorting="true">
<Columns>
<asp:BoundColumn HeaderText="CustomerID" DataField="CustomerID" />
<asp:BoundColumn HeaderText="First Name" DataField="FirstName"
SortExpression="FirstName" />
<asp:BoundColumn HeaderText="Last Name" DataField="LastName"
SortExpression="LastName" />
<asp:BoundColumn HeaderText="Phone No." DataField="Phone" />
<asp:BoundColumn HeaderText="Email ID" DataField="EmailID" />
</Columns>
</asp:DataGrid>
On Page_load I have wrote: this.dtgCustomerSearch.SortCommand += new DataGridSortCommandEventHandler(dtgCustomerSearch_SortCommand);
private void dtgCustomerSearch_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
SortExpression = e.SortExpression;
BindTheGrid();
}
string SortExpression
{
set
{
if (ViewState["SortExp"] == null || value != ViewState["SortExp"].ToString())
{
ViewState["SortExp"] = value;
}
else
{
ViewState["SortExp"] = value + " DESC";
}
}
get
{
return ViewState["SortExp"] == null ? string.Empty : ViewState["SortExp"].ToString();
}
}
I have a datagrid that is supposed to display the list of uploaded word doc containing a specific word , this sort by the one having the greatest number of occurences(relevance).
It should allow the user to download one of the file by clicking on the button column .But im unable to get the text appearing in the datagrid nor the one in the button column
these are the table column
Firstname,Lastname,Path and Relevance
This is the code on item command:
[Code]....
the datagrid code:
<asp:DataGrid ID="DataGrid1" runat="server" AllowPaging="True"
BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px"
CellPadding="4" ForeColor="Black" GridLines="Vertical" ShowFooter="True"
AutoGenerateColumns="False" onitemcommand="DataGrid1_ItemCommand"
Width="353px">
<FooterStyle BackColor="#CCCC99" />
<SelectedItemStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right"
Position="TopAndBottom" />
<AlternatingItemStyle BackColor="#6699FF" Font-Bold="False" Font-Italic="False"
Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
<ItemStyle BackColor="#F7F7DE" />
<Columns>
<asp:BoundColumn DataField="firstName" HeaderText="FirstName" ReadOnly="True">
</asp:BoundColumn>
<asp:BoundColumn DataField="lastName" HeaderText="LastName" ReadOnly="True">
</asp:BoundColumn>
<asp:ButtonColumn CommandName="getCv" DataTextField="Path" HeaderText="Cv"
Text="Path"></asp:ButtonColumn>
<asp:BoundColumn DataField="NumberOfOccurences" HeaderText="Relevance">
</asp:BoundColumn>
</Columns>
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
</asp:DataGrid>
May i know how to get the value of the button column been click?
I want to autosize the last column so it spans to the full width of the datagrid. I've messed about with the width and autosize but can't seem to get it right.
**figured it out with dataGrid_customer.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
[Code]....
Summing a column in a datagrid
I had a datagrid and I was hiding columns. This was working fine to show just the columns I wanted.
[Code]....
And then I realised I wasn't paging the data so I ticked that on then above code no longer worked. The Count was equalling 1 with the paging ticked on. Why would that be?
I also used the classic formatting and when I sort the columns the classic formatting goes funny, how can reapply the sorting to make it look classic?
Is there a way to make a hyperlink column in datagrid on the fly... I have a search page and would like the user to be able to click a button to few full contents about the item for editing, etc.
View 11 RepliesI am creating multiple datagrids at runtime within a placeholder. I want to add scrollbars to them.
how to add scrollbars to datagrids created at runtime.I am using .net 1.1
How can i add an imagebutton in my datagrid dynamically using vb codes.
View 3 RepliesI have a boolean column in a datagrid that I would like to display as red/green image (I have already created these) instead of false/true. Or maybe I could display the "True" in green text and "False" in red text. Can someone point me in the right direction?
View 2 RepliesI have a datagrid with 5 columns and i m using edit and update methods over it. In the edit event it opens up all the columns in a row for editing. i need only 2 columns in tat row be editable. how can i do this.
my level of knowledge on asp.net with c# is newbie.
I m working on Datagrids and i am trying to specify a fixed width for a Column(in datagrid) ...Is there any property to specify the width of the columns in datagrid(i know its pretty easy to specify the width of the Datagrid but i want to specify the fixed column width) Also how do i specify the text wrapping in a datagrid
View 1 RepliesIs there any way to get the datagrid header column's text before the grid loads.
View 7 RepliesI had a datagrid with lot of columns.The datagrid coloumns width changes accoprding to data.
So I want to get the width of the column in Javascript,because I maintain a dummy header(**here I need to set the each Header column width according to the data columns width).
I have a datagrid, I want to merging cell. I want my datagrid look like this
Material Name
1
2
3
4
..
31
Material A
100
200
150
220
..
500
Material B
1200
4500
..
600
I want to merge the cell programmitically when ItemDataBound.
1,2,3,...,31 are material date request. If I request Material B with quantity 4500 from 2nd until 4th the cell will be merge.
I already read about Merge Cell in Gridview in this forum, but this solution is different with datagrid.
I need to add three columns one with combo box and two text boxes.
I need to add rows to the data grid based on the collection i get which determines the number of rows. Could anyone point to right place to add a row dynamically.
i have a DatagridView which contains 5 columns. The Fifth Column can contain a number or a NULL value .
I need to edit the DataGrid it in such a way that the fifth column is hidden everytime.
And on a specific condition that if fifth column is not null , then display the value which is present in fifth column ,in a small subscript below the the corresponding element in first column .
Im basically listing a set of facilities in a datagrid. Like so:b Projectorcb Laptopcb TelevisonIn roomview, a check appears where a facility is availble in a room. This part works fine.The user can then edit the facilities, by clicking on the check beside each facility. When the update button is pushed I need to record the value of the checkbox, however I cant get the value of the checkbox.eres my codebehind:
[Code]....