|
Hi there,
ASP.NET 1.1 / VB.NET / SQL 2000
I am generation report using crystal reports 10... the report is working fine but the problem that it is taking too long to load and display the data.
what I am doing is: I have two tables (one to many). I am getting all records from the first table and storing it in a table in my dataset... then I am getting all records from the second table depending on the ID from the first table. then storing it in another table in the dataset.
after that, I merge both tables in dataset by doing for each loop to merge each record to its related id.
Finally, bind it to the report
The merging process takes 2 minutes!!
What can I do? is there a better way to do the same thing?
can I control the range of records in my SQL statement?
Please help me
|
|
|
|
|
Try to write SQL JOIN Query that merges the two tables. Then, create a view using that query. This View can probably be used to populate the Dataset. SQL JOIN should be faster than merging the way you said I guess.
-------------------------------------------
It's code that drives you - Shyam
|
|
|
|
|
Respected sir,
I doing project on Image management so i need to doing all function
of image like as Zoom,transferant image,crop,move,change size,compose
etc. please anyone help me ,
please help me .....
|
|
|
|
|
You want to write a website for processing images ? ASP.NET can't do that, you'll need to write a Java or an ActiveX control. ActiveX only runs in IE.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Respected sir ,
i not detail idea about Java and Activex please make it more Clear.
i will wait u r reply..
Thanks for reply.
|
|
|
|
|
Well, you need to write a program in java, or in a language that supports activeX and then you need to integrate it into your website. Finally, you need to accept that a lot of people won't run it b/c they will set their security settings to reject it.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
ok thank sir for replay
i try that.
|
|
|
|
|
Please any one help me for my problem i very confuse. How i compose image in perticular location of other image by move ,croping ,transfarent image
|
|
|
|
|
What i want to do is on Click of a button a Input box must show that I get right
When then the user must enter a name into the text box and then I want to save that
Name to a verbal.
I am comfortable in asp.net with Visual Basic But not that good in JavaScript
My code that i have so far -
Protected Sub Button1_Click (ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim script As String = "<script language='javascript'>prompt('Corrective _
Action : ', 'NOTHING')" & "</script>"
Page.RegisterStartupScript("JavaScript", script)
End Sub
This Brings up My Input box but i need to read the value the user enterd.
Regards
Ryno Engelbrecht
|
|
|
|
|
The only way you can hope to do this, is to put a hidden field on your form, then if the input is created. you write javascript to store it's value in the hidden field. Use the CLientID property of the field in VB to work out what it will be called in javascript.
If you have only one control, you could also try hiding it and showing it again using JS.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi Christian
Will you be able to maby give me some sample code for this as i think i will work
Regards
Ryno Engelbrecht
|
|
|
|
|
OK, this is off the cuff, and will need debugging.
Add a hidden field called hf1.
In your codebehind write javascript like this
string js = "var hf1 = '" + hf1.ClientID + "';";
Of course, wrap it in javascript tags and insert it into your page. Also, put the following method in
void WriteHidden(tb)
{
var hf = document.getElementById(hf1); // this uses the client Id you wrote
if (hf)
{
hf.value = tb.value; // Not sure about this bit, the property may be 'text' instead of 'value', or even something else. It may also be different between IE and Firefox
}
}
Then write your textbox so it has the following attribute:
onblur="WriteHidden(this);"
Then when the focus leaves the textbox, the textbox is passed to the method, and hopefully, the value is copied to the hidden field. Then you can access this value from the codebehind.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
On a site I’m optimizing I know a lot of DataSets are stored in Viewstate. I need a tool that can help me analyze the contents of the Viwestate so I can localize big Viewstates. A similar tool for analyzing contents of Session and cache data in IIS would be great.
_____________________________
...and justice for all
|
|
|
|
|
Have you looked at ASP.net built in tracing.
|
|
|
|
|
No, i don't think so... How?
_____________________________
...and justice for all
|
|
|
|
|
I am using this variable from the code behind :
public string UserID;
protected void RadGrid1_PreRender(object sender, EventArgs e)
{
MembershipUser myObject = Membership.GetUser();
UserID = myObject.ProviderUserKey.ToString();
}
I am trying to use the variable in the INSERT command in the aspx file but it seems that the following command does not work,any ideas why?
InsertCommand="INSERT INTO table (column1, column2) VALUES (value1, '<%=UserID %>')"
Thanks!
|
|
|
|
|
What about
InsertCommand="INSERT INTO table (column1, column2) VALUES (value1, '" + UserID + "')"
Assuming that you are doing this from within RadGrid1_PreRender routine.
|
|
|
|
|
Thnx for answering but I want to use the variable in the aspx file not in the code behind file.
|
|
|
|
|
It would help if you defined 'does not work', but I thought that using code blocks like this only worked for properties, not for public variables.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
What I mean is that if I use sql management studio and enter the insert query manually there is no problem.
|
|
|
|
|
But what *is* the problem ? Is the value being passed back blank ? Is it incorrect ? Does it blow up ?
Did you try using a property ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Can you give me a sample .aspx code of properly passing a value from the code behind?
Thank you!
|
|
|
|
|
int _n; // this is a variable
protected int N
{
get { return _n; } // this is a property
}
Wrap your variable in a property and then access the property.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi All,
I Have two web site written in Framework 1.1 and I have web site written in visual Studio 2005 How I can make master page to call all pages which written in Framework 1.1 within ContentPlaceholder in MSVS 2005 Site Master Page.
Ala Qunaibi
|
|
|
|
|
You can't. There were changes between 1.1 and 2.0 that mean you surely cannot just compile in 2.0 without code changes, and to use a master page, you need to run it under 2.0, obviously.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
