|
I need help to develop one small website in asp.net using C#.
Scenario is that I have one folder say Export ( in which xls and xml zip files are generated by another program).
I have to program one page website which shud be able to display only the list of xls files in that folder and user should be able to view the xls file by clicking it.
Thanks in advance.
|
|
|
|
|
First tip is to no cross post here. Second tip is to at least try something first, then ask questions when you get stuck or don't understand.
only two letters away from being an asset
|
|
|
|
|
har dh wrote: I have to program one page website which shud be able to display only the list of xls files in that folder and user should be able to view the xls file by clicking it.
Well, this is a very basic scenario to program. I am not gonna give you the code but a pointer to it.
You basically need to list the files in that folder and apply a filter for the xsl files.
Have a look here[^]
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
This[^] has the answer to your question.
Christian Graus
Driven to the arms of OSX by Vista.
Please read this[ ^] if you don't like the answer I gave to your question.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
|
|
|
|
|
No one can create website for you. Use basic FileInfo object to get xls files and then show to webpage using listview or any control you want.
Try it yourself. 
|
|
|
|
|
Originally, I declared to use mdb for uploading files like the following codes before changing.
//connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+
// MapPath("Files.mdb");
I declared like this for using to upload files to MSSQL :
connString = "Provider=SQLOLEDB;Data Source = db.incheonlaw.ac.kr; Initial Catalog=stanlee;User ID=stanlee;Password=stan;";
After changing codes, there is an error, Must declare the variable "@Writing_Num". when debuging this part, "cmd.ExecuteNonQuery();"........
using (OleDbConnection con = new OleDbConnection(ConnectionString))
using (OleDbCommand cmd = new OleDbCommand(CmdText, con))
{
OleDbParameterCollection pms = cmd.Parameters;
pms.Add("@Writing_Num", OleDbType.VarChar, 50);
pms.Add("@FileName", OleDbType.VarChar, 200);
pms.Add("@FileSize", OleDbType.Integer);
pms.Add("@ContentType", OleDbType.VarChar, 50);
pms.Add("@FileData", OleDbType.VarBinary);
pms["@Writing_Num"].Value = writing_num;
pms["@FileName"].Value = fileName;
pms["@FileSize"].Value = fileLength;
pms["@ContentType"].Value = contentType;
pms["@FileData"].Value = fileData;
pms = null;
con.Open();
cmd.ExecuteNonQuery();
}
How can I properly use mssql???
Is there something wrong??
|
|
|
|
|
OLEDB is deprecated you should probably use ODBC to connect if you can (and you can) but more to the point your parameter Writing_Num probably doesn't exist in your command, which you did not provide.
|
|
|
|
|
I have configured oracle data reader by following code
myReader = myCMD.Parameters("io_cursor").Value
and checked the following code:
Dim x, count As Integer
count = 0
Do While myReader.Read()
For x = 0 To myReader.FieldCount - 1
Console.Write(myReader(x) & " ")
Next
Console.WriteLine()
count += 1
Loop
working fine.
Can i assign this myReader (Oracle Data Reader) as a dataset or report source to Crystal report viewer.
Since there are million of rows in the oracle table, and i came to know that oracle data reader is much faster then any other ways. So now, how do i assign this data reader to crystal report viewer in web application.
Thanks & Regards
Girish Sharma
|
|
|
|
|
1) I've only used datasets with Crystal Viewer
2) I can't believe you would be generating a report that would be viewed by a web page that would contain millions of records. So I'm skeptical on that point. 
Here is my basic framework for generating a report:
1) create your SQL statement for the report
2) create a SQLDataAdapter with this sql command
3) fill a dataset from the data adapter
4) load the crystal report
5) assign the report.setdatasource to the dataset you generated
6) assign the crystalreportviewer.reportsource to your report
Done !
I've left out lots of details, but you should get the idea ...
|
|
|
|
|
If you have a databinder then you can automatically create a dataset with the reader.
However, creating a data set with a data reader will never be faster than using the data reader alone. A data reader is a fast-forward, read only schema blind cursor (Ok, oracle supports cursor definitios) and is the absolute fastest possible way to retrieve non-bulk data from a database.
BTW, Console.WriteLine is slow.
One last thing, with Crystal you should be able to bind to a stored procedure to take advantage of the cursor and not require a dataset. Give it a shot.
|
|
|
|
|
First let me thanks to both of you for providing me the solution.
Actually, i do'nt know how do i assign Oracle data reader as dataset / datasource to crystal report viewer; even is it possible or not, i am not aware of it. I have somewhere read that it is the best way to write the stored procedure to fetch the rows and then call that stored procedure by data reader. This is has been done by me; but now how i go further with this data reader to populate the crystal report viewer. Since dataset consumes a lot chunk of memory on serve i.e. adapter.fill(ds); so i am trying to implement data reader way.
I Shall be highly thankful to you for your next valauable replies please.
Regards
Girish Sharma
|
|
|
|
|
In the Crystal Report Designer look in the Data Expert and you will be presented with 100's of ways to connect to data, choose stored procedure.
AFAIK, the viewer control has nothing whatsoever to do with creating the report, just rendering it to the screen.
|
|
|
|
|
But my crystal report viewer is on another page and i am storing my parameter value in querystring. So, if i would be able to provide the stored procedure by Data Expert (even this also i have to serach more) then how i will pass these query string parameters to the report please.
Regards
Girish Sharma
|
|
|
|
|
When you bind to the stored procedure using the data expert, Crystal will create parameters for the report. You can then use C# code to map the query string parameters. Crystal Parameters with C#[^]
|
|
|
|
|
My sincere thanks to you. Right now i am at my home and the work is going on office's pc, so i will try to implement your suggestions, and if need any further query, will post the same here or will mail to you by my mail id i.e. gksharma0481@yahoo.co.in.
Best Regards
Girish Sharma
|
|
|
|
|
As you suggested, i have created new report by data expert using stored procedure, which is taking 2 varchar2 arguments. I have placed following code in secm.aspx.vb file:
CrystalReportViewer1.ParameterFieldInfo.Clear()
Dim parameter As ParameterFields = CrystalReportViewer1.ParameterFieldInfo
Dim strtrol As ParameterField = New ParameterField()
Dim endroll As ParameterField = New ParameterField()
strtrol.Name = "par_strtrol"
endroll.Name = "par_endroll"
Dim xxx As ParameterDiscreteValue = New ParameterDiscreteValue()
xxx.Value = Request.QueryString("startrol")
strtrol.CurrentValues.Add(xxx)
parameter.Add(strtrol)
xxx.Value = Request.QueryString("endrol")
endroll.CurrentValues.Add(xxx)
parameter.Add(endroll)
CrystalReportViewer1.ParameterFieldInfo = parameter
CrystalReportViewer1.ReportSource = Server.MapPath("secm1998.rpt")
But when it is showing error "The parameter is incorrect." and a blank crystal report viewer control comes on the screen.
How to resolve it or any other way by which i can pass query string parameter to crystal report for crystal report viewer; please guide me.
Thanks & Best Regards
Girish Sharma
|
|
|
|
|
I've got a requirement to build a fairly simple data entry & retrieval application with a small amount of workflow. Is anybody aware of a tool that would, for example, take a description of the business model and spit out an ASP.NET application? I guess what I've got in mind is something like MS Access for building web apps - hope that makes sense.
Another way of phrasing the question would be: How can somebody that is unfamiliar with building web apps get up & running in the shortest possible amount of time?
Any pointers in the right direction would be greatly appreciated.
Ciao.
|
|
|
|
|
developer6 wrote: How can somebody that is unfamiliar with building web apps get up & running in the shortest possible amount of time?
Here is one[^]
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Ironspeed[^] immediately springs to mind - not sure what its capabilities are nowadays though.
C# has already designed away most of the tedium of C++.
|
|
|
|
|
That looks to be pretty much the kind of thing I'm after.
If yourself or anyone else could comment on how easy it is to get up the learning curve, implement user access rights, "record" locking, etc that would also be useful.
I will research this as best I can from the link you provided, however, it is always useful to hear from people that have had real-life experience of any given tool.
Many thanks.
Ciao.
|
|
|
|
|
I didn't use it myself above and beyond installing and having a quick play - it wasn't what I needed for the project. That's not to say it was no good, just didn't fit what I wanted.
Just one caveat - downloading the demo obviously put me onto some sort of marketing list - I got bombarded with phone calls and emails from them afterwards - not the usual spam per-se, but more "how can we help you decide to buy" type things - still irritating though.
C# has already designed away most of the tedium of C++.
|
|
|
|
|
This is partly related to my previous question...
Is it possible with an http handler or something or in my ashx file to determine what type of content the users request is looking for? Like an so can I pick that up on server side?
I need to determine if the image they are requesting(from my ashx page) is in an img tag on their site or if they are loading the direct link like xxxxx.jpg.
Thanks 
|
|
|
|
|
Check the referrer as a non-fool proof stop gap unless you also combine it with SSL.
|
|
|
|
|
The problem with that is that the referer url doesnt tell the difference between if they have clicked a link and ended up at my site or if another page is loading an image from it.
How would I bring SSL into it?
|
|
|
|
|
http://en.wikipedia.org/wiki/HTTP_referrer[^] Suggests that the referrer would be empty if the user typed it in, populated with a remote site if some one linked to you, and contain your site if you directed it. I believe SSL keeps a browser from spoofing your own URL in the referrer because you can check for a valid secure connection.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
