Access Licnese - .NET (Core and Framework) Discussion Boards

DataView.RowFilter / BindingSource.Filter Performance Issue !

Mehdi Moshtaghi29-Jan-06 4:50

29-Jan-06 4:50

Hi,
I've just exported my VS2003 project to VS2005. The First thing that troubled me is the performance issue with DataView.RowFilter which is almost 10 times slower in .NET 2.0 !!!

I have the same problem with BindingSource.Filter (which of course I believe uses the RowFilter anyways), then I've made no modifications to the project, meaning (using DataView.RowFilter) and still have this problem (10 secs for somefield Like '%something%') for 70000 Rows, which in NET 1.1 is something like 1 sec.

Thanks.

Getting handle of the file in use

baburman28-Jan-06 19:46

baburman

28-Jan-06 19:46

Hi guys,

I am working a .NET windows application using C#. I have placed a
web browse control in my Windows Form in order to show many types of documents like word doc, text file, ms excel sheet, images or even flash animation etc. There are three panels in this Form. On the left panel there's a Directory tree just like we see in Windows Explorer. The Top panel contains a list of documents in the currently selected directory. I have placed the web browser control in the third panle which is right below the top panel. When the user selects a document (word, excel etc.) it is opened and viewed in the browser control. So far so good. Now the problem occurs when the user selects a document and it is opened for view and he wants to delete it by using the shortcut menu option which is provided by me. The system throws
an exception when i attempt to delete this document from the os directory and says like "The file is in use by another process.". This occurs even if the user selects another document and the application attempts to delete the 'previously' selected document again. This is for sure that the process which is running my app has not yet destroyed the handle of the document, but i don't know how to destory it. I guess the only solution could be P/Invoke but don't know which API functions have to be used. Anybody could help getting rid of this?

thanks

bABURmAN

some sort of progress bar

DirA28-Jan-06 5:03

DirA

28-Jan-06 5:03

Hi,

I have a windows form application with a BackgroundWorker. The user has to stop the backgroundWorker by clicking a button. I would like to indicate that it is still running by using some kind of (continuous ?) progress bar (like the progress bar appearing when Windows XP starts). Is there any easy way to implement this?

Thanks in advance.

Re: some sort of progress bar

kasik28-Jan-06 7:52

kasik

28-Jan-06 7:52

If you just want to create a progress bar that never ends - i.e. you don't know how long the background thread is going to take, then this[^] article might help you (or this[^] one for C#)

Cheers,
Will H

adding xpdfviewer control

raj kumar reddy27-Jan-06 17:48

raj kumar reddy

27-Jan-06 17:48

hi,

i added xpdfviewer control to the vb.net proj. But unable to handle the events of control. Is there any importstatement should i add.

raj

where's ToolStripMenuItem.Index?

happycpp27-Jan-06 17:33

happycpp

27-Jan-06 17:33

hello everyone...
i'm using the new ToolStripMenuItem instead of MenuItem but i couldn't find the Index property which gives the position of the menu item if it is a submenu...can somebody tell me how to get it...

and where's ToolStripMenuItem.MenuItems?

happycpp28-Jan-06 19:19

happycpp

28-Jan-06 19:19

also i noticed that there's no MenuItem property!!!which of course returns the submenuitems...

Access Licnese

elraton27-Jan-06 16:24

elraton

27-Jan-06 16:24

I've been developing a small app in C#, that uses an Access DB.
When the idea to sell it came, I began to wonder... Can I?
I mean. I use an access created .mdb file to store my data. So... does anyone know how the licencing things are handled on matters like this?

Thanks. Blush | :O

Re: Access Licnese

Matthew Hazlett27-Jan-06 17:01

Matthew Hazlett

27-Jan-06 17:01

Verify this for yourself, this is what I have found...

There are three cases:

1. If the developer builds a solution in an application that includes Jet but does not have a runtime version, for example Microsoft Excel or Microsoft Office, they must purchase and install a copy of the application on each user's desktop for their solution to run correctly.

2. If the developer builds a solution in an application that includes Jet and provides a runtime license or compilation, for example Microsoft Access (with the Microsoft Access Developers Toolkit), Microsoft Visual Basic, or Microsoft Visual C++, subject to the end user license agreements accompanying each of these products, they can build and distribute their solution to users with a runtime version or as a compiled application (.EXE).

3. If the developer builds a solution in an application which does NOT include Jet, but relies on Jet, (for example, Microsoft Project or Microsoft Visual FoxPro™) they face two requirements. First, they must adhere to the license agreement for the application they used to develop the solution. Second, they must purchase and install a copy of a Microsoft application or tool which DOES include Jet on the user's desktop.

You want #2 and #3 I believe. I'm no good at decyphering this lawyer speek.

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_JetDatabaseEngineLicensingandSolutionDistribution.asp[^]

Also found this:

Access 2003 Developer Extensions are part of the new Visual Studio Tools for the Microsoft Office System software package.

Licensing and Distribution Rights

The licensing agreements included with Access 2003 Developer Extensions simplify the distribution of solutions or code segments. They include a royalty-free Access Runtime, which allows for the distribution of Access solutions and Access Data Projects, and free use and distribution of portions of the tools source code as part of your solutions.

http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspx[^]

Matthew Hazlett

Sometimes I miss the simpler DOS days of Borland Turbo Pascal (but not very often).

-- modified at 23:08 Friday 27th January, 2006

SMTP SSL

Brisunifreddyp27-Jan-06 12:49

Brisunifreddyp

27-Jan-06 12:49

Hi,

Am running the .NET Framework 1.1 and need to send e-mail via an SMTP connection via an SSL-enabled connection (for example, a GoogleMail account connection).

I have worked around the POP3 connection to receive e-mail using open source components online. But can anyone either give me, or point me in the direction of, advice on how to implement Secure Socket Layer on the SMTP connection in .NET 1.1

Thanks in advance!

Fred

Re: SMTP SSL

Dave Kreskowiak27-Jan-06 18:15

Dave Kreskowiak

27-Jan-06 18:15

In .NET 1.1, I don't think there is any support for SSL SMTP. In 2.0, there is the System.Net.Mail implementation that is a SMTP client that I think implements SSL.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Column Order in a DataGridView with BindingList as DataSource

KoRUPT27-Jan-06 11:28

KoRUPT

27-Jan-06 11:28

I am having problems getting the column order in a DataGridView object to display how I want it. Here are my objects:

Data object

<br />
class CData<br />
{<br />
   //data members<br />
   private uint id;<br />
   private string name;<br />
   private object otherstuff;<br />
   //constructor<br />
   ... //standard<br />
   //get / set<br />
   public uint ID{<br />
      get{ return id; }<br />
      set{ id = value; }<br />
   }<br />
   ... //basic get/set for the other data members<br />

I then create multiple CData objects and place them in a List<CData> object "myList". When I go to bind this list to a DataGridView I use the following code

<br />
BindingList<CData> bindlist = new BindingList<CData>(myList);<br />
myDataGridView.DataSource = bindlist;<br />
myDataGridView.Refresh()<br />

the problem comes when my form is shown and my data is presented. Currently I can not figure out how to order the columns generated from my CData class properties. By default I thought they would show up in the order that they are declared like:

| ID | Name | OtherData |

but I find that the order is chosen at random (or some other factor I can not figure out) and they display something like:

| OtherData | ID | Name |

Now normally this wouldnt be too big of a problem but in my real world application I am using a Data object with over 100 fields which are generated from a file with a strict structure layout and it is critical that I see my columns in the proper order.

I hope I explained this properly and would appreciate any help that can be offered on the matter.

Thank you.

PS: If some moderator or something feels I will get more response in the C# forum, please move this post or advise me to move it.

There are only 10 types of people in this world; Those who understand binary, and those who don't.

-- modified at 17:30 Friday 27th January, 2006

Re: Column Order in a DataGridView with BindingList as DataSource

KoRUPT30-Jan-06 5:42

KoRUPT

30-Jan-06 5:42

bump to the first page. I still need help on this issue.

There are only 10 types of people in this world; Those who understand binary, and those who don't.

.net 2.0 vs 1.1?

Small Rat27-Jan-06 11:15

Small Rat

27-Jan-06 11:15

Hi,

I heard 2.0 is not compatible with 1.1. Is that truee? and do all the code written by vs 2003 can be compiled without change?

I am thinking move to vs 2005!

Alan Shen

MCAD for .NET Version
^~^~^~^~^~^~^~^~^~^~^
Great idea is the beginging of success!

Re: .net 2.0 vs 1.1?

Dave Kreskowiak27-Jan-06 11:26

Dave Kreskowiak

27-Jan-06 11:26

Are they compatible? In most cases, yes! But it depends on the specific code.

Does all code written in 2003 compile without change in 2005? No, but most does. Some modification will be necessary in some places, but again, it depends on the specific code.

You can read through the Breaking Changes in .NET Framework 2.0[^] for more information.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: .net 2.0 vs 1.1?

Paul Conrad27-Jan-06 14:35

Paul Conrad

27-Jan-06 14:35

Dave Kreskowiak wrote:
You can read through the Breaking Changes in .NET Framework 2.0[^] for more information.

Dave,

Thanks for the link. I've been wondering about any issues between 1.1 and 2.0 migrating.

Paul

Datacolumn type

denizmercan27-Jan-06 5:30

denizmercan

27-Jan-06 5:30

I have a Dataset that has returned data from SQL Server. I would like to read in what the SQL Server type is for each Column and what the size is. For instance is the column is a nvarchar(20) I would like to be able to find out that the column has a size of 20. Is this possible? I can't seem to figure this out even using the DataColumn.

DataColumn.MaxLength is returning -1.
I tried also SQL Command:
SELECT COL_LENGTH('MyTable','MyColumnName') AS 'MyColumnLength'
it's running fine in SQL Query analyzer but it's returning 0 in C#

Any idea?
thanks

.NET

Richard Htin27-Jan-06 4:09

Richard Htin

27-Jan-06 4:09

dear all,

I want to know manually dispose() is better than destructor().If you know that, sent message for me. (thanks.)

With Regards.

hk,linn

Re: .NET

Dave Kreskowiak27-Jan-06 4:56

Dave Kreskowiak

27-Jan-06 4:56

Ummm... What?

Are you asking which is better? Neither! Each individual object has its own requirements for calling .Dispose. Such as all the GDI objects (Graphics, Bitmap, Image, Icon, ...) all require you to call their .Dispose methods when you're done with them. Not doing so will result in OutOfMemory Exceptions sooner or later.

Pretty much, the rule of thumb is if the object requires an underlying system handle or other unmanaged resource, you MUST call .Dispose on that object when you're done with it.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

.Net Framework

Net-Programer-and-developer27-Jan-06 3:13

Net-Programer-and-developer

27-Jan-06 3:13

i am a beginner to .Net Framework. I want to know some of the website to visit

sowjanya kumar

Re: .Net Framework

Kevin McFarlane27-Jan-06 3:36

Kevin McFarlane

27-Jan-06 3:36

This one!

Kevin

Re: .Net Framework

Dave Kreskowiak27-Jan-06 4:52

Dave Kreskowiak

27-Jan-06 4:52

There's hundred of them! All you need to do is Google for ".NET Framework tutorials"...

But The Code Project is a good place to start!

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: .Net Framework

Paul Conrad27-Jan-06 5:23

Paul Conrad

27-Jan-06 5:23

Dave Kreskowiak wrote:
There's hundred of them! All you need to do is Google for ".NET Framework tutorials"...

But The Code Project is a good place to start!

Dave is right. Myself, I have this site bookmarked, heck, even as the default startup page for that matter, and numerous other sites that pertain to anything for .Net bookmarked. This site is a definite starting point.

Happy .Net programming,

Paul

Re: .Net Framework

Colin Angus Mackay27-Jan-06 5:50

Colin Angus Mackay

27-Jan-06 5:50

Other than this site:
* msdn.microsoft.com/[^] - The Microsoft Developers Network is the premium resource from MS.
* DotNetRocks[^] - Podcasts that teach you about various aspects of .NET
* dnrTV[^] - Video tutorial/interviews from DotNetRocks team.

I recommend listening to DotNetRocks when you are driving or doing your daily commute. It is an excellent source of information during an otherwise dead time.

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Re: .Net Framework

Ravi Bhavnani27-Jan-06 11:25

Ravi Bhavnani

27-Jan-06 11:25

This[^] is a good source of tutorials. And of course, right here at CodeProject!

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.