Category Archives: ReportViewer

ReportViewer

[RESOLVED]using RDLC in MVC projects

December 5, 2014Entity Framework, HTML, IIS, PDF, Post, Razor, ReportViewer, View, Web FormsEntity Framework, HTML, IIS, PDF, Post, Razor, ReportViewer, View, Web Formsadmin

We have a MVC 4.0 project and for reporting we used RDLC. We need to have the reportviewer control available in client page, because we want our web application to be very similar with a desktop application.

To work with RDLC we have to use aspx pages inside our project which are loaded inside iframe based on src=… path.

We store these files in Reports folder inside our project.

Everything was working in our development process. We use Visual Studio 2013 with IIS Express.

When we have done the deployment to the production server, we observe that our reports are not working. We receive the 404 error. We have received the same 404 error from Windows Server 2008 SBS and from Windows Server 2012 Standard where we have made the
deployment

Please help us with this issues.

Thank you very much

You may look into using the Reports as "Local Reports" and simply using MVC to render them via their path (instead of navigating to them directly, which would require routing changes). I recently implemented a similar structure to support accessing
data via Entity Framework to populate to populate a few RDLC Reports that I had created. Although this may not be exactly the approach that I took, I would recommend

taking a look at this blog post on the topic.

If you don’t want to take that approach and would prefer to render an actual Report Viewer directly within an MVC View (or navigate to an ASPX page that contained your report), you might be better off using an approach
like this one.

Hi horia,

First, please refer to Rion’s reply.

Secondly, please use
Server.MapPath to generate the path dynamically.

On the other hand, there are some articles about report that can help you:

# ASP.NET MVC Html Helpers for ReportViewer Control.

https://github.com/ilich/MvcReportViewer

# Prototype MVC4 Razor ReportViewer? RDLC

http://www.codeproject.com/Articles/609580/Prototype-MVC-Razor-ReportViewer-RDLC

Best Regards

Starain Chen

if you have internet explorer greater than I.E 8. There is something called developer tools (press F12). on network tab you can start monitoring.

Find the url which is giving 404. Hit the url separately from new tab in the browser, check if you are getting the same 404.

Find the url which is working in you dev environment, get the url from there. Find the difference between working and non working url. It could be because of cross posting, domain bieng different, url bieng wrong, insufficient file permission for files in
reports folder. If there are physical file, you might also want to set it up as static file at IIS level or in web.config

In the first approach I can not see report toolbar at client. I want that client to be able to navigate from page to page, choose option to export in XLS, PDF.Doc, to be able to print and to choose the printer like in desktop application.

second approach I have to test in the next days and I will let you know.

But I have one very logical question. Why it is working in developing with IIS Express and is not working in production server with IIS. For me this is unbelievable.

Thanks for reply

Of course I have tried with network monitoring and the same path in the IIS express is working fine, but In production environment IIS give 404 error.

IIS Express example:

URL Method Result Type Received Taken Initiator Wait‎‎ Start‎‎ Request‎‎ Response‎‎ Cache read‎‎ Gap‎‎
/Reports/RaportDocumentIesire.aspx?idSucurs=219bc74c-1ab6-11d4-b1e8-00a0d21052ef&idDocument=fcc247d8-ae2a-49f1-ae74-1ac063606932&Format=FACT&lcnrZecimaleCantitate=3&lcnrZecimalePret=2&lcnrZecimaleValuta=2 GET 200 text/html 58.79 KB 0.67 s frame
navigate 2465 0 655 16 0 1014

is working well

IIS production server example:

URL Method Result Type Received Taken Initiator Wait‎‎ Start‎‎ Request‎‎ Response‎‎ Cache read‎‎ Gap‎‎
/Reports/RaportDocumentIesire.aspx?idSucurs=219bc74c-1ab6-11d4-b1e8-00a0d21052ef&idDocument=fcc247d8-ae2a-49f1-ae74-1ac063606932&Format=FACT&lcnrZecimaleCantitate=3&lcnrZecimalePret=2&lcnrZecimaleValuta=2 GET 404 text/html 1.70 KB 125 ms frame
navigate 63 0 125 0 0 13634

If we are looking to the calling path in both cases are the same. The entire structure of the folders were copied from development server to the production. No good results.

Any idea?

Thank you.

Tkank you for your reply. I will begin to study again this approach and compare with article which you recommended.

Thank you

ReportViewer Control in MVC page style issue

December 4, 2014HTML, Razor, ReportViewer, View, Web FormsHTML, Razor, ReportViewer, View, Web Formsadmin

Hi,

I have a ReportViewer Control issue in my CSHTML page. The issue is one of the drop down list in the report parameter is selected, it is displayed above the IE browser address bar. This is occurring when Dropdown have more data items and then it starts displaying
from the address bar to report data pane. This issue is there in IE11 and not in Chrome. Any suggestion?

Hi anulall,

How do you render ReportViewer control in the view? Please provide the detail code.

About doing report in MVC project, please refer to:

# Prototype MVC4 Razor ReportViewer? RDLC

http://www.codeproject.com/Articles/609580/Prototype-MVC-Razor-ReportViewer-RDLC

# MvcReportViewer HTML Helper

https://github.com/ilich/MvcReportViewer

Best Regards

Starain

Thank you for your time.

This is not a code issue I feel. When I access the report directly from report server , same behavior exists in IE 11.

IE11 issue

[RESOLVED]Using rdlc with ASP.Net MVC 5 and EF6

December 4, 2014HTML, Nuget, PDF, Razor, ReportViewer, Table, View, Web FormsHTML, Nuget, PDF, Razor, ReportViewer, Table, View, Web Formsadmin

I followed Dykstra’s tutorial series to switch form web forms development to MVC. I did not see anywhere in that tutorial or any other resources I found on the web how to provide reports via rdlc, outputting PDF, Excel, ReportViewer, …. I do know how
to choose which output to use.

I have a data context say MyContext with associated models, including reasons.cs. I want to simply list the items in the Reason table. I created a web form containing the script manager and the reportVIewer.

How do I get to the info in the model to designate it as the recordset to use for the report? Is everything done in the forms’c CodeBehind or is there a better way to integrate the MVC with the ReportViewer? I have seen various examples of some ways to
do so, but none were successfully using references to the model but rather creating separate new datasets.

AFAIK You cannot directly show an SSRS Report in MVC application.The ReportViewer control requires ViewState to work, so you can’t place it in an MVC view.This doesn’t mean you can’t use it in your website, however You’ll just have to mix in a little bit
of classic WebForms(aspx) and use the ReportViewer there.

As a solution you can try the below mentioned steps

Add a webform page(Reports.aspx) to your solution and then load your reportviewer control and attach the ssrs report to the Reportviewer control. Next

We need to have a place holder which will load the aspx page in MVC3 Razor. Use iframe for loading the aspx page

Add an iframe to your .cshtml page and assign the src to point to Reports.aspx page.

<iframe runat="server" id="Reports" src="~/Reports.aspx"
                    width="95%" height="460"></iframe>

Check the below links

Apart from this you can also check MvcReportViewer which is available in Nugget.

MVC Report Viewer Documentation

[RESOLVED]Crystalreport USer Logon

September 13, 2014Image, Linq, Login, Panel, ReportViewer, Table, View, Web Forms, Wizard, XmlImage, Linq, Login, Panel, ReportViewer, Table, View, Web Forms, Wizard, Xmladmin

Hello,

I am trying to genrate report, and I have done all the necessery database connections but I cannot view my report,its asking for information during logon and If I disable Logon, its saying Database Logon failed!!.

So here’s the Code.what changes do I have to do,or I have use other type of connection..Can anyone help

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

public partial class Default2 : System.Web.UI.Page
{
    Cont1 ctn = new Cont1();
    DataSet ds = new DataSet();
    //DataSet ds2 = new DataSet();
    //store ss1 = new store();
    protected void Page_Load(object sender, EventArgs e)
    {
        ctn.conn();
        //ss1 = Session["data2"] as store;
        //ctn.billing(ss1.bino);
        ReportDocument report = new ReportDocument();
        string reportpath = Server.MapPath("CrystalReport.rpt");
        report.Load(reportpath);
        report.SetDataSource(ctn.ds2.Tables["billDetails"]);
        CrystalReportViewer1.ReportSource = report;
    }
}

MARKUP

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Cont1 class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

/// <summary>
/// Summary description for Cont1
/// </summary>
public class Cont1
{
    public SqlConnection cn;
    public SqlDataAdapter da;
    public SqlCommand cm;
    public SqlCommand cm2;
    public DataSet ds = new DataSet();
    public DataSet ds2 = new DataSet();
    int r_val;

    public Cont1()
    {
        //Contructor logic
    }

    public void conn()
    {
        cn = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=F:ProjBookStoreBookStore_WebApp_DataBookStore.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
        cn.Open();
    }

    //public void connn()
    //{
    //    cn = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=F:ProjBookStoreBookStore_WebApp_DataASPNETDB.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True");
    //    cn.Open();
    //}
    public void fetch(string query)
    {
        da = new SqlDataAdapter(query, cn);
        ds.Clear();
        ds.Reset();
        da.Fill(ds);
    }

    public int dmlsmt(string query)
    {
        cm = new SqlCommand(query, cn);
        r_val = cm.ExecuteNonQuery();
        //cn.Close();
        return r_val;
    }

    //public void ref_usr()
    //{
    //    cm = new SqlCommand("usr_test", cn);
    //    cm.CommandType = CommandType.StoredProcedure;
    //    cm.ExecuteNonQuery();
    //}
    public bool str_pay(string user,string blno)
    {
        cm2 = new SqlCommand("bkPayMod", cn);
        cm2.CommandType = CommandType.StoredProcedure;
        cm2.Parameters.Add("@billno", blno);
        cm2.Parameters.Add("@member", user);
        cm2.ExecuteNonQuery();
        //cn.Close();
        return true;
    }
    public void billing(string bino)
    {
        da=new SqlDataAdapter("EXEC billDetailsOne @billno= " + bino, cn);
        ds2.Clear();
        ds2.Reset();
        da.Fill(ds2,"billDetailsOne");
        //da=new SqlDataAdapter("EXEC billDetailsTwo @billno= " + bino, cn);
        //ds2.Clear();
        //ds2.Reset();
        //da.Fill(ds2,"billDetailsTwo");
        return;
    }
}

Hi,

Please check whether you have given the user credentials both while designing the crystal report and in the code. it should work. The logon credentials which you give in the wizards should also match the logon credentials in your code.

Source from http://forums.asp.net/t/1206308.aspx

And you can also refer here about dynamic logon in crystal reports:

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-dynamic-login.htm

Hope it can help you.

[RESOLVED]barcode on ReportViewer WEB

September 13, 2014ReportViewer, View, Web FormsReportViewer, View, Web Formsadmin

Using VS2010, aspnet4, c#

Does anyone know tutorial about printing barcode ReportViewer application Web

Hi,

To achieve this, we should first download a free barcode font. Try using "IDAutomationHC39M" from IdAutomation. And for more detailed information, you can refer the sample:

http://www.codeproject.com/Articles/30322/Barcodes-in-ASP-NET-applications

And please refer the similar thread

http://social.msdn.microsoft.com/Forums/vstudio/en-US/f2c3e9b2-506d-4660-a7bb-123addf5fa86/how-to-use-idautomationhc39m

Hope it can help you.

ASP.NET ReportViewer controll excel export bad cell background

September 13, 2014PDF, ReportViewer, View, Web FormsPDF, ReportViewer, View, Web Formsadmin

I have a problem with the asp.net webforms reportviewer controll. When I export from this control to excel, the xls cells background colors goes wrong. All cells background color inherits the last cell background color.

The pdf and .doc export working well.

I’m using this exp. in the .rdlc file for coloring the cells: =IIF(Fields!State.Value = 0, "#FFFFFF", IIF(Fields!State.Value = 1, "#00FF00", IIF(Fields!State.Value = 2, "#FFFF00", IIF(Fields!State.Value = 3, "#FF0000", "#808080"))))

I hope somebody can help me.

Bye!

ps.: Sorry my english.

Hi,

try using Switch instead of IFF. Also, try giving the value in Color name like: Red instead of #FF0000

=Switch(Fields!State.Value = 0, "#FFFFFF",
Fields!State.Value = 1, "#00FF00",
Fields!State.Value = 2, "#FFFF00",
Fields!State.Value = 3, "#FF0000",
"#808080")

Source from http://stackoverflow.com/questions/17718176/asp-net-reportviewer-controll-excel-export-bad-cell-background

And you also try using “case when..then ..else..” expression like this:

SELECT
 Customers.CustomerID
 , Customers.CompanyName
 , Customers.Country
 , CASE Country
    WHEN 'Germany'
     THEN '0049 ' + Phone
    WHEN 'Mexico'
     THEN 'Fiesta ' + Phone
    WHEN 'UK'
     THEN 'Black Pudding (Yuk!) ' + Phone
     ELSE Phone
     END AS Phone
FROM
 Customers

For more detailed information, you can refer here

http://www.sql-server-performance.com/2006/iif-tsql/

Thanks for the tip, but it is not working.

[RESOLVED]Problem in deleting multiple data in gridview through checkbox

September 13, 2014AJAX, CheckBox, GridView, Image, ImageButton, Label, LinkButton, Linq, Login, Menu, Paging, Post, ReportViewer, ScriptManager, Table, TextBox, View, Web Forms, XmlAJAX, CheckBox, GridView, Image, ImageButton, Label, LinkButton, Linq, Login, Menu, Paging, Post, ReportViewer, ScriptManager, Table, TextBox, View, Web Forms, Xmladmin

Hi all,

whenever i use to delete multiple data it deletes only 1 data,not multiple ? plz help

Inline Code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Gridview.aspx.cs" Inherits="Gridview" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Institute|View Data</title>
<link href="css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.style1 {color: #FF8400}
.border
{
width: 102%;
}
.style2
{
width: 67%;
}
.style3
{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #78818B;
padding-right: 15px;
text-align: justify;
height: 32px;
}
.style4
{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #78818B;
padding-right: 15px;
text-align: justify;

}
</style>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="border1">
<tr>
<td valign="top"><table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="362" valign="top" style="background-image:url(images/index_02.gif);"
class="style7"><div style="padding-top:20px; padding-left:40px;"><a href="#"><img src="images/index_07.gif" alt="" width="247" height="31" border="0" /></a></div></td>
<td width="137" valign="top" style="background-image:url(images/index_02.gif);"
class="style7"><img src="images/index_04.gif" width="137" height="85" alt="" /></td>
<td width="281" valign="middle"
style="background-image:url(images/index_02.gif);" class="style7">
<table width="100%" border="0" align="right" cellpadding="0" cellspacing="3">
<tr>
<td width="35%" style="color:#FF6600; font-weight:bold;">Site Search</td>
<td width="54%"><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:TextBoxWatermarkExtender ID="TextBox1_TextBoxWatermarkExtender"
runat="server" Enabled="True" TargetControlID="TextBox1"
WatermarkText="Enter Your Query Here" SkinID="style3"
WatermarkCssClass="style4">
</asp:TextBoxWatermarkExtender>
</td>
<td width="11%">
<asp:ImageButton ID="ImageButton1" runat="server"
ImageUrl="~/images/index_10.gif" CausesValidation="False" /></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="362" valign="top"><img src="images/index_14.gif" width="362" height="177" alt="" /></td>
<td width="137" valign="top"><img src="images/index_15.gif" width="137" height="177" alt="" /></td>
<td width="281" valign="top"><img src="images/index_16.gif" width="281" height="177" alt="" /></td>
</tr>
<tr>
<td colspan="3" valign="top"><table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="213" height="31" style="background-image:url(images/index_17.gif); font-weight:bold; color:#FFFF00; padding-left:9px;">News Updates!<br />
——————————</td>
<td width="567" height="31" bgcolor="#78818B"><table width="567" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="60" class="menu"><a href="Home.aspx">Home</a></td>
<td width="8"><img src="images/index_21.gif" width="8" height="31" alt="" /></td>
<td width="84" class="menu"><a href="About Us.aspx">About Us</a></td>
<td width="8"><img src="images/index_21.gif" width="8" height="31" alt="" /></td>
<td width="92" class="menu"><a href="Studentinfo.aspx">Student</a></td>
<td width="8"><img src="images/index_21.gif" width="8" height="31" alt="" /></td>
<td width="90" class="menu"><a href="Faculty.aspx">Faculty</a></td>
<td width="10"><img src="images/index_21.gif" width="8" height="31" alt="" /></td>
<td width="110" class="menu"><a href="Login.aspx">Login</a></td>
<td width="9"><img src="images/index_21.gif" width="8" height="31" alt="" /></td>
<td width="90" class="menu"><a href="Contact.aspx">Contact Us</a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="212" valign="top"><table width="211" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="190" valign="top" bgcolor="#78818B" class="border"><div class="news" style="padding-bottom:5px; padding-top:5px; padding-left:7px;">News & Events</div>
<div class="nbody"><a><marquee direction="up" scrollamount="2"><strong>03/05/06</strong><br />
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nullam quis turpis.<br /></marquee></a>

</div>
<div class="nbody"><a><marquee direction="up" scrollamount="2"><strong>03/05/06</strong><br />
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nullam quis turpis.</marquee></a>
<br />
</div>
</td>
</tr>
<tr>
<td height="6"></td>
</tr>
<tr>
<td><a href="#"><img src="images/index_34.gif" alt="" width="211" height="106" border="0" /></a></td>
</tr>
<tr>
<td height="6"></td>
</tr>
<tr>
<td><a href="#"><img src="images/index_37.gif" alt="" width="211" height="138" border="0" /></a></td>
</tr>
<tr>
<td height="8"></td>
</tr>
</table></td>
<td width="568" valign="top" style="padding-top:12px;">
<table
border="0" align="center" cellpadding="0" cellspacing="0"
style="margin-right: 0px; width: 104%;">
<tr>
<td valign="top" class="body">
<table border="0" align="center" cellpadding="2" cellspacing="4" class="border">
<tr>
<td height="35" valign="top" class="heading"
style="padding-top:8px; color:#0066FF;">
<strong>View Your Data Here:</strong>
<asp:Label ID="Label1" runat="server" ForeColor="Red"></asp:Label></td>
</tr>
<tr>
<td width="36%" class="body1">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="#CCFFFF" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px"
CellPadding="4" GridLines="Horizontal" Width="214px" AllowPaging="True"
DataKeyNames="Name" ForeColor="#0099FF"
onpageindexchanging="GridView1_PageIndexChanging"
onrowdeleting="GridView1_RowDeleting" PageIndex="8">
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Address" HeaderText="Address"
SortExpression="Address" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="Country" HeaderText="Country"
SortExpression="Country" />
<asp:BoundField DataField="PhoneNo" HeaderText="PhoneNo"
SortExpression="PhoneNo" />
<asp:BoundField DataField="Emailid" HeaderText="Emailid"
SortExpression="Emailid" />
<asp:BoundField DataField="Comments" HeaderText="Comments"
SortExpression="Comments" />
<asp:CommandField HeaderText="Delete" ShowDeleteButton="True" />
<asp:TemplateField HeaderText="Delete">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="White" ForeColor="#333333" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
<PagerSettings Mode="NumericFirstLast" />
<PagerStyle BackColor="#99FF66" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="White" ForeColor="#333333" />
<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F7F7F7" />
<SortedAscendingHeaderStyle BackColor="#487575" />
<SortedDescendingCellStyle BackColor="#E5E5E5" />
<SortedDescendingHeaderStyle BackColor="#275353" />
</asp:GridView>
<br />
<br />
<asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">Select All</asp:LinkButton>
  
<asp:LinkButton ID="LinkButton2" runat="server" onclick="LinkButton2_Click">Delete</asp:LinkButton>
<br />
<br />
</td>
</tr>
</table>

</td>
</tr>
</table></td>
</tr>

</table></td>
</tr>
<tr>
<td height="94" valign="top" style="background-image:url(images/index_44.gif);"><pre class="footer"><a href="Home.aspx">Home</a> :: <a href="About Us.aspx">About Us</a> :: <a href="Studentinfo.aspx">Student</a> :: <a href="Faculty.aspx">Faculty</a> :: <a href="Login.aspx">Login</a>
:: <a href="contact.aspx">Contact Us</a>
<span class="style1">Copyright© 2006 companyname.com, All rights Reserved</span></pre></td>
</tr>
</table>
</div>
</form>
</body>
</html>

Code Behind:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class Gridview : System.Web.UI.Page
{
void loaduser()
{
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("Select * from ContactTable", con);
DataSet ds = new DataSet();
adp.Fill(ds);

GridView1.DataSource = ds;
GridView1.DataBind();

}
SqlConnection con = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\hp\Documents\Visual Studio 2010\WebSites\Institutemgmtsystm\App_Data\Database.mdf;Integrated Security=True;User Instance=True";
if (!Page.IsPostBack)
{
loaduser();

}
}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
loaduser();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;

String name = GridView1.DataKeys[e.RowIndex].Value.ToString();

cmd.CommandText = "Delete from ContactTable where Name=’" + name + "’";
cmd.ExecuteNonQuery();
Label1.Text = "Your data is deleted!!";
con.Close();
loaduser();
}

protected void LinkButton1_Click(object sender, EventArgs e)
{
con.Open();
CheckBox chk;
for (int i = 0; i <= GridView1.Rows.Count – 1; i++)
{
chk = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
chk.Checked = true;

}
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
string strUsername = "", a = "";
CheckBox chk;

for (int i = 0; i <= GridView1.Rows.Count – 1; i++)
{
chk = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (chk.Checked)
{
con.Open();
strUsername = GridView1.DataKeys[i].Value.ToString();

SqlCommand cmdDelete = new SqlCommand();

cmdDelete.Connection = con;

string strDelete = "Delete from ContactTable where Name=’" + strUsername + "’";

cmdDelete.CommandText = strDelete;

cmdDelete.ExecuteNonQuery();

a = a + strUsername;

con.Close();

Label1.Text = "Your records are deleted";
loaduser();
}

}
}
}

One thing you should fix is the security whole that you’ve created called a SQL inject – don’t manually put your sql strings together like this:

string strDelete = "Delete from ContactTable where Name='" + strUsername + "'";

You should put them together using something called parameterised queries:

http://msdn.microsoft.com/en-us/library/yy6y35y8.aspx

<div>So the code should look more like this:</div>
<div>

    strUsername = GridView1.DataKeys[i].Value.ToString();
    string commandText = "Delete from ContactTable where Name = @username";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(commandText, connection);
        command.Parameters.Add("@username", SqlDbType.String);
        command.Parameters["@username"].Value = strUsername;

        try
        {
            connection.Open();
            Int32 rowsAffected = command.ExecuteNonQuery();
            //Console.WriteLine("RowsAffected: {0}", rowsAffected);
        }
        catch (Exception ex)
        {
            //Console.WriteLine(ex.Message);
        }
    }

(adapted from http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx)</div>

I also noticed that you are loading the whole table in with a loaduser() call every loop which doens’t seem right.

I’ve looked over the rest of the code and to be honest it doesn’t seem like it has a problem. I would suggest setting a breakpoint and stepping through the code. My guess would be that its something going wrong with the database code and its failing in the
background.

Move loaduser(); to outside the loop, place it after all already deleted.

[RESOLVED]Getting Error Sys.WebForms.PageRequestManagerTimeoutException; The server request timed out.

September 13, 2014AJAX, Post, ReportViewer, ScriptManager, View, Web FormsAJAX, Post, ReportViewer, ScriptManager, View, Web Formsadmin

Hello All ,

I am using Ajax Extension 1.0, I am getting this error Sys.WebForms.PageRequestManagerTimeoutException; The server request timed out.

Also it is taking too long time to retrive 150 records to my webpage

Please help me.

To solve this problem we can increase the timeout. You can change the timeout time by adding a new property to the script manager control. This property is calledAsyncPostBackTimeOutand
it can help us to define the number of seconds before the request will throw a request timeout exception*.

For example if you want that the timeout will take maximum 10 minutes your code should be look like this:

<asp:ScriptManagerID="ScriptManager1"runat="server"

AsyncPostBackTimeOut="600">

</asp:ScriptManager>

The default value of theAsyncPostBackTimeOut property is 90 seconds.

http://blogs.msdn.com/b/selvar/archive/2012/06/18/reportviewer-2010-control-fails-with-sys-webforms-pagerequestmanagertimeoutexception-the-server-request-timed-out.aspx

Using business objects as data source for MS Report rdlcs with WAPs

September 13, 2014App_Code, ObjectDataSource, Post, ReportViewer, Table, View, Web FormsApp_Code, ObjectDataSource, Post, ReportViewer, Table, View, Web Formsadmin

Since there is no App_Code directory, I am unable to get my generics class to appear in the datasources for an rdlc that I create in my WAP project.

I think there might be some limitation where we cannot use generics business objects as the datasource or reports since the WAP has no App_Code folder where the class must normally reside for the reporting datasources to pick it up as a datasource.

Any thoughts? This will prevent my company from moving to 2005!

Here is what someone else used to work around the problem:

<div class=MsoNormal> Drop an ObjectDataSource on the form with the ReportViewer.</div>
<div class=MsoNormal>Configure the ODS to use the TableAdapter associated with the source DataSet.</div>
<div class=MsoNormal>In the Misc->LocalReport properties for the ReportViewer, select DataSources and click the ellipsis.</div>
<div class=MsoNormal>In the ReportDataSource Collection Editor, click the Add button.</div>
<div class=MsoNormal>In the properties for the new ReportDataSource, specify <DataSet>_<table> as the value for the Name property and the ID of the ODS as the value for the DataSourceId property.</div>

This results in the following ObjectDataSource tag:

<asp:ObjectDataSource
ID="ObjectDataSource1"
runat="server"
OldValuesParameterFormatString="original_{0}"

SelectMethod="GetData"
TypeName="ReportViewerCrash.DataSet1TableAdapters.databasesTableAdapter">
</asp:ObjectDataSource>

And the following ReportViewer tag:

<rsweb:ReportViewer
ID="ReportViewer1"
runat="server"
Font-Names="Verdana"
Font-Size="8pt" Height="400px"
Width="400px">

<LocalReport ReportEmbeddedResource="ReportViewerCrash.Report1.rdlc"
ReportPath="Report1.rdlc">

<DataSources>

<rsweb:ReportDataSource
DataSourceId="ObjectDataSource1"
Name="DataSet1_databases"
/>

</DataSources>

</LocalReport>

</rsweb:ReportViewer>

Hope this helps,

Brad.

The problem with this is you are creating a business object datasource from a dataset.

My approach is using a class that returns a generics class of my class type. This normally is autodetected once compiled in a web site’s App_Code folder when you open an rdlc and look at the website datasource window.

It was confirmed that this is a bug with WAP’s that cannot be addressed until SP1. The bug is the WebsiteDatasource window does not appear or update with the WAP generics classes. I was told they are trying to find a workaround and will keep me posted.

I am correct in saying you are creating a dataset to bind to correct? This is not going to work for the generics report object datasource approach right?

Greg

Hi Greg,

Were you able to resolve this issue? I am also having the same issue. I have a ASP.net Web application (and not a web site) and I want my classes as the data source for the report, but the classes do not show up in the data source window. I need to have
a report and bind to my business objects..

Your response really appreciated.

Report Designer Issues?

September 13, 2014ObjectDataSource, ReportViewer, View, Web FormsObjectDataSource, ReportViewer, View, Web Formsadmin

I rebuilt my computer and installed the VWD2008 instead of the VWD2005. I upgraded as the report viewer functions for 2008 were finally released. I pulled in a project build under 2005 and let it do it’s upgrading. Now I have issues with the report viewer
functions. I get an error in the developement control ie

Error Creating Control-ReportViewer1

Failed to created public designer ‘Microsoft.Reporting.Webforms.ReportViewer.Webforms, Version 8.0.0.0, Culture=neutral, PubicKey Token=b03f5f7f11d50a3a’

Looking at my web.config file I find two references to Microsoft.ReportViewer. A version 8.0.0.0 and a 9.0.0.0. Do I have a version error which wasn’t corrected in the upgrade?

When I created a new report viewer it tells me

Error Creating Control-ReportViewer1

The server Tag ‘rsweb.ReportViewer’ is ambiguous. Please modify the associated registration that is causing the ambiguity and pick a new tag prefix.

Any help?

UPDATE: Looking at the web.config file there are two references to Reportviewer version 8 and version 9. When the upgrade originally runs it does nothing to the web.config file and the program
will run fine and all reports can be run but have an error if tried to edit or view in development. If you build a new report with the new report viewer/builder for vwd2008 you will get two instances in the web.config file but will be able to edit in the development-The
problem comes when compiling-so many errors- It appears the reports developed in vwd2005 cause errors when tring to run it vwd2008. I have changed the web.config to a 2008 version and changed all the reports over to 2008 and I still get errors in the aaplication
code which stops it from running. For now I will have to revert back to 2005 until I can figure this out.

I solved the problem by doing the following.

<div mce_keep="true">I built another website under vwd2008. Build a dataset and report and report viewer.</div>
<div mce_keep="true">I copied the web.config file to a txt.doc</div>
<div mce_keep="true">I opened my site with the problems </div>
- <div mce_keep="true">made a copy of the original web.config </div>
- <div mce_keep="true">Copied and pasted my saved web.config from my txt.doc file location</div>
- <div mce_keep="true">opened and copied my connections from my original web.config and pasted to my new web.config.</div>
- <div mce_keep="true">You then have to go to every report viewer instance and change the reference from 8.0.0.0 to 9.0.0.0 and check your ObjectDataSource for missing parameters ie config the source to make sure its right. You have to fix them all to eliminate
  the errors.</div>
<div mce_keep="true">Now I am happy[Yes] and can get the reports to view that I want without pulling my hair out.</div>

Asp Forum

It is about ASP.NET