Just trying to connect an ASP.NET page to an SQL database. When I run the page, I get no errors but no recordset results are returned via the datagrid control -- it is completely blank. The only thing displayed is the "Job Dispatch List" page title which executed as plain HTML. Code is as ...more >>

I have a form with a datagrid control. And I have a button that will retrieve data and upon postback, the datagrid gets populated. What I would like to have is, upon the loading of the form (before postback), have the datagrid display the header with all the column headings. Right now, n...more >>

Hi everyone, I'm binding an ArrayList to a DataGrid for the first time (I'm used to binding DataSets and DataTables) and I was wondering if I could somehow "name" the ArrayList, so that I can refer to it as a DataField in an asp:BoundColumn? In essence, I'm doing this: ArrayList Arr1 ...more >>

I have a datagrid with a button column. When the user clicks a button in the datagrid, a PDF should open in a child window. To make this happen, I use the grid's ItemDataBound event to add client side code to call a JavaScript function to open the PDF window. Most of the time it works corre...more >>

Hello sirs, In my aspx file I have a datagrid with some BoundColumn's. When a format has been defined for a column (for colors, horizontal alignment, etc), it adds an ItemStyle element inside the bound column element, as in this example: <asp:BoundColumn DataField="DEEMAIL" SortExpression="...more >>

Hi I've got a nasty problem with my datagrid. Sorry for the long post, but I am trying to be clear and compact here. FYI - About my datagrid: ------------------------------------------------------------------- I have in the datagrid and an EditCommandButton like so: <asp:EditCommandCol...more >>

I have two datagrids .... after handling the click event in one datagrid ..... using its data i query the database and get the data for the second datagrid in both the grids i am generating the columns dynamically the problem is in the second datagrid the columns are appearing twice i d...more >>

Hi everyone !!! I have a problem here with the DataKey when i try to retrive the data from the DataKeys[e.Item.ItemIndex] i get nothing out of it ... can anyone tell me the reason for this ....plz do help me The main thing i want to do is display a datagrid first and then depending on t...more >>

Hi, How we could do moving up and down the datas in a datagrid. Is there any way could do this without hitting the server . thanks in adavance John S ...more >>

Hi, I am using the following code to display a datagrid on my page. Now one of the columns is of type DateTime(DataField="myDate"). Now when the datagrid is being shown, the date is given in the following format: 4/30/2005 12:00:00AM Now I require to show only the date, ie time is not requi...more >>

Hi All, I don't know why my program exports to excel which can't convert cell format ? for example, I am using the following code: Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment; filename=OutstandingOrderDetailReport.xls"); "OrderN...more >>

Can anyone please tell me what is wrong with the following code: I have a datagrid showing data from in a DataView. The following code snippet is supposed to delete any rows where the 'LineType' column contains WD. The strange thing is it works sometimes (10%?) but usually I get an error: ...more >>

I have two tables one company table and the other products table ... the main datagrid should show the details of the companies and it should contain a button which on clicked will display another datagrid embedded in the first datagrid which spans all the columns of the first datagrid .... ...more >>

I am using MXDatagrid with paging. I set allowpaging=True in property. But paging is working for only 10 pages. if i clik 12 or 13th pages it return back to 2 or 3 page recpectively. Pls help to me. Very Urgent!!! sample: My paging will be: 1 2 3 4 5 6 7 8 9 10 ... if i click "..." the 11th...more >>

I have TextBox column in datagrid. I would like to update database with values when user click on button (outside datagrid). Dim cell As TableCell=datagrid.Items(row).Cells(col) textbox=CType(cell.FindControl("TextBox1"), TextBox) If user change text of TextBox in one column, command: tex...more >>

I would like to read data from datagrid. How can I read one cell from datagrid (raw, column). How can I find out total numbers of raws. Thanks for help, Simon ...more >>

I've got a data grid that uses viewstate to maintain its state between posts. I also have a button outside of the data grid which, when clicked, in its server-side click event handler, sets a mode value (in viewstate) that I want the data grid's ItemCreated handler to act on. However, the Item...more >>

How can one control the pagination of a grid. When I print the last row on a page gets cut in half. I have seen discussions on style sheets but can they control the pagination as well? Also my grid prints ok for the first page but subsequent pages have no internal dividing lines only the bo...more >>

I need to add a button column to my datagrid. I need to be able to do this at runtime. I can not have the tag <columns></columns> in my aspx page. This is where I am at Private Function CreateProjectDataSource(ByVal projectds As DataSet, ByVal dg As DataGrid) As ICollection Try Dim btn A...more >>

Is it possible to set the column widths of a datagrid? This is driving me crazy, and I haven't found a solution yet. I'm pretty new to ASP.NET so there may be an easy way I'm just not aware of, however, I've Googled this until my eyes hurt and still haven't found a solution. Also, how would ...more >>

Does some one know how to execute a DTS from asp.net?...more >>

Hi In my datagrid I have a textbox in an EditItemTemplate like so -------------------- <asp:TextBox id=txtPrice ontextchanged="txtPrice_TextChanged" runat="server" AutoPostBack="True"> -------------------- I also have back end code like this: -------------------- Sub txtPrice_TextC...more >>

Hi all, I have met some problems in implementing paging with datagrid control. From what i know to do paging we must use sqlDataAdapter and dataset but I am using microsoft access database instead of SQL server as a result i cant use SqlDataAdapter and dataset to retrieve data from micr...more >>

All that I want to get the DataKeyFielD this is the under code Response.Write(DataGrid1.DataKeyField[i].ToString()); but the result is no I want .. <!-- html.. --> <%@ Page language="c#" Codebehind="DG_DataKeyFied.aspx.cs" AutoEventWireup="false" Inherits="ForTest.DG_DataKeyFied" %> ...more >>

How can I judge which checkbox is checked ? for(int i=0;i<dgOrderList.Items.Count;i++) { CheckBox ordercheck=(CheckBox)dgOrderList.Items[i].FindControl("OrderCheck"); if (ordercheck.Checked==true) { Response.Write(i.ToString()); } } and no results that ...more >>

I have set the configuration as the attchment jpg file however,when i click the hyper link , it only show the url as below: http://localhost/content.aspx?key_word= even I have chosen the url field is "word" which is a data column in my datagrid And I want to url output as: http://local...more >>

<http://www.insidemacgames.com/> ...more >>

Hi, I am showing a messagebox with the following method: public static void ShowMessageBox(HtmlTextWriter htmlTextWriter, string message) { htmlTextWriter.Write("<script language=JavaScript>window.alert('"+message+"');</script>"); htmlTextWriter.Flush(); } // end method showMessageBox...more >>

I have datagrid with buttons in one column. In ItemDataBound I can disable cells by: e.Item.Cells.Enabled=False How can I do exact thing by disable only buttons, not entire cells. Thanks for answer, Simon ...more >>

I have a datagrid with a checkbox column, and dropdown list that does a autopostback. Basically, the dropdown list is a filter for the datagrid. Here is my workflow. 1. Load .aspx page. 2. Click on filter to show certain results in datagrid. (This will do a autopostback) 3. Select item from...more >>

I have a datagrid in an ASp.net application. Only one column is created at design time, rest of the columns are created and added to grid on the fly. When I try to update values in datagrid through UpdateCommand event code errors out. e.Item.Cells.Count returns 1 even though I have more colu...more >>

Hello, i am new in asp.net and i am having a question: I am having a datagrid_1 in which i am showing the context of PatientDetails table. When the user double clicks on a row i want to display on a new datagrid_2 (in the same form) the information which corresponds to that patient, but fro...more >>

Hello there, I have a datagrid that has a select button (so the user can choose a row) and also uses the datagrid sort. If I have a smaller grid (say 150 rows) the response time of the sort or select button (that just opens a popup with some information) is a couple of seconds. If I load...more >>

Hi guys. I have a datagrind that is bound to a custom collection of a custom object. When a delete button is pressed in the datagrid, I not only want to remove the row from the grid, I want to delete the object from the collection that is bound to the grid. So far I have this. public ...more >>

I have the followng string in my web.config file. <add key="DBConnInfo" value="Data Source=SQL01;Initial Catalog=DatabaseName;Trusted_Connection=No;Persist Security Info=True;User id=sa;password=password;" /> Where I am passing a user id to be connected to a sql db. Instead of passing a use...more >>

Hi I am a newbie ASP.net programmer and can't find a decent code sample to insert/delete/edit rows in a ASP.net datagrid. Thanks Jim ...more >>

I am using VB 6 and have a bound datagrid pulling data from a Pervasive Database by ODBC connection. Column 3 shows opening balance and columns 4-15 show net movement for each month. I want to have a text box on my form that shows sum of columns 4-15 for active record. How do I do it? my code is sho...more >>

Sorry to post this in 2 groups, but I just found this group after posting to the other group. I am using the datagrid. I have allowpaging=3Dtrue. I load the data and there is about 7000 records. At the bottom there is pages 1 through 10 and (...). The first time I click on (...) it tak...more >>

I have several DropDownList Controls (ddlOrder, ddlContact...) where the user may select multiple values and let the results be displayed in the datagrid. I know how to filter when chosing from any of these dropdownlists. But don't know how to filer if the user wants to filter based on selecti...more >>

I have a datagrid with a hyperlink column. Now i want to program for the click on the hyperlink. where do i put my code?...more >>

Hi there just another question regarding paging in a datagrid. In my datagrid i have paging setup for 10 records per page this is fine when there are 10 records in the grid. my issue is that if you have 22 records the first two pages of the grid look fine but the third page will have the 2 rec...more >>

Hi, I have a datagrid that I build using data returned from a SP. But I populate the datagrid using a dataview. In this dataview, I populate one of the columns with a string that is basically an html link. The display text is always numeric. For instance, the column will display 7, but t...more >>

For those interested in the next version of ASP.NET... Start building an ASP.NET 2.0 site today: Download Visual Web Developer 2005 Express Edition http://lab.msdn.microsoft.com/express/vwd/ ...more >>

Here is an easy issue to reproduce: 1) Create a new project. 2) Drop a DataGrid control into the Page. Also drop a OleDbDataAdapter into the page. 3) Select "Configure Data Adapter..." and pick the NWind.mdb (for example). Go ahead and run through the wizard, selecting a table via sql query...more >>

I want to clear datagird data at memory (Client) but unsure how effective the impact? Coding ------- Sub CLEAR(Sender as Object, e As EventArgs) Rpt_GL_BatchNum.Text = Nothing Rpt_GL_BatchType.Text= Nothing Rpt_GL_DocNum.Text = Nothing Rpt_GL_...more >>

Hi there, This might be a simple enough question for most of you. But I am pulling my hair out with this. I have a datagrid populated from a database. Its a booking form. You push a button column to select the row. And now I need to give some specific details from that row in to a label. L...more >>

Hi Silly question here I guess..... I know I can use an EditCommandColumn to edit a particular row in a datagrid: -------------------------------- Private Sub DataGrid_Edit(ByVal source As System.Object,ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid.Edit...more >>

Hello! I have this strange thing happening here. I'm unavailable to use paging in my grid? I set the AllowPaging to True, and I placed a code into the PageIndexChanged. When I set a breakpoint into the PageIndexChanged it doesn't go there at all. Can anyone give me any idea of how to get...more >>

I have a 2.0 GridView <asp:GridView Runat="server" ID="GridView1" DataSourceID="AccessDataSource3" BackColor="Gainsboro" BorderColor="#336666" BorderWidth="3px" BorderStyle="Double" CellPadding="4" GridLines="Horizontal" AllowSorting="True" AutoGenerateEditButton="true" DataKeyNames="Universi...more >>

When the mousepointer is hovering over the text area of the grid, it switches to the "I-bar"... I would like it to remain the standard pointer... is there a way to do that? ...more >>