C# - Change Column From DataGridView In Runtime?

Aug 23, 2010

I'm filling a previously created DataGridView on an ASP.NET Web Form dynamically with a DataTable, but I want to change the name of the columns that appear on that DataGridView, and I simply can't figure out what I'm doing wrong. Below is the code:

DataTable dtUsuarios = DBManager.RunSqlGetDataTable(
@"select b.UserName, c.Email, c.IsLockedOut, c.LastLoginDate,
case
when e.RoleName is not null then 1
else 0 end Admin
from dbo.aspnet_Applications a join dbo.aspnet_Users b
on a.ApplicationId = b.ApplicationId
join dbo.aspnet_Membership c
on b.ApplicationId = c.ApplicationId
and b.UserId = c.UserId
left join dbo.aspnet_UsersInRoles d
on d.UserId = b.UserId
left join dbo.aspnet_Roles e
on d.RoleId = e.RoleId
where a.ApplicationName = 'Mont Blanc Catalogo'");
dtUsuarios.Columns["UserName"].Caption = "Nome Usuário";
dtUsuarios.Columns["Email"].Caption = "E-mail";
dtUsuarios.Columns["IsLockedOut"].Caption = "Bloqueado";
dtUsuarios.Columns["LastLoginDate"].Caption = "Último Login";
dtUsuarios.Columns["Admin"].Caption = "Administrador";
DataView dvUsuarios = new DataView(dtUsuarios) { Sort = "UserName" };
gdvUsuarios.DataSource = dvUsuarios;
gdvUsuarios.DataBind();
//gdvUsuarios.Columns[0].HeaderText = "Nome Usuário";
//gdvUsuarios.Columns[1].HeaderText = "E-mail";
//gdvUsuarios.Columns[2].HeaderText = "Bloqueado";
//gdvUsuarios.Columns[3].HeaderText = "Último Login";
//gdvUsuarios.Columns[4].HeaderText = "Administrador";

Setting the values changing the caption of the DataTable doesn't work, and after the DataBind, the Columns.Count property for the DataGridView return zero columns! After executing the code, everything appears normally at my asp page, but the captions are wrong.

View 3 Replies


Similar Messages:

Data Controls :: Change GridView Column Text At Runtime?

May 7, 2015

table field TEST

TEST

1        ON

0        OFF

0        OFF

1        ON 

Gridview 

I want to table values 1001 replace ON and OFF 

i dont want to radiobuttonlist 

View 1 Replies

Forms Data Controls :: Change The Column Name Of Gridview Dynamically At Runtime?

Jan 14, 2011

My issue is that , need to change the column name(following some format) of the gridview (which is binded with XMLTextReader). Without changing directly XML file, Required to change the column name dynamically at runtime .

Performance.xml

<Performance>
<Departments>
<Heading>FS</Heading>
<S0015>1</S0015>
<S0020>2</S0020>
<S0025>5</S0025>
<S0030>5</S0030>
<S0035>6</S0035>
</Departments>
<Departments>
<Heading>BS</Heading>
<S0015>0</S0015>
<S0020>3</S0020>
<S0025>5</S0025>
<S0030>1</S0030>
<S0035>3</S0035>
</Departments>
</Performance>

Heading S0015 S0020 S0025 S0030 S0035
FS 1 2 4 5 6
BS 0 3 5 1 3
Required Format:

Heading 00:15 00:20 00:25 00:30 00:35
FS 1 2 4 5 6
BS 0 3 5 1 3

View 6 Replies

How To Put A Combobox In Every Column In The First Row Of My Datagridview

Mar 25, 2010

I need to put a combobox in every column in the first row of my datagridview. It has already been filled with a dataset.

View 4 Replies

Datagridview Selected Cell Row Index & Column Header

Oct 21, 2010

i want row index & column header(index) of the selected cell of datagrdview, all colums are dynamic.

View 3 Replies

Make A Column Width Size Fixed In Datagridview Asp?

Dec 29, 2010

i have this column in a datagridview on aspx page

<asp:TemplateField HeaderText="Observacion">
<ItemTemplate>
<asp:Label ID="lblOrderID" runat="server" Text='<%# Eval("Observacion") %>'></asp:Label>
</ItemTemplate>
<ItemStyle Width="200px" Wrap="False" />
</asp:TemplateField>

I have set up the itemstyle with and wrap to false, but anyways the width columns grows the the data is too long. i just want to change the height of the column not the width. Here us the complete code of the datagridview

<asp:GridView ID="GridView1" runat="server" AutoGenerateDeleteButton="True" CellPadding="4" EnableModelValidation="True" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False">
<columns>
<asp:boundfield datafield="ID_OBSERVACION" visible="False" />
<asp:boundfield datafield="AUTOR" headertext="Autor" />
<asp:boundfield datafield="FECHA" headertext="Fecha" />
<asp:TemplateField HeaderText="Observacion">
<ItemTemplate>
<asp:Label ID="lblOrderID" runat="server" Text='<%# Eval("Observacion") %>'></asp:Label>
</ItemTemplate>
<ItemStyle Width="200px" Wrap="False" />
</asp:TemplateField>
</columns>
<AlternatingRowStyle BackColor="White" ForeColor="#284775" Wrap="False" />
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" Wrap="False" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
</asp:GridView>

View 1 Replies

Forms Data Controls :: Dynamically Add New Column To A Datagridview?

Feb 15, 2011

I have calculated a value (say, Total) from datagrid values using RowDataBound event.

I want to show the value by adding a new column into Grid.

View 6 Replies

Forms Data Controls :: Set Datagridview Items Column Width?

Apr 5, 2010

I am using C# , ASP .NET 2.0 and i have to avoid the datagrid view items from being wrapped.

View 4 Replies

Web Forms :: Does Exporting DataGridView To Excel Has Limitations Of Columns Or Column Types

May 7, 2015

I am trying to export my Model to an Excel sheet. I have 31 fields out of which only 29 are exported. Among the 3 fields that I am not able to export 2 are of type Enum and one of DateTime. Their is another DateTime field also, but that is exported properly. Here are few fields of the model :

[EnumDataType(typeof(Suffix)), Display(Name = "Suffix *")]
[Required(ErrorMessage = "Suffix is Required")]
public Suffix NameSuffix { get; set; }
[EnumDataType(typeof(InquiryStatus)), Display(Name = "Status")]
[Required(ErrorMessage = "Status is Required")]

[Code] ....

Among the 4 fields above, NameSuffix, Inquiry_Status & FollowUpDate are not exported. InquiryDate is exported.

My exporting code is :

DataGrid dg = new DataGrid();
dg.DataSource = inqs.ToList<Inquiry>();
dg.DataBind();
string filename = "InquiryList_" + DateTime.Now + ".xls";
Response.ClearContent();

[Code] ....

In the ContentType, I alos tried with ""application/ms-excel";, but that makes no difference.

What can be the error for the above ?

View 1 Replies

Forms Data Controls :: Change DataGridView Cell From Text Box To Combo Box?

Feb 1, 2011

I have a column in datagridview which is display the vendor services. It is a textbox type when display. However, when I want to edit the service. I would like to click on the cell, and the cell change to combobox for me to choose. How can I do that?

View 6 Replies

Forms Data Controls :: DatagridView Postback / Cannot Make The Datagridview's Buttonfield Respond?

Feb 17, 2011

I am new to asp.net and was trying to use datagridview in my webform. I was able to bind it to my database but I cannot make the datagridview's buttonfield respond. It seems the grid's SelectedIndexChanged event is not being fired or has issues with postback. Even a very simple statement is not being executed by the program e.g.

protected void grid_SelectedIndexChanged(object sender, EventArgs e)
{
detailsLabel.Text = "asdfasdfsafasddf";
}

It seems the SelectedIndexChanged is not being fired. I have checked my IE and scripting is enabled.

I am using VS 2008 and IE7. Can anyone share a solution on how to solve this issue?

View 7 Replies

Forms Data Controls :: Changing Image In Image Button Column In A Datagridview?

Oct 21, 2010

Just wondering if anyone has ever managed to find a way to have a datagridview image button column in a template field which display different images on different rows depending on some data element in the row. Our application needs to display a series of fees charged against an account column which will be either less then 500, 500 to 1000 or >1000. Some of those fees are charged at a full rate, others at a partial rate, and some are not charged at all. The user would like to see a simple 3-state graphic which would convey the simple info: full-charge, partial-charge, or no-charge. Sounds easy enough but I've not yet managed to find a way to do this. Every time I attempt to modify the individual cell's graphic it seems to want to change the graphic for all the rows.

View 3 Replies

Data Controls :: Change Value Of GridView BoundField Column Based On Value From Another Column

May 7, 2015

I am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?

I have to add some columns which is not in the table and assign the values from code behind to that particular column

View 1 Replies

Forms Data Controls :: List.aspx:datagridview Change The Links To Parent Table From Details To List?

Sep 29, 2010

The List Page display child Entity using the gridview each row will have link to the parent

How can I change the link so it shows the parent but in list view(using list.aspx) not detailes (detailes.aspx)view

View 1 Replies

C# - How To Add Row/Column And Merge Row At The Runtime On GridView

Mar 8, 2011

I am working on ASP.NET3.5. I have to present mention Dataset on GridView under the given format at the run time.

Datset

EMP_ID EMP_NAME 2011-01-01_FLAG 2011-01-01_INDATE 2011-01-01_INTIME 2011-01-01_INSTATUS 2011-01-01_OUTDATE 2011-01-01_OUTTIME 2011-01-01_OUTSTATUS
1 Mr Netra Thapa ATTN 2011-01-03 09:01:59 EI 2011-01-03 18:0:15
2 Mr Luja Manadhar ATTN 2011-01-03 10:15:00 LI 2011-01-03 17:0:15 EO
3 Mr Kushal Joshi ABS NULL NULL NULL NULL NULL NULL
4 Mr Prakash Gobhaju ATTN 2011-01-03 09:00:15 NULL 2011-01-03 18:30:15 EO

I Have to present This Data using DataGird on the bellow format

Employee Id Employee Name 01-01-2011
In Time Out Time Remarks
1 Mr Netra Thapa 09:01:59 18:0:15 Earlry In
2 Mr Luja Manadhar 10:15:00 17:0:15 Late In , Early Out
3 Mr Kushal Joshi Absent
4 Mr Prakash Gobhaju 09:00:15 18:30:15 Late Out

How is it possible ?

View 1 Replies

How To Add Data Into A Specific Column At Runtime In Grid

Dec 9, 2010

I have a rad grid, i have bounded the columns in the grid using GripBoundColumns which shows me dropdown cloumns when i edit the record, Insert/update/delete are working fine for me.

My question is it possible to insert new data into the column(Not the whole record just only to one column) when i edit the record.

For example...

suppose i have 5 columns (Client Name, Account No, Account name, account status, Custodian Dealer) CustodianDealer is my drop down coloumn and data for it comes from different table when i edit or insert a new record in the grid, i can select the existing Custodiandealers in the table.

now if i want to insert a new record to the custodianDealer table not to the grid, how can i acheive it

View 3 Replies

Data Controls :: Add New Column To GridView At Runtime

Jul 26, 2013

how to add new column during runtime and then bind it to gridview??

View 1 Replies

Data Controls :: How To Set Width Of GridView Column At Runtime

May 7, 2015

How to set width of column in gridview when data is fill from database runtime in gridview.

View 1 Replies

Web Forms :: Can Change The ImageUrl At Runtime

Apr 1, 2010

In my website1, I posted some data to my website2 by doing an HttpWebRequest.The data are posted successfully but what I wanna do is change the imageUrl in website2 after website1 fired some data. When I try to debug, I can see that it passes through the code of changing the ImageUrl, but when I view the source of website2, I can't see the imageUrl being change at all... Does anyone have a clue?

View 3 Replies

Web Forms :: How To Change Src Of Embed Tag Runtime

Apr 12, 2010

i m using embed tag for displaying video file.i want to change file in src attribute of embed tag runtime when i click on button.how can i access embed tag in my .cs file .

View 2 Replies

Web Forms :: Change Css Classname At Runtime In C#?

Jan 12, 2010

How to change the css classname of <div> tag at runtime in c#?

View 6 Replies

Change UserControl Template At Runtime?

Aug 30, 2010

Is it possible to change the ascx file used by a usercontrol at runtime?

For example in my page i have

<ctl:SampleControl runat="server" />

in the web.config I have

<controls>
<add tagPrefix="ctl" tagName="SampleControl" src="~/UserControls/SampleControl.ascx" />
</controls>

At runtime I would like to be able to change the ascx to another path, it would still be inheriting from the same usercontrol codebehind, it would just be a different template.

View 1 Replies

C# - How To Change The Background Image Of The Tab On Runtime

Nov 15, 2010

I have tabs in a page. Each tab has a background image of fixed length. So when the text for the tab is bigger("arrangement help"), it displays "arrangement" in one line and "help" underneath. My goal is to display arrangement and help in one line. Tabs have to customizable.I am using css for regular tabs.

#tabs a {
float:left;
background:url("../images/selection_deselect_bg.jpg") no-repeat right top;
margin:0;
text-decoration:none;
width:105px;
text-align:center;
height:24px;
font-size:12px;
color:#00779c;
font-weight:bold;
text-decoration:none;
}.

In the aspx page, tabs are defined like this

<div id="tabs">
<ul>
<span id="Tab1" runat="server">
<li id="li1"><a <%=strpage1anchor%> <%=page1display%>><span style="text">
<asp:Literal ID="litPage1" runat="server"></asp:Literal></span></a></li>
</span>

I have an bigger image and i am able to get the size of the text in tab. But how to use bigger image for the tab? How to use change background on runtime.

View 2 Replies

Web Forms :: Change Latest News Runtime?

Sep 17, 2010

one of my client has the requirement of changing the latest news section of website dynamically or runtime so not to publish the site and host it agian and again.this section is in master page how can i achieve this in asp.net c#

View 4 Replies

Change Gridview Cell Color At Runtime?

Jan 27, 2011

Tried this:

Code:

Protected Sub gvCriticalMaterials_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvCriticalMaterials.RowCreated
If e.Row.RowType = DataControlRowType.DataRow Then
If Trim(e.Row.Cells(7).Text) <> "" And Trim(e.Row.Cells(10).Text) <> "" Then
If Convert.ToDateTime(e.Row.Cells(7).Text) < Convert.ToDateTime(e.Row.Cells(10).Text) Then
e.Row.Cells(7).ForeColor = Drawing.Color.Red
End If
End If
End If
End Sub

But it never shows any value for text in the cells.

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved