|
I encountered a crystal report deployment problem.
I make reports with Crystal Report for Visual Studio .NET 2008. It works fine in the development machine (windows xp). And then I deployed it on a windows server 2003 system (with .net framework 3.5), the report gives error about "Logon Failed".
Other than the crystal report part, the web application accesses the sql server database via asp.net, and it works well.
If I restarted the machine, it works ok. And if installed on a windows xp with .net framwork 3.5, it works ok too.
Any help or hints are appreciated.
Thanks!
Arun
|
|
|
|
|
It would be easiest to set your Sql login details in your webconfig file.
<appSettings>
<add key="CrystalImageCleaner-AutoStart" value="true" />
<add key="CrystalImageCleaner-Sleep" value="60000" />
<add key="CrystalImageCleaner-Age" value="120000" />
<add key="Server" value="Sername" />
<add key="DataBase" value="Company" />
<add key="Userid" value="sa" />
<add key="Password" value="thePassword" />
</appSettings>
Then in your code behind file
string Svr = ConfigurationManager.AppSettings["Server"];
string UserId = ConfigurationManager.AppSettings["Userid"];
string PassWd = ConfigurationManager.AppSettings["Password"];
string DB = ConfigurationManager.AppSettings["DataBase"];
string ReportPath = Server.MapPath("FactoryCopy.rpt");
crReportDocument.Load(ReportPath);
crConnectionInfo.ServerName = Svr;
crConnectionInfo.DatabaseName = DB;
crConnectionInfo.UserID = UserId;
crConnectionInfo.Password = PassWd;
crDatabase = crReportDocument.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
|
|
|
|
|
The error occurred while exporting, not in loading data.
|
|
|
|
|
dear all,
how to get a specific word from a sentence considering the blank spaces also (sql query).
kissy
|
|
|
|
|
Hi Kissy,
you could use regular expressions. Do you need a sql query to get the word from the sentence, or can you do this in code?
Regards
Sebastian
|
|
|
|
|
Kissy16 wrote: how to get a specific word from a sentence considering the blank spaces also (sql query).
Does it anything releated to ASP.NET ?
|
|
|
|
|
You can use indexOf() funciton to check whether word exist or not.
Ex: _line = "This is the word to find in sentence";
int k = _line.indexOf("word")
if k = -1, the searching word not found otherwise it is found
G. Satish
|
|
|
|
|
is it possible to change grid view like orkut friend list showing or searching of users communities etc.if yes then pls tell me about the idea and logics examples are very helpful to me if avail.
thanks
|
|
|
|
|
I am new Here，how can I get a free Project about cms
thanks
|
|
|
|
|
Hi,
you have to browse through the articles. Maybe you will find a CMS there.
The intention of the boards is more to ask specific questions like 'My codepiece A throws an exception here, why?'.
Regards
Sebastian
|
|
|
|
|
Well, there are public domain CMSs. Why do you need one ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
hello everybody i have gridview inside updatepnael and two radio buttons to show and hide particular columns of grid view these working properly but edit event not firing my code is as follows...
<asp:updatepanel id="upPayment" runat="server" updatemode="Conditional" xmlns:asp="#unknown">
<contenttemplate>
<asp:radiobutton id="RdBtnShow" runat="server" text="Show" groupname="Edit" width="80px" oncheckedchanged="RdBtnShow_CheckedChanged" autopostback="true">
<asp:radiobutton id="RdBtnHide" runat="server" text="Hide" groupname="Edit" width="80px" autopostback="true" checked="true" oncheckedchanged="RdBtnHide_CheckedChanged">
<asp:gridview id="gvReport" datakeynames="PD_ID" onrowcommand="gvReport_RowCommand">
runat="server" AutoGenerateColumns="false" Width="98%" OnRowEditing="gvReport_RowEditing"
OnRowDeleting="gvReport_RowDeleting" OnRowDataBound="gvReport_RowDataBound">
<columns> <asp:templatefield>
<itemtemplate>
<asp:checkbox id="ChkPayment" runat="server" autopostback="true" oncheckedchanged="chk_CheckedChanged" tooltip="<%#DataBinder.Eval(Container.DataItem," pd_id")="" %>"="">
<asp:templatefield headertext="S.No">
<itemtemplate>
<asp:label id="lblSno" runat="server">
<asp:boundfield headertext="Payment Date" itemstyle-width="80px" datafield="PD_PaymentDate" htmlencode="false" dataformatstring="{0:dd-MM-yyyy}" itemstyle-font-bold="false" visible="false">
<asp:boundfield itemstyle-width="80px" htmlencode="false" dataformatstring="{0:dd-MM-yyyy}">
HeaderText="Date" DataField="PD_ChequeDate">
<asp:boundfield headertext="P-Mode" datafield="PD_ModeofPayment" itemstyle-horizontalalign="Left">
<asp:boundfield headertext="Ch Detail" datafield="PD_ChequeDetail">
<asp:templatefield headertext="Paid Amount" footerstyle-font-bold="True" itemstyle-="" horizontalalign="Center">
<itemtemplate>
<asp:label id="lblPaidAmount" runat="server" cssclass="lbl-Report">
<asp:templatefield headertext="Due Amount" footerstyle-font-bold="True" itemstyle-horizontalalign="Center">
<itemtemplate>
<asp:label id="lblDueAmount" runat="server" cssclass="lbl-Report">
<asp:templatefield headertext="Balance" footerstyle-font-bold="True" itemstyle-horizontalalign="Right">
<itemtemplate>
<asp:label id="lblBalance" runat="server" cssclass="lbl-Report">
<asp:templatefield headertext="Edit" visible="false">
<itemtemplate>
<asp:imagebutton id="btnEdit" runat="server" tooltip="Edit" commandargument="<%# DataBinder.Eval(Container.DataItem," pd_id")="" %>"="" commandname="Edit" imageurl="~/images/edit.gif">
<asp:templatefield headertext="C-Dis" visible="false">
<itemtemplate>
<asp:imagebutton id="btnChequeDisHonour" tooltip="Cheque Dishonour" alternatetext="CD">
ImageUrl="~/images/arr_white.gif" runat="server" CommandArgument='<%# DataBinder.Eval(Container.DataItem,"PD_ID") %>'CommandName="Cdis" />
<asp:imagebutton id="ImgbtnRepresent" runat="server" tooltip="Represent" commandname="Represent">
CommandArgument='<%# DataBinder.Eval(Container.DataItem,"PD_ID") %>' ImageUrl="~/images/round-image.gif" Visible="false" />
<asp:templatefield headertext="Delete" visible="false">
<itemtemplate>
<asp:imagebutton id="btnDelete" tooltip="Delete" alternatetext="Delete" runat="server">
CommandArgument='<%# DataBinder.Eval(Container.DataItem,"PD_ID") %>' ImageUrl="~/images/delete_16x.ico" CommandName="Delete" />
<asp:templatefield headertext="Receipt" visible="false">
<itemtemplate>
<asp:imagebutton id="btnReceipt" tooltip="Receipt" alternatetext="Receipt" runat="server">
CommandArgument='<%# DataBinder.Eval(Container.DataItem,"PD_ID") %>' Width="15" Height="15" ImageUrl="~/images/receipt.jpg" CommandName="Receipt" />
<asp:templatefield headertext="Details">
<itemtemplate>
<asp:label id="lblComment" runat="server">
<asp:boundfield datafield="PD_ID">
|
|
|
|
|
Not Understandable  . Please post properly
|
|
|
|
|
Hi I have a problem that, in my database there are several word file are present in a specific table.
And this word files have their id in the table. My requirement is that in a datagrid i have to show those file as a link in a cell.
mean when i click at that link it will automatically open that attached document file.
Any one can provide the exact code for it should be appreciated.
Regards,
arun
modified on Monday, December 8, 2008 4:38 AM
|
|
|
|
|
way2arun wrote: Any one can provide the exact code for it should be appreciated.
Well, that's actually impossible, even I wanted to do your job for you.
1 - the URL you link to, should contain an id that represents the file in the database
2 - it should open a new page (target="blank")
3 - it should read the file from the database and do a response.binarywrite to send the file, as well as setting the header to say it's a Word file.
4 - obviously this will only work on computers with Word installed
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Thanks Christian, For giving your most valuable time for me. 
Arun Sahoo
|
|
|
|
|
hi i am new in XML data base
and wanna to create a XMl data base
and then how i insert data and fatch data from this file
|
|
|
|
|
XML is not a database format. You can search XML with XPath, tho, and extract nodes. It sounds to me like you need to read some online tutorials or buy some books, what you're asking cannot be easily explained in a forum response, it's too big a question.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
|
XML is a very simple way to store data in a file.For querying and inserting you need to XPath queries.To learn more about it see the link
http://www.w3schools.com/xml/default.asp[^]">
Cheers!!
Brij
|
|
|
|
|
hi
i have one web application in asp.net
after logout if i click on back button of browser . i will inter in my application.
but i want that when i click on back button i will go on logout page.
how it will possible.
it means i want to stop back button.on click of back button my defult form will be display.
thanks
vikram
|
|
|
|
|
By writing a proper membership system ? You should log people out, generally by clearing a session variable. Therefore, if they are logged out, the page should redirect to the login page.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Response.ExpiresAbsolute = DateTime.Now.AddDays(-1D)
Response.Expires = -1500
Response.CacheControl = "no-cache"
If Session("UserName") = "" Then
Response.Redirect("login.aspx")
uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
|
|
|
|
|
Why are you using an empty string and not null ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
hi,
in logout click event you have to write code for killing the session. and in global.asax page you have to redirect the page to login page if the session["username"]="".
Or write below code in page load
Response.Buffer = True
Response.ExpiresAbsolute = Now().Subtract(New TimeSpan(1, 0, 0, 0))
Response.Expires = 0
Response.CacheControl = "no-cache"
Pinna
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
