Re: Performance issue - C# Discussion Boards

Problems with permissions while using Reportviewer control

15-Nov-07 0:48

I think 1000 mails are more than enough
Sleepy | :zzz:

Regards
Pankaj Joshi

RinkM15-Nov-07 0:15

RinkM

15-Nov-07 0:15

Hello All,
I am using a reportviewer control in my application.In order to show a report in this control i have used the getreportdefinition and loadreportdefinition methods of the Reportservice2005. It works fine on my local machine but when i try to access it through a network machine i get a error Permissions insufficient for user "Domain\username" can any one help me out.....

Performance issue

Reddy Prakash14-Nov-07 23:56

Reddy Prakash

14-Nov-07 23:56

Hi all,

In my project i am reading a binary file of 81MB size and this information need to be inserted in to different tables of database.
The binary file is having several sections, contains some millions of records. while reading the binray information i am conveting the bytes in to c# datatypes and saving in arraylist, finally i am inserting in to the database Which is taking huge amount of time.
to insert this 81 MB size file in to database my application is taking 30 min.
Can any one suggest me how can i optimize the performance?

Thanks in advance

Satish - Developer15-Nov-07 0:15

Satish - Developer

15-Nov-07 0:15

No issue here

re

Satish - Developer15-Nov-07 0:16

Satish - Developer

15-Nov-07 0:16

Sorry, previously what i given response is wrong. ignore it Laugh | :laugh:

satish......

V.15-Nov-07 0:23

15-Nov-07 0:23

Hard to say.
There are a lot of ways to boost performance.
- Is the algorithm optimized? Are your for loops ok? (you don't perform actions in for loops that could be done outside eg.)
- Do you have GUI updates like a progress bar or something?
- Try an Ngen compilation, it might help (See MSDN)
- Can you use threads? eg Read in a block of bytes and while the DB updates, Read the next block at the same time etc...
- Did you use optimezed objects? (StringBuilder for string concatination eg.)

Hope this helps...

V.
If I don't see you in this world, I'll see you in the next one... And don't be late. (Jimi Hendrix)

Adeel Chaudhry15-Nov-07 0:28

Adeel Chaudhry

15-Nov-07 0:28

Hi,

You are use following tips/suggestions/whatever Smile | :)

1. Dont use INSERT when "LOADING" the data, use BULK INSERT
2. You can convert the data into c# format, and dump it as required in some temporary file, and bulk insert data using that file. If you are good at threading, you can boost the performance considerably.
3. If you are comfortable with Dynamic SQL, use it after converting data to c# datatypes.

And if you are good in threading and dynamic SQL then you can have a boost in performance as "complete loading of a 45 GigaBytes of data to 12 tables in 1.5 hours". That is what i experienced once!

Hope that much performance is enough for now and you find it useful! Smile | :)

Regards,

Adeel

Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

Adeel Chaudhry15-Nov-07 0:31

Adeel Chaudhry

15-Nov-07 0:31

Just for information, are you developing data warehouse?

Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

Combox problem urgent!!!

Pankaj - Joshi14-Nov-07 23:50

14-Nov-07 23:50

I'm Having a combobox which having items from itemtable. When table is empty then I have to show "No items" and if items are their in table then I have to show the item. So I fill datatable like

if (dataTableItems.Rows.Count >= 1)
{
cmbItem.Items.Clear();
cmbItem.DataSource = dataTableItems;
cmbItem.DisplayMember = dataTableItems.Columns["ItemName"].ColumnName;
}
else
{
cmbItem.Items.Clear();
cmbItem.Items.Add("No items");
cmbItem.Text = "No items";
}

This is working fine on form's load event.
But I have a button that will get items from other datatsource and fill the item tables. On click of the button I again fill the datatable and same code

if (dataTableItems.Rows.Count >= 1)
{
cmbItem.Items.Clear();
cmbItem.DataSource = dataTableItems;
cmbItem.DisplayMember = dataTableItems.Columns["ItemName"].ColumnName;
}
else
{
cmbItem.Items.Clear(); <-- ERROR COME HERE
cmbItem.Items.Add("No items");
cmbItem.Text = "No items";
}

But it will give error "Items collection cannot be modified when the DataSource property is set."

please help

Regards
Pankaj Joshi

Andrei Ungureanu14-Nov-07 23:55

Andrei Ungureanu

14-Nov-07 23:55

First you should set the combobox's datasource to nothing:

cmbItem.DataSource = string.Empty;

Hope it helps.

I will use Google before asking dumb questions

Pankaj - Joshi15-Nov-07 0:18

15-Nov-07 0:18

Giving error

"Complex Databinding accepts as a datasource either as IList or an IListSource" Cry | :((

Regards
Pankaj Joshi

Pankaj - Joshi15-Nov-07 0:35

15-Nov-07 0:35

I tried a lot and finally write this

cmbItem.DataSource = null;

This is working fine.

Will it create problem in the future...? Please reply...:->

Dear Christian Graus your suggestion needed this time... Confused | :confused:

Regards
Pankaj Joshi

Pete O'Hanlon15-Nov-07 0:03

Pete O'Hanlon

15-Nov-07 0:03

Wow. It's urgent with three exclamations. That makes it much more likely to get answered quickly. Wait, if I post urgent and put four exclamations in, does this mean my question will get answered before yours?

Now, please post questions with meaningful titles and respect the fact that these boards are looked after by volunteers who will get to your problem when they are ready. If your problem really is that urgent, then you should probably seek an answer in an area where people get paid to help.

Deja View - the feeling that you've seen this post before.

Pankaj - Joshi15-Nov-07 0:15

15-Nov-07 0:15

Thanks for your suggestion D'Oh! | :doh:

Regards
Pankaj Joshi

TJoe15-Nov-07 2:14

TJoe

15-Nov-07 2:14

Maybe the forums should support canned responses. So you don't have to type the same messsage about "cross-post" or "urgent" posts 20 times a day Smile | :)

Take care,
Tom

-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com

Grid View

Paramita0714-Nov-07 23:39

Paramita07

14-Nov-07 23:39

Edit Grid View

-- modified at 5:44 Thursday 15th November, 2007

Re: Grid View

Andrei Ungureanu14-Nov-07 23:49

Andrei Ungureanu

14-Nov-07 23:49

Paramita07 wrote:
Edit Grid View

Any questions there?

I will use Google before asking dumb questions

Re: Grid View

Pankaj - Joshi14-Nov-07 23:51

Send and Receive file from modem [modified]

14-Nov-07 23:51

Set IsEditable Property true!!! Poke tongue | ;-P

Regards
Pankaj Joshi

Re: Grid View

Paramita0715-Nov-07 0:26

Paramita07

15-Nov-07 0:26

yes its workng Laugh | :laugh:

hamid_m14-Nov-07 23:19

hamid_m

14-Nov-07 23:19

i need to send and receive file from a dial-up connection
i want to use modem in both machines for transfer files
let me know if there is some example about it or other good stuf
thanks

-- modified at 8:10 Thursday 15th November, 2007

Christian Graus14-Nov-07 23:20

Christian Graus

14-Nov-07 23:20

The connection is irrelevant, you need to connect to another machine that has the file, and request it. Do you have an IP address and path to the file ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

hamid_m15-Nov-07 2:03

hamid_m

15-Nov-07 2:03

i want to use modem to send and receive files and not from internet!!

Reddy Prakash14-Nov-07 23:34

Reddy Prakash

14-Nov-07 23:34

You can find information in google and this site.

please go through this example may be it will help you

http://www.codeproject.com/aspnet/webdialup.asp[^]