Forms Data Controls :: Dynamically Add New Column To A Datagridview?
Feb 15, 2011I 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.
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.
I am using C# , ASP .NET 2.0 and i have to avoid the datagrid view items from being wrapped.
View 4 RepliesI am having datagridview control with dynamically added BoundField columns.I want to have tetxboxes in each cell of the gridview so taht user will enter data in gridview textboxes and at last on button click it will be saved in database.
View 14 RepliesI 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?
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 RepliesSo I take all my current query and through it into my gridview and it works great. What I need to do is grab some data from antoher query and add on columns if anything exists in the data. How can i create columns dynamically and add them onto my existing gridview if data exists.
Sql = Select intMetricId, strBenchmarkName, intBenchmark from tblbenchmark.
myDataTable = New DataTable
myDatatable = GetData(sql)
mygridview.Datasource = mydatatable
mygridview.databind
So strBenchmarkName would be the new column heading name and then all the 12 rows of data would be the inbenchmark if any exists.
How can i new columns on an existing gridview if anything exists in the datasource.
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 an asp:Table. Its with is 100%. This table has only one row but 6 columns. The width of first 5 column is fixed at 150px. The last one does not have its Width specified and so it takes up the rest. The whole row has a background. If any of the first 5 column is clicked, the background of that cell is changed to white.In my development computer, the last column has about 250px. Yet in user computer, as the monitor has a smaller resolution, the last column has only 30px or so. User complains it is ugly and wish to merge the last column with the previous one. How to do so?
Source code:
[Code]....
i have a gridview and dynamically creating columns and bounding using datareader source.
HyperLinkField hFld = new HyperLinkField();
hFld.DataTextField = dataReader.GetValue(1).ToString();
hFld.HeaderText = "Doc No";//dataReader.GetValue(2).ToString();
i want to to replace the hyperlinkfield with a template field that contains a hyperlink WITH ID where hyperlinkfield does not have ID and be bound to the same datasource above because i want to make the abililty to set the navigate url attribute using rowdatabound
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink hFld = (HyperLink)e.Row.FindControl("hyperlinkID");
lnkTicket.NavigateUrl =
"javascript:w=window.open("+e.row.cells[2].text+".pdf','','width=400,height=400')";
}
}
I populate a gridview dynamically which has differen column numbers depend on requirements. My goal is to adjust column width dynamically. I have tried several methods and events, then RowCreated event of GridView looks best one to do. My code is as below. When
i check result at the ViewSource on the browser, i can see that width of <td> successfully adjusted. BUT nothing changes on the browser, column width always as wide as text?
My Code [Code]....
HTML RESULT SUCCESSFUl [Code]....
I just wanted to know if there is any way to dynamically set the width of a column inside a table within a datalist based on the length of the text fetched from the database.I am inserting my code.
[Code]....
I have a auto column generated GridView in a page, I have a dynamically binded column in that gridview, when page loads then sorting option is available on all other columns except that dynamically created column.
[Code]....
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
I've already searched to no avail for an answer to this question:is it possible to dynamically alter the page size in a paged gridview based on data in a particular column?In other words,let's say I get data from a table that lists students enrolled in a particular course.If there are 10 students in Course "A," then I want page 1 in my gridview to show 10 records.
If there are 15 students in Course "B," then I want page 2 in my gridview to show those 15 records,and so on.I imagine that this could probably be done with a master-detail kind of set up,but let's say for the sake of argument that I don't want to go that route.
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 am dynamically creating my grid view as:
HyperLinkColum hlc = new HyperLinkColum();
hlc.Datatext.DataTextField = "PK";
myGridView.Colums.Add(hlc);
I wanted to call a page say "test.aspx" and to send the primary key of the relevant row to the "test.aspx" page and then how to retrieve this values in the "test.aspx" page
I have a dynamically created grid view in the load even of my web page. I am setting its data source at run time like
gv.datasource = someObject.getItems();
gv.dataBind();
Now I wanted to hide, that is to make some of the columns visible false.
First how can I do that, Second should I write the code in the same page_load event or I should write the code some where else, cause when I add this line of code
gv.colums[0].visible=false;
an exception is produces "Argument out of range"
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 ?
i hav a dyanmically generated gridview with autogenerated columns = true.. i want to change the width of a column of a grid... i tried to do it in row databound event as...
e.Row.Cells[1].Width = Unit.Pixel(300);
but it doesnt work... and since d columns are genrated dynamically i cant set d width as grd.columns[0].width =...
I 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'.
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 RepliesI'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.
I am trying to dynamically create radio buttons based on one of the grid column. If the grid has four rows, it means that there are 4 time slots in the time column and I need to display 4 radio buttons after click of a button on the page. I am able to display radio buttons but dont know how to display dynamically based on grid
View 1 Repliesi have made a gridview which contains three fields, two textboxes and one combo box. ComboBox fetchs data from table(SQL) and when a combox box triggers, data related to combo must be added in two boxes. i did this throw another button, but i want this to be trigger directly when it clicks.
View 1 Repliesi want row index & column header(index) of the selected cell of datagrdview, all colums are dynamic.
View 3 Replies