.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

My Grid Don't show the data

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :ASP.Net
Hi Dear I have one gridview . and sometimes I face with this error that it cannot show the data bound to it .. I use myGrid.Datasource= .. nad myGrid.DataBind() wherever it is needed .. what is the the problem ?

View Complete Post

More Related Resource Links

show data in grid view error Arithmetic operation resulted in an overflow.



i have a table there is 17 columns in 17 column 3 are number and other are varchar . when i try to display all data of that column error occures.

one more intersting think is when i try to display 6 column then grid show there data an no more error occures. 

when i run my project this error occures in grid view

Arithmetic operation resulted in an overflow. 

Expand rows in a data grid to show details in the same page

<asp:templatecolumn headertext="Purchase Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "PurchaseOrder") %> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <a href="OrderDetail.aspx?Order=<%# DataBinder.Eval(Container.DataItem, "OrderNumber")%>"> <%# DataBinder.Eval(Container.DataItem, "OrderNumber") %> </a> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Ack Date"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "AcknowledgeDate") %> </itemtemplate> </asp:templ

Show Data in Grid with Heading along Y axis



Im not sure what control to use, I want to show a list of results in teh following format

Car Name                           Ford                         Fiat                  Opel
Car Accessory
Leather                               Yes                          No                    Yes
Power Steering                   Yes        &n

GridView control to show master-child or master-slave data, written in c#, asp.net

I previously made a master slave datagrid using Visual Studio 2003 .Net (original article) that would allow users to show data to clients using collapse and expand features. These features however did not carry over to gridview for many users. This tutorial will explaing how to create a collapsable/expandable gridview in frameworks 2.0 and higher

Building a Custom Data Grid: Performing Ad Hoc Web Reporting with a VBScript 5.0 Class Object


A flexible, customizable grid for displaying data is a useful tool for ASP developers. It allows Web visitors to customize their view of your data. This article takes the data grid presented in "Ad Hoc Web Reporting with ADO 2.0" by John Papa and Charles Caison (MIND, December 1998) and adds handy features such as a finds feature that supports multiple finds and a mode for adding and editing records. This version also improves response time by allowing asynchronous record download and it componentizes the code so it can be used as a standalone VBScript class object that can be reused in other pages.

Randall Kindig

MSDN Magazine July 2000

show two tabs for different data


I need ure help,

my question is that I need to show a tab two times in my web page ,,, each time this tab will be showed it will have different data will be called from a database while the page loaded >>>> when I use my code I can show the tab one time only

I will insert my code here look at it and tell me where the error

<td align=left >
    <cc2:TabContainer   ID="TabContainer1" runat=server BorderStyle="None" BorderColor="White" BorderWidth="0">
    <cc2:TabPanel  ID="TabPAnel1" runat=server BorderStyle="None" BorderColor="White" BorderWidth="0px">
   <asp:DataList ID="DataList3" runat=server  >
<cc2:CollapsiblePanelExtender ID="CollapsiblePanelExtender1" runat="server"
                TargetControlID="PnlContent" ExpandControlID="PnlTitle" CollapseControlID="PnlTitle"
                TextLabelID="Label1" CollapsedText='<%# Eval ("BookName") %>' ExpandedText='<%# Eval ("BookName") %>'
                ImageControlID="Image1" ExpandedImage="App_Themes/ima

New Data does not show in DVWP


I have two web parts on the page. The left one has regions listed. Clicking on a region hte right web part (DVWP) displays the data about that region (sales, etc.). 

Everything works as expected. Now, I added a region. And the new region does not show up. The regions are in an SP list. I am using SP 2003 and SPD 2007. 

I can see the new region data in a standard view or a datasheet view.

Can someone please help? Thanks much.

Show data in RowEditing mode


hello ,

        I have show data in gridview. when search item. And for updating We use Edit button. When I click on edit button it doesn't show data. I have also bind again data. It doesn't show data . The gridview doen't display.

        but When I enter search number again then display it.

I have paste some code snippest.

protected void gvFaxValidation_RowEditing(object sender, GridViewEditEventArgs e)

         gvFaxValidation.EditIndex = e.NewEditIndex;

         GridViewRow editingRow = gvFaxValidation.Rows[e.NewEditIndex];


         if (ddlSearchCriteria.SelectedValue == "PRESCRIBER_ID")

             gvFaxValidation.DataSource = objMasterBLL.FaxSearch(Txt_Search.Text);


FieldTemplate_Edit to show value when custom meta data is set editable equals false

Have a custom FieldTemplate (RadioButtonChooser_Edit.ascx) that shows a radiobuttonlist based on a single character.  Using LinqtoSQL/DynamicData enabled.Example G, F, P  (Good, Fair, Poor).If the custom metadata for a field in the table is set  [Editable(false)]  I get a G, F, or P.  I would like to show the full word when editable is set to false.  Not sure how to approach this.

Show Data in Sequence

I am trying to creat a report which shows qualification and contract information of employee.Each Employee has usually more than one qualification e.g intermediate, graduation, masters etc..Similiarly most of the employees has more than one contracts in their history.i have split reprot into two details sectionsSection contains data Qualifcation: TitleInstitueYearsGrade/DivisionSection B ContainsContract Information  starting date  ending date  reference letter no   joinging letter no------------------------------------------------------------------------Now what report shows is as followsQualification  first qualificationContract Information first contract Qualification second qualificationContract information second contractwhat i want is that qulification and contract infromation should be shown in sequence e.g first all qualifications then contract please let me know how can i do that

Unable to Show Edit item Links in Data Form Web Part

I have a DFWP connected to custom list and the boxes to Show Edit Item Links, Show Delete item links and Show Insert Item links are grayed out so that they can not be checked. This works fine when I use a DFWP connected to a standard list (i.e., Contacts). Is there something special that needs to be done to activate this functionality?ThanksDean

Show Calendar Control SQL data value using Label control

Hi, I have a Calendar Control which is getting certain dates from SQL database and shows them in gray colour using following SQL statements: protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { DateTime nextDate; if (dShows != null) { foreach (DataRow dr in dShows.Tables[0].Rows) { nextDate = (DateTime)dr["Date"]; if (nextDate == e.Day.Date) { e.Cell.BackColor = System.Drawing.Color.DarkGray; } } }  SELECT Count(Mytable.ID), Mytable.Date,MAX(Location.SLocation) as Location FROM Mytable INNER JOIN Location ON Mytable.Sh_ID=Location.Sh_ID GROUP BY Mytable.Date Everything works fine but I want to Show Location and Date also under the calendar control usnig Label control so when user clicks highlighted date it shows Date and Location (only the ones which are coming from SQL database and are highlighted) using Label control. Thank you.      

Cannon add new Data Source in Grid in VS2005 using SQL Server2005

I am a student and started out with VS2010 on my laptop.  Due to compatibility issues, I had to start using the provided version, 2005.  I uninstalled 2010 and now have the trial version of VS 2005 as well as SQL Server 2005. I have a data grid on a windows form and am attempting to use a database provided for the class.  When I use the smart tag to start the Wizard, as directed I do the following Select Add Project Data Source Choose Type..Database..Next In Choose Data Source Window, I select New Connection  Data source: MS SQL Server Database File..Continue In Add Connection Window, Data source: SQL Server Database File (SqlClient) Database file name...browse to database file in Student cd (E:\StudentData\DatabaseFilesSQLServerVersion\RnrBooks.mdf) Log on to the server: Use Windows Authentication And then press Test Connection Here is the error that I get: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.  The connection will be closed  

how to stop refresing data grid when selection changed

Hi , I have datagrid on my page bounded with linq datasource. I want to stop refresing datagrid when I need to show details of selected row. Could you please help me to do that. Regards Reside 

Assembly items don't show in SSIS Data Flow

I successfully add a new assembly (MapPoint Batch Geocoder.dll) into GAC using Mscorcfg.msc and I can see it from the assembly list and I've added the dll into SSIS's PipelineComponents folder but for some reason I just cannot see it from SSIS Data Flow Item tab, I saw some others have the similar issue, and I actually tried to fix it based on their solutions such as change the framework version, but nothing changed. I am using VS2008, .NET 3.5 framework. I don't understand how come I can see it from GAC and also can see it through .NET tab in "Add References" but just not from Data Flow Item tab? Any ideas? Thanks a lot!

Unable to export data to an excel file in grid format!!!

I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines. I think I'm missing to set some property or somethnig ehwn exporting.   Any help would be really appriciated.

Unable to store combo box value to data grid view control

Hello,         I am using fw 3.5 SP1 with VS2008. I have bind my object collection with data grid view. I can see different values in combo box inside data grid view. But when I select any one value from combo box the selected value is changed to first value of combo box as soos as user leave the cell of the gird. Can anyone tell me where should I look for this problem so that my selected value remains same as user did select it.   Nilkanth Desai  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend