|
Dear All,
I am using C# , asp.net(visual studio 2005)
i have generated crystal report using Crystalreportviewer which also show pring and export option Now i want to export data from report to Excel or
Pdf or word How i can i do it. please suggest me some link or example
Thanks
regards
imran khan
|
|
|
|
|
hi
i dont know write english but its is the code
CRPepeletaAA.SetDataSource(dsCapturaTransfer1);
CRVieFormatoAA.ReportSource=CRPepeletaAA;
MemoryStream oStream; // using System.IO
oStream = (MemoryStream)CRPepeletaAA.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(oStream.ToArray());
Response.End();
this part:
CrystalDecisions.Shared.ExportFormatType.PortableDocFormat
and: application/pdf you can change and select the type format that you want
i hope can i help you
sorry but my bad english.
|
|
|
|
|
How to update or delete direct from Grid to Database?I tried my best but fail.Please help me.I have enclosed my code. Please modify
Private Sub Grid_Customer_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Luoi_khach_hang.UpdateCommand
Dim Name1 As TextBox = e.Item.Cells(0).Controls(0)
Dim Name2 As TextBox = e.Item.Cells(1).Controls(0)
Dim Sex As CheckBox = e.Item.FindControl("Phai")
Dim Custom_Code As Integer = Luoi_khach_hang.DataKeys(e.Item.ItemIndex)
Dim SQL As String = "UPDATE khach_hang SET ho_khach_hang='" & Name1.Text & "',ten_khach_hang='" & name2.Text & "',gioi_tinh=" & Sex.Checked & " where mkh=" & Customer_Code
Dim Connect As OleDb.OleDbConnection = Bang_khach_hang.Connect
Connect.Open()
Dim cmd As New OleDb.OleDbCommand(sql, Connect)
Try
cmd.ExecuteNonQuery()
Catch ex As Exception
End Try
Connect.Close()
Grid_Customer.EditItemIndex = -1
Doc_danh_sach_khach_hang()
Lien_ket_du_lieu()
End Sub
|
|
|
|
|
|
I see you use Datareader.But I don't use it.I am using Datatable.Please give code in Datatable.Anyway I would be grateful.Thanks very very very much much much
|
|
|
|
|
I forget that . My application alerts the strange error is that: operation must use an updateable query.
But my query is very exactly
|
|
|
|
|
Struggeling here, suspect isue maybe related to versionof .NET framework installed. How can I determine what version is installed?
|
|
|
|
|
Check folder in C:\WINDOWS\Microsoft.NET\Framework or look in add/remove programs (you can have every version installed on the same machine btw)
|
|
|
|
|
Since you don't say what exactly you are struggling with, you may like to check in IIS also. If you have 1.x and 2.0 installed then an extra tab appears in the properties for your virtual directory which allows you to choose the version of the .NET framework your ASP.NET application will use.
|
|
|
|
|
I am very new to .NEW web, a couple years ago I struggled through making a very simple page that would allow you to hit a SQL database and retrieve some info.
I went to open the project recently and got an error "Unable to get the project file from the Web server. Unable to open Web Project 'IBEReports_2_2005'. The file path "w:\inetpub\wwwroot\IBEReports_2-2005' does not corrospond to the URL 'http://localhost/IBEreports_2-2005' The two need to map to the same server location. HTTP Error 404: Object Not found.
I tried to open the project from my c:\inetpub\wwwroot\IBEReports_2-2005 directory, and also from the server (on the W drive), same issue.
In IIS I have an alias pointing to the C:\Inetpub\wwwroot\IBEReports_2-2005.
So then I backed up a bit anf figured I would just try a blank project and try to get my feet back on the ground from square 1...
I Open Visual Studio .NET 2003, Select "New Project", Select "ASP .NET Web Application", give it a name and receive and error:
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type 'WebApplication1.Global'.
Source Error:
Line 1: <%@ Application Codebehind="Global.asax.vb" Inherits="WebApplication1.Global" %>
I posted a question about this error and was told I needed to build the project, which I did, and I get the dll files in the project \bin directory, but I stil get the same error
Which led me to this whole things about the .NET framework,
It has been so long I do not recall exactly how I set it up and was wondering if my wonderful IT department possibly changed the ,NET framework version, a hint I got from google...
any help is greatly appreciated I am pulling my hair (what is left of it) out at this point...
Oh... and yes, I do see the extra tab...but still have the same problems after installing .NET framework 2.
|
|
|
|
|
Hrmph... think I got it, I completely removed virtual directories, re-booted added themback and seem to havestraigentened everything out...
it works now...
|
|
|
|
|
dear Friends,how can i draw the graph in the asp.net by taking the data from the database.
Plz help me out.
Subbu.
|
|
|
|
|
|
Hi!
i have an iFrame in my asp.net application. i have change the src of the iFrame depending upon the button clicked. i want to pages in the iFrame in the center. How can achieve this???
Thanks & Regards,
SAMir Nigam,
Software Developer,
STPL, Lucknow, India.
|
|
|
|
|
You can do that with Javascript, Just wire a javascript function to an OnClientClick event of your Button.JS function can look like this:
<br />
function SetIFrame()<br />
{ <br />
document.all.Your_IFame_Name.src='www.google.com';<br />
}<br />
|
|
|
|
|
i want to open src page in a center of iFrame. suppose that iFrame is of 300x300 & page is of 100x150. then i want that the page opne in centre of iFrame.
Thanks & Regards,
SAMir Nigam,
Software Developer,
STPL, Lucknow, India.
|
|
|
|
|
You need the page to be set to display like this...
|
|
|
|
|
Use the <center> tag around all the content in the iframe page. (better yet use CSS but its a little bit more complicated to get it to work in every browser)
|
|
|
|
|
Hi,
I am using the below code in my page, to call the Javascript function to open a popup calendar and the Selected Date will be assigned to the TextBox1. It works fine in my page.
<a id="idViewCalendar" href="JavaScript:GetDate('<%= TextBox1.ClientID%>')"><img id="idimg" src="../Images/DateImage.gif" alt="Popup Calendar" border="0" /></a>
But Now, I wish to use this Anchor tag within the EditItemTemplate of the GridView. In that Template, I am having a TextBox and this Anchor Tag.
How can I pass the Client ID of the TextBox to the Popup Calendar Page? If this way is wrong, how can I proceed further? Pls guide me.
Note: If I am using the same code in my GridView, it gives the error like, TextBox1 is not Declared.
function GetDate(txtDateID)
{
window.open("../MyCalendar.aspx?ID="+txtDateID,"popup","location=1,status=1,scrollbars=0,width=260,height=260");
}
(It is a repost. B'cos,I didnt get the solution yet)
Regards,
Jay
|
|
|
|
|
Paste your HTML page and code snippet..I have a solution for this
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
<asp:TemplateField HeaderText="Review Date" SortExpression=""review_date","{0:d}""><br />
<EditItemTemplate><br />
<asp:TextBox ID="review_date" runat="server" Text='<%# Bind("review_date","{0:d}") %> '></asp:TextBox> <br />
<br><br />
</EditItemTemplate><br />
<ItemTemplate><br />
<asp:TextBox ID="review_date" runat="server" Text='<%# Bind("review_date","{0:d}")%>'></asp:TextBox><br />
<a id="idViewCalendar" href="JavaScript:GetDate('review_date')">Regards,<br />
<br />
Jay :)
|
|
|
|
|
change the anchor tag as runat=server
======================================
<asp:TemplateColumn>
<ItemTemplate>
<asp:TextBox ID="review_date" runat="server"></asp:TextBox>
<a id="idViewCalendar" runat="server"><img id="idimg" src="../Images/DateImage.gif" alt="Popup Calendar" border="0"></a>
</ItemTemplate>
</asp:TemplateColumn>
add thsi in ItemDataBound
========================
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
HtmlAnchor anc = (HtmlAnchor)e.Item.FindControl("idViewCalendar");
TextBox txt = (TextBox)e.Item.FindControl("review_date");
anc.HRef = "JavaScript:GetDate('" + txt.ClientID + "')";
}
}
Hope this will solve your problem
Revert back
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi,
Great Mr.Sylvester. It works fine. Eventhough I know the Event RowDataBound in GridView control, due to lack of experience, I felt some problem implementing this.
Great. Thanks.
Regards,
Jay
|
|
|
|
|
Hi there,
I'm relatively inexperienced with ASP.NET, but have been using C# for a number of years now, so have a good grasp on the .NET framework
However, working for a small software developer means that we don't always have the time to dedicate the creation of complex web apps from scratch. So I did a bit of research and found Iron Speed Designer.
It seems to good to be true, automatically generating all that code for you! So I'm after comments from people who have used it - is it really all that it's cracked up to be?
Also, if anyone has experience of other code generators, I'd be interested in hearing from you too
Many thanks in advance
Baz
|
|
|
|
|