|
SQL Server Reporting Services - really pretty decent as these things go.
|
|
|
|
|
Go for MS Reporting services. If you already have licensed MS SQL Server, then it is ideal, because reporting services are part of ms sql server. What I like the most on Reporting services reports is that they are stored in RDL (report definition language) what is open xml format, so you can do with your report programmaticaly whatever you want. ReportViewer control (it is part of VS 2005, or is free to download from microsoft) supports several output formats, from ones you stated are not suported word formats. But you always can write your own rendering extension for reporting services, as format is open and extensions are easy to integrate.
Another option could be Crystal reports, but I'm not so happy with it. I deffinitely prefer reporting services.
Pilo
|
|
|
|
|
Hello Everyone,
I am working on this project, and I was wondering if there is a way to get the site address from a page. Lets say we are at www.codeproject.com, is there a way to get codeproject from URL so we know what site address we are at?
Sincerely,
The Major Rager
|
|
|
|
|
|
|
Try this code line.
Request.PhysicalApplicationPath, it return the physical address, but its something..
keep Learning and you never will be out of date...
|
|
|
|
|
How to get the Current Display Setting and apply for a form?
Thanks.
K.Alex
|
|
|
|
|
Mr. Alex,
you can use the following javascript code to get the display settings of screen
alert("Width:" + window.screen.width + ";Height:" + window.screen.height)
|
|
|
|
|
hi friends,
i am developing an application using aspnet 2005 i need to open the command window from the web page and execute some file from the command window and close the command window how can i do this in my web application i am trying something with process.start("cmd.exe")
but till now i didnt get any solution can anybody help me
jabbarsb
|
|
|
|
|
You mean to run cmd.exe on client side? You can not do this, unless client install ActiveX or similar component. If you could, it would be serious security hole and it should be reported to browser vendor to be patched
Pilo
|
|
|
|
|
Process.Start("cmd.exe","path_to_batch_file")
|
|
|
|
|
Please your help,
I using Vs.Net 2005 and the ASP.Net 2.0. My problem be with the GRIDview and the SQLDataSource.
My Dataview work as planned and can update / delete perfect when all columns are visible in the GRIDView. However big problem is made when i make one of columns to Invisible. This column data is not found and so database update not work and cause error.
Anyone can help me please.
Most greatfull marconi!
-- modified at 10:51 Wednesday 22nd November, 2006
|
|
|
|
|
I don't know if that's yoyr problem, as you didn't write any code here, but it could be because data of hidden columns are not stored in viewstate, so they are not available after postback. Small trick is to make column invisible after you databind data:
myGridViewColumn.Visible = true;
myGridView.DataBind();
myGridViewColumn.Visible = false;
Try it, maybe that solves your problem.
Pilo
|
|
|
|
|
Hello,
I am using the wizard to make the SqlDataSource and Gridview.
When i make update all is working fine when all columns are visible. But when i hide 1 or more of the column, i get error because it not find the data in this column. So cannot add this data to database.
Any help how to do?
-- modified at 10:52 Wednesday 22nd November, 2006
|
|
|
|
|
I alredy wrote you possible reason of your problem... Anyway, why do you want to store data to GirdView, if they are not displayed? If they are IDs, then use GridView.DataKeys to store IDs. Search for it on MSDN if you want to know how to use it properly.
Pilo
|
|
|
|
|
Ok, maybe you not understand problem i try to describe.
I display the data / informations in GridView via SqlDataSource. But one column must be hidden so not show this data. But if column is hidden then cannot update database because the hidden field column is not added to update statement, and my database say this field must not be empty, so DB wont accept update.
Problem is not because of DataKey but because data is missing when try to add to database. So how to make data collected from hidden column to SqlDataSource Update statement?
Thank, helps is appreciated much.
|
|
|
|
|
I understand your problem. You probably don't understand what I'm trying to tell you
This hidden column WILL be empty, unless you fill it again after postback, or make it visible BEFORE DataBind() is called. Data stored in hidden column are not stored in ViewState, so after postback, this column will be empy - application has no way how to refresh this data automaticaly. But if it is hidden, it means data are not going to be changed anyway so why do you want to update them back into database??? Exclude this column from your data source and you solve your problem. One reason I see why you could want to have this column is to store ID of row into it. But for storing IDs in .NET 2.0 you should use DataKeys property of GridView instead of hidden column. I think some 'smart' head in Microsoft decided that hidden columns should not contain any data (security and performance reason probably). Thats why they introduced DataKeys property.
Try to answer to following question and then I could be able to help you better: why do you need to have this column in your GridView? If you dont need it, just change your select and update statements and exclude it. If you need it, than you have to think up a workaround, similar as I posted you in my first post.
Pilo
|
|
|
|
|
Thanks you,
I am greatful for your answer. Your idea to remove is very good. I will do this. Is simple but overlooked way! )
But also was trying to learn proper way not just a workaround. I have one question finally. If use wizards to create DataView how do access / call columns of dataview to make invisible / hidden?
|
|
|
|
|
This problem is with GRIDVIEW not DataView sorry!
|
|
|
|
|
1) hi, i recently install vs studio 2003. i created asp.net and when i try to run, it gives me this msg "unable to start debugging on the web server. debugging failed because integrated windows authentication is not enable"..
2) When i wanna test my localhost, i type localhost in internet explorer, it prompt me for my username and password. why is this so?
|
|
|
|
|
go to Control panels -> Administrative tools -> Internet information services, and browse to your application folder. right click it -> properties -> directory security tab -> click the upper edit button -> ensure yourself that only checkbox checked is 'integrated windows authentication'
Does it solve your problem?
Pilo
|
|
|
|
|
thanks but it still doesnt work. it still prompt me for user name n password. n it says that "You are not authorized to view this page" "You do not have permission to view this directory or page using the credentials you supplied."
i follow ur instruction, i realise that under directory tab, the location path is just "\project". it is suppose to be "\localhost\project" rite?
-- modified at 9:44 Thursday 23rd November, 2006
|
|
|
|
|
I'm using my laptop now and I don't have IIS installed here. I don't know if I mean the same what you mean, but I think location should be complete pysical path to your directory: c:\inetpub\wwwroot\project\
Pilo
|
|
|
|
|
I have some scenario of option button.. suppose
Gender
Male /Female
if User select Male then one textbox to validate and if user select female then nothing to validate.but in my case it is running no matter which option button is selected. Can any one help me how to make the code for this condition.
The Control should run on server side validation. I dont know how to get the solution of this.. Any Idea's ????
|
|
|
|
|
Is posssible to set ValidationControl disabled.
So make condition statement like
<code>
if(some condition)
{
Control.Enabled=false;
}
else
{
control.Enabled=true;
}
</code>
|
|
|
|