|
Can Anyone Tell How To Increase Crystal Reports Performance
I'm Using Crystal Report Viewer And Web Services To Retrieve Data.
Ala'a Al Atrash
Special Systems Co.
Culture St. - Amman - Jordan
Software Developer
Work Tel:- +962 6 5664221 Ext. 140
Home Tel:- +962 6 4752702
Mobile Tel:- +962 7 96700423
|
|
|
|
|
Could be many different things. Look at your queries and fine tune them if possible. Also look at network performance as well.
Hope this is a start 
|
|
|
|
|
hi,
i had tuned my queries, and it worked very good,
thank u very much.
Ala'a Al Atrash
Special Systems Co.
Culture St. - Amman - Jordan
Software Developer
Work Tel:- +962 6 5664221 Ext. 140
Home Tel:- +962 6 4752702
Mobile Tel:- +962 7 96700423
|
|
|
|
|
Respectfully,
First I have added a UserControl, then i have added a panel on it and on the panel i have added a combobox. But on run, when i want to select an item from combobox , it autohide the list. I can select the item by typing. When i click the dropdown button it opens the list. but when i try to select an item. The list get collapsed. Plz solve the Problem.
Thanks.
|
|
|
|
|
Hello,
Tried it out and worked fine.
Are you shure, that the ComboBox is in the Container of the panel?
All the Best,
MArtin
|
|
|
|
|
Yes i checked it again.
First i have made a usercontrol, then i make a panel on it, then i put all the controls on that.
But these all controls (Complete user control), i am adding at runtime on a Autocad Pallate.
Problem still exist?
Thanks,
|
|
|
|
|
I got this error when I ran cmd.ExecuteNonQuery(). But if I run the cmd directly in the database, it doesn't have any problem.
Can anyone know what causes it?
|
|
|
|
|
|
i have two tables one is class table,student table if i select a class from class table all the students presnt in that class should be added to list box if i select two classes all the students present in the two classes will have to come into the list box but i am getting only the last one of the class
can anybody help me please?
sivamyneni
|
|
|
|
|
Hi sivamyneni,
I think when you select one class , the result come in the list box. but when you select the second class , the previos result disappear and the new one shows. I am not sure what method you are using for adding in the list box. Before adding items in the list box , be sure, you should not clear the list. You have to append or insert into the list.
If problem not solved, than show the code to me.
|
|
|
|
|
Hi Aslam Bari,
I just want to find out how to append the items into the list
this is the code i used in my project
//
foreach(DataGridItem di in DataGrid1.Items)
{
CheckBox check=(CheckBox)(di.Cells[0].FindControl("checkbox"));
if(check.Checked==true)
{
// here retrieving the items from database to the dataset after that just wrote this code
Dataset dsItem=new DataSet();
ListBox1.DataSource=dsItem;
ListBox1.DataBind();
ListBox1.DataTextField=dsItem.Tables[0].Columns["ThumbNail"].ToString();
Thanks in advance
sivamyneni
|
|
|
|
|
Dear Sivamyneni,
Currently i don't know the problem with DataSource, i think at a time we can add only one datasource. I also couldn't find the listbox.DataBind() and listbox.DataTextField. What version of .NET u r using.
By the Way an alternate way i am giving here and try it..
//Connection to database
OdbcConnection con = new OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};server=localhost;database=mysql;uid=root;pwd=mysql");
con.Open();
//Get data from user table
OdbcDataAdapter ad = new OdbcDataAdapter("select * from user", con);
DataSet set = new DataSet();
ad.Fill(set);
//Here is the code to add all the items of the first column of the user table.
foreach (DataRow row in set.Tables[0].Rows)
{
listBox1.Items.Add(row[set.Tables[0].Columns[0]]);
}
////ON OTHER EVENT LIKE CHECKBOX OR BUTTON CLICK REPEAT THIS.
OdbcDataAdapter ad = new OdbcDataAdapter("select * from BILL", con);
DataSet set = new DataSet();
ad.Fill(set);
//Here is the code to add all the items of the first column of the bill table.
foreach (DataRow row in set.Tables[0].Rows)
{
listBox1.Items.Add(row[set.Tables[0].Columns[0]]);
}
|
|
|
|
|
hi,
I have made a vpn connection and tested it but i want to know how to run and launch it from the code or windows scripting host.I need to make an automatic program to run this vpn in random times and close it.
|
|
|
|
|
Hi
I have written a program to zip files with Shell32 in C#.
The program zips the folders and then deletes the original folders.
The problem is that the folders are big in size ,each being atleast 10MB in size.
Now when the program starts the delete process it gives me that the folder cannot be deleted because it is being used by other process.
Now I think that the zip process is not completed and the delete process starts and hence the error.
Is there any way to know that the folders are not being used anymore and then i can proceed with the delete operation.
Or is there anything that will tell me that the zip prcess is over.
I am using the thread.sleep method but it aint helping.
Thanks,
Nikhil
|
|
|
|
|
It would probably be better to use a .NET implementation of Zip because that way you can completely control it. And find out exactly when it finishes.
Free Libraries:
#ziplib - http://www.icsharpcode.net[^]
Xacc.IDE[^] has a BZip2 implementation
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9
Ed
|
|
|
|
|
HI,
I'm a new member here and am glad to be one.I'm sure I'll find vast info here
as I start to venture into learning C#. I'm currently a axapta developer which happen to use X++ language (similar to C#).
regards,
pdchua
|
|
|
|
|
|
Hi, I currently want to build the login form where the process will be:
1.User choose their membership type like free, gold, platinum (role)- bind from role db
2.User go to fill in login, pw, secret question.. page
3.User go to other page continue, finally complete
But problem faced when i want to pass the selected role type in 1st step into 2nd step, then only add role [failed to pass], since in first step, there's no username yet, so add role is failed..
I try to pass data in the same page, but failed...
Besides, how to show limited role membership in drop down box?
The application will have following role: Admin, Manager, free member, gold member, platinum member.
But when I let visitor to signup, I only want to bind the free, gold, platinum member out, not others.
Help
|
|
|
|
|
Hi,
MembersTable contains a column called TitleNumber. TitlesTable has columns called TitleNumber and TitleName.
I have a textbox that I want to show the TitlesTable.TitleName that is referenced to MembersTable.TitleNumber == TitlesTable.TitleNumber.
How do I go about achieving this.
Glen Harvy
|
|
|
|
|
Glen Harvy wrote: How do I go about achieving this.
Research DataBinding on http://msdn.microsoft.com or here on Code Project
"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum
led mike
|
|
|
|
|
led mike wrote: Research DataBinding on http://msdn.microsoft.com or here on Code Project
Posting a question here is a last resort for me.
If I could find it on the web then I would have.
Can you please also explain this to me:-
led mike wrote:
"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum
How do you mark a question "Hey mate - if you'rve got time please help me with this" ?
Glen Harvy
|
|
|
|
|
Hi Glen, welcome to Code Project. Besides the forums there are many Articles on Code Project.
Specific to your topic on the Home Page ( Click on "All Topics" in the menu bar) There is a menu on the left side of the page. Click "General C#" which expands the menu then click "C# Database" There are like 100 Articles on ADO.NET topics some of which are beginners guides and include Data Binding. Most Articles contain sample code and even downloadable code complete with projects ready to compile and run. The MSDN site also contains Articles of a similar nature.
In case you have trouble navigating Code Project here is a link to C# Database Articles Page[^]
"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum
led mike
|
|
|
|
|
Hello,
I want to destroy an object without GC help. I read a lot of stuff how to do it, but im confused.
I realise that I must implement a Dispose metod, but I dont know how to release resources inside Dispose(bool) method. I will try to explain that into this example:
public class MyClass
{
long dolgo;
public MyClass(long lo)
{
dolgo = lo;
}
public ~MyClass()
{
Dispose(false);
}
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this); // Finalization is now unnecessary
}
protected virtual void Dispose(bool disposing)
{
if(!m_disposed)
{
if(disposing)
{
// Dispose managed resources
//(how to dispose it, if in this class isnt any object)
}
// Dispose unmanaged resources
}
m_disposed = true;
}
private bool m_disposed = false;
}
class Program {
static void Main (string[]args){
MyClass mc=new MyClass(thisIsAnLongValue);
//here I do stuff...........
/* and here i want to deleate this object. I realise that I must call mc.Dispose();(or something like that), but I dont know how to release resources into the Dispose(bool) method ( in every example is an object to dispose inside the object class, but I dont have it I have only a variable long).*/
}
}
will be eny diference, if there is an array like MyClass[] mc;(mc destroy==?)
Thanks
Matej
|
|
|
|
|
Hi,
first of all when you implement a Dispose method you should implement the IDisposable interface (this interface is declaring void Dispose()).
In your case you do not need any Dipose at all. The garbage collector will do all the needed work. Dispose is primarily needed to release unmanaged or very big resources. As you only have one long field there is absolutely nothing you could release.
And have a look at rhis article[^]. Its a good introduction.
|
|
|
|
|
Hi,
thank you for the answer. I looked those article and I'm wandering how can be img object set to null after being disposed (destroyed) in the Dispose(bool) method, and where is the code for that dispose?
if (img != null)
{
img.Dispose();
img=null;
}
So if my tought is write this code "img.Dispose();" doesnt destroy the object, just free the resource he occuped? And the code for dispose an Image object in in that Image class and how does it look this piece of code? So you can't dispose an object who have the reference to a variable.
Is it always when you want to dispose an object the "final" call to an System class?
Matej
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
