|
deepikadurge wrote: I want to create a application in which i can send a mail and receive amail.
You have to create one mail server rather than thinking about using DB.
What is your business requirments ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
I am dng this for my knowledge .. can i create a mail server on my machine and how
|
|
|
|
|
Any sample for refreshing a Saved Crystal Report (saved with data) to latest data from DB?
|
|
|
|
|
Reload the page.
|
|
|
|
|
Disable the notorious "Save data" option in the report properties.
|
|
|
|
|
Hi Abishek and Shameel,
Thanks for your reply.
Actually we have already generated RPT files using Crystal XI. I'm trying to use from VS.NET 2005 to let users quickly refresh with latest data. When I tried to copy the RPT files to the application folder's subfolder named Reports and hardcoded the same foldername and the filename, it gives me Missing parameters while clicking refresh icon of the CrystalReportViewer (as per the attached code). Actually the report has saved parameters in it (I verified from application using reports ParameterField's HasCurrentValue property of each field in the loop).
My intention is to let user to click refresh icon of the embedded CrystalReportViewer to refresh the report (loaded from Reports sub folder as in code) with latest DB data and using the saved parameter values. That's all. As per the below code, It shows "Missing Parameters values" mesg. and the report did not get refreshed. When I commented the this.CrystalReportSource1.ReportDocument.Refresh(); line in ReportDocument_RefreshReport funtion, it shows "The Report Application Server failed" error mesg from the viewer, but the report get overwritten as per my intention. How to avoid this "The Report Application Server failed" error mesg. I don't know what am I missing here. Pls see the assemblies and code as below...
Attaching the code as it is not properly attached in my previous reply ...
=======================
Begin - aspx.cs code
=======================
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.Shared;
using CrystalDecisions.Web;
public partial class _Default : System.Web.UI.Page
{
private ConnectionInfo connectionInfo = new ConnectionInfo();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//ConfigureCrystalReports();
}
}
protected void CrystalReportViewer1_Init(object sender, EventArgs e)
{
ConfigureCrystalReports();
}
private void ConfigureCrystalReports()
{
string reportPath = Server.MapPath(@"Reports\Report1.rpt");
this.CrystalReportSource1.ReportDocument.Load(reportPath);
CrystalReportViewer1.Visible = false;
SetDBLogonForReport(this.CrystalReportSource1.ReportDocument);
foreach (ParameterField field in this.CrystalReportSource1.ReportDocument.ParameterFields)
{
field.HasCurrentValue = true;
}
//this.CrystalReportSource1.ReportDocument.Refresh();
CrystalReportViewer1.ReuseParameterValuesOnRefresh = true;
CrystalReportViewer1.Visible = true;
}
public void ReportDocument_RefreshReport(object sender, EventArgs e)
{
try
{
SetDBLogonForReport(this.CrystalReportSource1.ReportDocument);
CrystalReportViewer1.ReuseParameterValuesOnRefresh = true;
this.CrystalReportSource1.ReportDocument.SetDatabaseLogon("user", "passwd", "server", "");
foreach (ParameterField field in this.CrystalReportSource1.ReportDocument.ParameterFields)
{
field.HasCurrentValue = true;
field.AllowCustomValues = true;
//field.EnableNullValue = true;
}
this.CrystalReportSource1.ReportDocument.Refresh();
this.CrystalReportSource1.ReportDocument.SaveAs(@"C:\Inetpub\wwwroot\XsiteRpt\Reports\Report1.RPT", true);
}
catch (Exception ex)
{
Msg.Text = ex.Message;
}
}
public void SetDBLogonForReport(ReportDocument reportDocument)
{
Tables tables = reportDocument.Database.Tables;
connectionInfo.ServerName = "server"; //ConfigurationManager.AppSettings["DBServer"];
connectionInfo.UserID = "user"; //ConfigurationManager.AppSettings["DBUser"];
connectionInfo.Password = "passwd"; //XsiteWinRpt.ConnUtil.GetOnlyPasswordOfConnString(); //ConfigurationManager.AppSettings["DBPassword"];
foreach (CrystalDecisions.CrystalReports.Engine.Table table in reportDocument tables)
{
TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
table.ApplyLogOnInfo(tableLogonInfo);
}
}
}
=======================
End - aspx.cs.code
=======================
=======================
Begin - Assemblies
=======================
<assemblies>
<add assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/><add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
</assemblies>
=======================
End - Assemblies
=======================
=======================
Begin - aspx
=======================
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Xsite.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.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">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Refresh Report</title>
<link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css"
rel="stylesheet" type="text/css" />
<link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css"
rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Panel ID="PanelMsg" runat="server">
<br />
<asp:Label ID="Msg" runat="server" Font-Bold="False" Font-Names="Verdana" ForeColor="Navy"></asp:Label>
<br />
</asp:Panel>
<asp:Panel ID="PanelViewer" runat="server">
<CR:CrystalReportViewer ID="CrystalReportViewer1" OnReportRefresh="ReportDocument_RefreshReport" runat="server" AutoDataBind="True"
EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False" ReuseParameterValuesOnRefresh="True" HasRefreshButton="True" Height="820px" OnInit="CrystalReportViewer1_Init" ReportSourceID="CrystalReportSource1" ShowAllPageIds="True" Width="1215px" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
</CR:CrystalReportSource>
</asp:Panel>
</div>
</form>
</body>
</html>
=======================
End - aspx
=======================
|
|
|
|
|
Hi Abishek and Shameel,
Actually the RPT files are already saved with old data. I need to refresh only.
Thanks.
|
|
|
|
|
then what is the problem. Just use location.href or location.replace .
Better check out this :
http://grizzlyweb.com/webmaster/javascripts/refresh.asp
Hoping this helps you.
Cheers.
|
|
|
|
|
Abhishek,
I'm getting "The Report Application server failed" mesg.
That's issue while refreshing the report.
Thanks.
|
|
|
|
|
Is it a client side error. This might be a problem of not requesting the child pages from the browser.
|
|
|
|
|
I am using interop for creating excel ..
i ve cretaed the excel file.
Now i need to hide or delete some of the columns....
Can u plz tell me the code for that...
Thanks in Regardss....
|
|
|
|
|
Instead of creating Excel u can create XML and that xml u can open with Excel. and jo will easier to add and delete from Excel
Thanks,
Amit
|
|
|
|
|
Besides the XML there is a c# excel component Spire.XLS,it can creating Excel .
|
|
|
|
|
Do some experimentation yourself. Although I am not an expert in Excel Automation, I remember something like Worksheets[0].Columns collection.
|
|
|
|
|
Thanks for the Reply.....
I have found the solution....
for hiding first column
Excel.Range rangen2 = oSheet.get_Range(oSheet.Cells[5, 4]);
rangen2.EntireColumn.Hidden = true;
|
|
|
|
|
How are you using Excel with ASP.NET ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanks for the Reply.....
I have found the solution....
for hiding first column
Excel.Range rangen2 = oSheet.get_Range(oSheet.Cells[5, 4]);
rangen2.EntireColumn.Hidden = true;
|
|
|
|
|
Hello,
I am using :Net 3.5, ît has CSS2.1 validator, how can I migrate it to CSS3.0?
modified on Thursday, November 12, 2009 6:03 AM
|
|
|
|
|
Retrieving the COM class factory for the component with CLSID due to following error and error is 80070005
|
|
|
|
|
Check if Crystal Report is installed in Server properly.
|
|
|
|
|
in server framework is present but crystal report is not present i think there is some issue of version
|
|
|
|
|
You need to install crystal report component to the server as well to use it. I think the component you are asking for is not registered....
The component generally installs with Framework.
|
|
|
|
|
how to create a remote desktop using asp.net??
urgently!!!
Thank you...
and do you have any tutorial for build it??
i will wait for the answer...
|
|
|
|
|
Hey... This is very easy. I think there is a component for this.
Use Microsoft Terminal Services Type
If you add this to your form, you might use UserName, Password to open Terminal.
|
|
|
|
|
ok, thank you friend...
but, i want to create remote desktop software using asp.net C# language...
do you anything source code or the software made by used asp.net C#??
|
|
|
|