|
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.
|
|
|
|
|
hi all
Can anyone tell me How can i copy web references to local application?
I mean if i create VS 2008 web application and add web reference...do the dll's get copied to local system?
i need to copy the libs to a common folder.
any links wud be fine
"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"
|
|
|
|
|
As in a web service? Surely all dll will have to reside on their side..
|
|
|
|
|
QuickDeveloper wrote: do the dll's get copied to local system?
You need to underatnd the difference between the assesmbly reference and the web reference.
When you add a web reference, the visual studio creates a proxy to the web service to help your application communicate.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hi everyone,
I'm looking to change the FCKEditor inside the blog module and I'm replacing it with a third party control. I need to access some of its properties in there, preferably in the Page_Load event as well. I have Blog_03.05.01_Source.zip (CodePlex[^])package with me and inside that there was another zip file with the name DNN_Blog_Resources.zip which seems to have the actual source code. Now comes the problem: This is a VS 2003 solution which is not getting converted to VS 2008 that I'm using at the moment. So far I want to make changes in the EditBlog.aspx and EditBlog.aspx.vb. and BlogModuleBase.
It's the first time I'm customizing any DNN module. So far I've understood from the discussion that I need to build it after modifications and plug in the appropriate dll's in the DNN website's Bin folder. But the question is, can I customize the blog module in VS 2008? if yes then how? or do I have to go back to VS 2003 somehow and make a build in there? and... how do we configure the dnn blog project? 
|
|
|
|
|
Hi,
I want to create a site for multilevel marketing(ie.a root element in the top and it has left and right nodes,again these nodes contains child nodes such as left and right nodes and so on...).The client wants a pictorial representation of this,also if one clicks any of the nodes they want to redirect to another page.How can I visualize this.Pleas help me ...
Thanks
Denny
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
