|
|
How to export crystal report to excel in asp.net 1.0?
Is there any built in functionality to export it in excel.
Thanks in advance,
|
|
|
|
|
Try this On Export Button Click Event:
// Declare variables and get the export options.
ExportOptions exportOpts = new ExportOptions();
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions ();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = orpt.ExportOptions;
// Set the excel format options.
excelFormatOpts.ExcelUseConstantColumnWidth = true;
exportOpts.ExportFormatType = ExportFormatType.Excel;
exportOpts.FormatOptions = excelFormatOpts;
// Set the disk file options and export.
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = fname;
exportOpts.DestinationOptions = diskOpts;
orpt.Export ();
Hope this helps u...
|
|
|
|
|
Hi all,
i want to know that,
How to insert one table records from one database to another table in other database using webservices in vb.net or C#.
ex: databse name: PRS1
table name: sample1
|
|
databse name :PRS2
table name : sample2
|
|
|
|
|
I don't know why you want to use webservice.
But easy way is to use Datatable to store Temporarily data.
This can work if both databases are on same domain.
I use free sqlhepler class to connect with database.
------------------------------------------------------------------------------
string sql="Select user_id,name from user_master";
DataTable dt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionStringfordatabase1, CommandType.Text, sql);
foreach (DataRow dr in dt.Rows)
{
sql = "Inser into user_master (user_id,name) values('" + dr["user_id"] + "','" + dr["name"] + "')";
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringfordatabase2, CommandType.Text, sql);
}
------------------------------------------------------------------------------
Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India
|
|
|
|
|
hi friends
i did chat window.how to connect other systems
can u help me???
|
|
|
|
|
Hey guys i have a little problem to be needed to solve..
I have a accessdatasource and dropdownlist and i binded them to eachother. After i change the selected index on dropdownlist,after postback the selected index wont come as i choose. The first index is coming as a default selected index after every postback...
what should i do to pass over it?
|
|
|
|
|
I hope you have given datasource to dropdown in
----------------------------------
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
dropdown.datasource=dc;
dropdown.databind;
dropdown.datatextfield=dtf;
dropdown.datavaluefield=dvf;
}
}
Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India
|
|
|
|
|
|
I did but the problem is still appearing ... and there is another way besides coding ?
|
|
|
|
|
Thanks it seems gonna work
|
|
|
|
|
|
Paste your code we will check it out and tell.
Regards,
Satips.
|
|
|
|
|
need a guide on how an event in asp.net 2.0 can play .mp3 or other media file
thanks for your help
t.aransiola
|
|
|
|
|
You need to embed windows media player in your web page. There's no ASP.NET code to do this, as ASP.NET all runs on the server. You need to generate HTML that embeds the control in your page, and plays your file. Obviously, you can do it in ASP.NET, but ASP.NET won't be doing it in any platform dependant way.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Is there any way to optimize GIF Image without using GIFBOT or third party??
|
|
|
|
|
What is an optimised GIF ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
You know that it's really bad manners to start a new thread about something that you've posted on recently. If the answer below wasn't satisfactory then you should have continued on that post.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
drm protected file play in wmp11 player, if the individulization set at 2.2, then go for security upgrade, after successfully upgrading security component, go for accuiring license, but play button not enabled, License cannot albe to store on consumer machin.
Thanks
"Success lies not in the result , But in the efforts !!!!!"
Amit Mistry - petlad -Gujarat-India
|
|
|
|
|
Is it right, that the MsgBox() function from asp.net 2.0 cannot be used to show a messageBox in the browser? It only works well on development systems, where server and browser are on the same system? If yes: sorry for my naivity. , )
Plz treat this post seriously.
PS. I know how to display on the browser, but I thought MsgBox() does this functionality for us per hidden script, like viewstate for example.
|
|
|
|
|
wilf57 wrote: MsgBox() function from asp.net 2.0
There is no such thing. MsgBox is a hangover from VB6, in VB.NET, in WinForms. It has nothing to do with ASP.NET.
wilf57 wrote: It only works well on development systems, where server and browser are on the same system?
Correct, because it runs on the server. You can't do stuff like that in C# or VB.NET and have them appear on the client. You need instead to use the alert function, which is a javascript API and thus can run on the client ( so you need to inject javascript into your page, so it appears on the client )
wilf57 wrote: but I thought MsgBox() does this functionality for us per hidden script
No.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
How To Optimize Gif Images ???
|
|
|
|
|
You can use GIFBOT, which will Speed Up Your Pages Without Losing Image Quality!
It is a free Software i used it.
Regards,
Satips.
|
|
|
|
|
what the properties will do timeout & Duration
also How to keep the session always without expiring
Thanks in Advance
-
|
|
|
|
|
How can I get if the File download was successful or not.
I m simply using -
Response.Redirect(url)
The file download dialog box contains Save, Cancel.
How could I know that User clicked Cancel?
Is there any workaround?
I hv also tried
Response.Clear()<br />
Response.AddHeader("Content-Disposition", "attachment; filename=" & file.Name)<br />
Response.AddHeader("Content-Length", file.Length.ToString())<br />
Response.ContentType = "application/octet-stream"<br />
Response.WriteFile(file.FullName)<br />
Response.End 'if file does not exist
But how could i get the Result of Download operation?
"If our Mind can, the Program can !!"
|
|
|
|