I need to change the contents of the datafield to make it look a bit more userfriendly. What I have at the moment is as follows: <asp:BoundColumn DataField="retired" HeaderText="Retire Status"></asp:BoundColumn> Where the "retired" is extacted from a database table and has a bit datatype; ...more >>

I have a datagrid that I created and fill a dataset using a stored proc. and bind it. The first column( a linkbutton button column) in the DG contains a number, the second a name. When the user presses the button I need the number displayed on the link. The number is a field from the database. ...more >>

I have a datagrid on a page .. which can be very large .. a couple of hundred rows and 20 columns. Some of the columns are custom templates allowing the user to enter in text or select a checkbox .. since there are several postbacks while interacting with the page .. reducing the viewstate size...more >>

I created a simple datagrid that was populated from a SQL stored procedure. SP Select LNAME + FNAME as NAMETEXT, DATEHIRE as DATETEXT from employees did this in ASP.NET>> tmpSQL.SQLDB.Open() tmpSQL.SQLCmd.CommandType = CommandType.StoredProcedure tmpSQL.SQLCmd.CommandText = "SP_GETNAMES" ...more >>

Hi, I cannot grab the text of a datagrid row's cell. I am trying to access the value in the datagrid's ItemCreated event. I use a conditional statement in the ItemCreated event to ensure that I'm "looking at" an Item or AlternatingItem. I have checked out numerous posts related to this, bu...more >>

This is probably a simple one, but I cannot seem to find an example. I have a datagrid with each row containing Checkbox | Textbox | Validation When the checkbox column is checked for a given row, TextBox is enabled, initialized with a value and the validation is enabled. When the ch...more >>

How do get my pageIndexChanged event to fire? --Code behind fragment Public Sub PromoGrid_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles PromoGrid.PageIndexChanged PromoGrid.CurrentPageIndex = e.NewPageIndex bindDataGri...more >>

Hi there, I'm looking for a way to add a row to DataGrid without binding the data source to it. In the DataGrid code, when DataBind() is called, ViewState is discarded and new set of controls is created with the values from the datasource. On a postback, DataGrid recreates the controls ba...more >>

Hello, I need to create a DataGrid that looks something like this... <HyperLinkColumn><ButtonColumn><Data><Data><ButtonColumn> but I can only seem to produce a DataGrid as below... <HyperLinkColumn><ButtonColumn><ButtonColumn><Data><Data> Can anyone help? Many thanks in advance. ...more >>

...more >>

Hi all, I'm still wet behind the ears about asp.net. One thing I need to understand at the moment is the difference between the various ways of displaying data in datagrid. One way is, <asp:BoundColumn DataField="last_name" HeaderText="Last Name"></asp:BoundColumn> And the other is, <I...more >>

Is there a grid control, or is it possible for Asp.Net to freeze the first column, and the headers where the headers would always display regardless of vertical scrolling? And the first column would always be in the most left side of the grid regardless of the horizontal scrolling? Thanks,...more >>

Hi all, The DataGrid (or reader) sure makes life easier for the vast majority of sql query display jobs but I've come across something that is almost making me wish for the old classic asp days. I'm not ready to start coding in the aspx page like a class asp'er yet so i'm hoping someone has ...more >>

I am a .NET newbie and have a simple question. I have a simple web form wherein the user can enter qty (which is a textbox field) for items he wants to purchase. All the columns in the datagrid on that form are bound except for the qty column which is of type templatecolumn and contains a text...more >>

Hi everyone, I'm using a DataGrid with TemplateColumns. My DataGrid is located in a cell of an asp:Table. I did this so it's positioned correctly onscreen. One of the DataGrid's TemplateColumns is a checkbox. During the page's postback I loop over the DataGrid and read the checkbox va...more >>

Hi TO All I am doing one task, in that i want to insert datatable data int database at a time.i.e., i am creating one datatable and i a inserting data first into datatable, then i am updating or insertin that datatable data into database.i am not getting this, if u know pl help me... Tha...more >>

I have a page displaying a datagrid and the user wants to have two options: 1. Export the current "Displayed" datagrid to Excel 2. Export another Datagrid very similar to the first, but with many additional columns I'd like to run just one stored procedure and populate both datagrids on the ...more >>

Hello, I want to set invisible data into a cell control such as label. The goal is to retrieve this information in a postback. How can I do this ? What about a "viewstate" per row in a datagrid ?? TIA. ...more >>

I designed a data grid for a results page for some product data. The specific data put in the data grid is based on criteria entered into an initial search page. I have enabled sorting in my data grid and have a column of links which access a report on a specific product. However, after I cli...more >>

Hi, I had posted the below question and received a suggestion from Fiaz, and then I posted a followup question but received no answer. This was a while ago so I thought that I should repost this. I hope Fiaz reads this, but if not, does anybody else agree with Fiaz's suggestion? Oldest mes...more >>

How does one go about changing the foreground color of a linkbutton like "Select"? ...more >>

I have a button on each row that just highlites the row. then I new to click a button on the form and retrieve the columns who's row was highlighted ...more >>

Hello, I need to create a DataGrid at runtime with a EditCommandColumn. Everything works fine only the events of the EditCommandColumn, which are not firing correctly. If I click on "Edit" the right Event-Handler is used but when I click on "Update" or "Cancel" the Event-Handler for the EditCo...more >>

Hello there, I have a data grid that's going to display a but of data that I want to make editable. Problem with this is that there goign to be too many columns, and the data grid is going to be too wide to be practical, so I think the best bet is just to make the editing done on a separate p...more >>

Hi all, Im using the HierarGrid control provided by Denis Bauer at http://www.denisbauer.com/ASPNETControls/HierarGridDemo.aspx I am having problems when tryin to implement in my application. I updated the code accordingly and created datarelations amoung the dataset. It throws me some...more >>

Hi... I am pretty new to the .NET especially Visual C++.NET . I have a question maybe the experts here can answer. I have an XML file and the data from that is displayed on a datagrid. However I wish this data to be modified and new data to be added as well as deleted. Any ideas..? Sample cod...more >>

I thought I could insert a new row in a DataGrid in code by calling CurrencyManager.AddNew; but it does not work. I want to open a new row that the user will then fill in. What am I missing? -- ..Bill....more >>

just like reminders..........i want to send an email comparing with date(the date is in datagrid)..sending email is not a problem for me...but how to comare the date and where can i write code...... one of mr friend is said that this is possible with windows service.... suggestions...........more >>

I need to auto rotate/scroll the contents of a datagrid. Currently I have a datagrid wrapped inside a <marquee> tag... this works, however there is a gap when scrolling (marquee issue). Any thoughts? I've looked into telerik's rotator control but it wont rotate a datagrid. Thanks. ...more >>

Hi I have a list of files in the filesystem and the paths and filename to these files are stored in records in a database. I need to display these files as links from which the file can be downloaded in a datagrid column . I am using the Templatecolumn with ItemTemplate and am assigning <br...more >>

In case anyone else runs into this issue... I recently wanted to set alternating item style on a grid row that contained a template item for the entire row. This template item contained html table tags. This allowed me to make each single grid row a multiple row table (I needed each grid row t...more >>

Hi, In my datagrid I have a textbox with a hyperlink next to it. When the user clicks on the hyperlink it will pop open another window with a calendar control, and when the user clicks a date, it will put that date in the aforementioned textbox and close the calendar window. Here's the java...more >>

My problem is very simple... (All codes are in ASP.NET & VB.NET) There is a data grid like - Name Age Height KA 12 100.2300 ZX 14 101.0500 XY 9 98.1000 When I export it to excel it gets like, - Name Age Height KA 12 100.23 ZX 14 101.05 ...more >>

agrids on six different pages which are editable. They each draw from a different SQLServer table. 2. When data is changed in any rows, the Row ID gets added to an array, and then a Stored Procedure updates the database table by looping through the array of Row ID's. I'm using the RowChan...more >>

Hi, can you please try to filter the following data using rowfilter and se whether it works or not. Note: Have to escape [ and ].So, [ is written as [[] and ] is writte as []] Three records in the database are: 1# [1222 -2201] 3# [1212 - 2200] 12# [1122 - 3201] Let say i want to get th...more >>

hi, i face some problem in using rowfilter for visual basic.net. As i know if the string contains either [ or ], then these two characters must b escaped in square bracket like [[] or []]. for example, if the strin is "hello[test]", then it must be written as "hello[[]test[]]". Now, face the ...more >>

Hello there, in my training in data access I am getting lost with somenthing maybe pretty easy but I don't seem to find a way out. I would like to bind some data that I get form a simple SELECT stored query in access called sp_Leggi that looks like this SELECT TOP 10 * FROM [Clienti]; ...more >>

I would like to highlight a datagrid row with the up/down movement of the arrow keys. I already have row highlight working with MouseOver. Is there also a way to get highlighting to respond to an up/down event. I have not been able to find anything on this via Google. Thanks for any adv...more >>

I have dropped a DataGrid (.NET Framework 1.1) on a page, and using the VS DataGrid Property Wizard, have added a button column with Edit, Update, Cancel. The grid displays correctly and when I click the Edit button, I get the expected result of the Edit Command being triggered. My problem is...more >>

I have a DataGrid in which I use paging, as well as Delete buttons. My program works perfectly, except when I attempt to delete the only item on the page; I have no trouble deleting an item when there are more than one item on a page. For example, I have a list that is three pages long; there...more >>

Hi all, I dont know how to display a parameterized Crystal report in Asp.Net page... e.g. I give input of Student Code range and then click on View to display Crystal Report. Could anyonw help me ?? ...more >>

I have 4 datagrids (dg1, dg2, dg3, and dg4) on a webpage. I know how to loop through the rows in each individual datagrid, but I need to loop through all 4. Is there a way to loop through the controls on the page, determine if it is a datagrid or not, then I can continue my loops? I have ...more >>

If you aren't going to answer the posts within 2 business days, then stop promising such. ~sysdesigner...more >>

Can the datagrid in Asp 1.1 be configured to use color definations from a CSS file? ...more >>