Re: ADO.NET - C# Discussion Boards

musefan22-Jun-09 3:43

musefan

22-Jun-09 3:43

Yes it is possible. Once its compiled it does not matter if it is in VB.Net or C#.Net you will still be able to make use of its functions from within another class. Just make sure you reference the DLL correctly.

Life goes very fast. Tomorrow, today is already yesterday.

harold aptroot22-Jun-09 4:54

harold aptroot

22-Jun-09 4:54

Hi, like musefan said, it's possible
But, I'm wondering.. why didn't you just go ahead and try it?

Manas Bhardwaj22-Jun-09 5:17

Manas Bhardwaj

22-Jun-09 5:17

Though, you have already been answered. It would be nice to read a bit about this[^].

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Rajesh R Subramanian22-Jun-09 5:46

Rajesh R Subramanian

22-Jun-09 5:46

Well, the question is answered. But I'll try to add more pointers.

Your query can come into picture only when the DLL was written in a native language, but needs to be consumed from within a managed language (or the plain old VB thing) AND which Calling Conventions[^] were used to export the functions from within the DLL.

While you write a DLL with any of those managed languages (or the plain old VB), it is always a COM DLL (You cannot write a Win32 DLL with VB, but you can write a COM DLL with C/C++).

It is a crappy thing, but it's life -^ Carlo Pallini

ADO.NET

Isaac Gordon22-Jun-09 2:37

Isaac Gordon

22-Jun-09 2:37

Hi Experts
I am working with sql server 2005 and visual studio 2005.i have a table having 10 fields and 2000000(above then 2 lakes record) first time when i fill the gird with
these record it takes so much time. i am using data table as data source in ADO.NEt.
and Then filter further records using row filter it also take time.
please suggest me how i can improve my performance so featch record fast as possible as possible.
Thanku
Dinesh

Manas Bhardwaj22-Jun-09 2:46

Manas Bhardwaj

22-Jun-09 2:46

Sharma Dinesh Kumar wrote:
Then filter further records using row filter it also take time

Use the WHERE clause in the SQL itself. It would trip the the number of rows returned.

Sharma Dinesh Kumar wrote:
please suggest me how i can improve my performance so featch record fast as possible as possible.

Are you really displaying the 2000000 all at once? Confused | :confused:

If not, use the paging instead and get the number of rows from the SQL on each page change.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

EliottA22-Jun-09 2:51

EliottA

22-Jun-09 2:51

Just to expand on the other post, loading 2 million records will take some time, paging would be your best bet to improve performance for loading, but for filtering 2 million records I don't see how to improve that bottleneck...

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

J4amieC22-Jun-09 3:21

J4amieC

22-Jun-09 3:21

What possible use to an application user would there be of showing 2 million records? Do you ever go past page 5 on, say, search results at google?

Display what the user wants to see, not everything in the database and expect the user to trawl through hundreds of pages looking for the record he/she wants.

Compile a project to a DLL-File

Henry Minute22-Jun-09 3:47

Henry Minute

22-Jun-09 3:47

Take a look at Implementing Virtual Mode with Just-In-Time Data Loading in the Windows Forms DataGridView Control[^] from MSDN.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

.NET PDF Parser

Programm3r22-Jun-09 2:19

Programm3r

22-Jun-09 2:19

Hi all,

I am looking for a product that can allow me to extract specific data from a PDF file or convert it into a text file. I have google the topic, but I am not sure which ones are good? Confused | :confused:

Does anyone know of such a product?

Many thanks in advance
Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: .NET PDF Parser

Rajesh R Subramanian22-Jun-09 3:20

Rajesh R Subramanian

22-Jun-09 3:20

iTextSharp (.NET) and libHaru (native language) comes to my mind. But I'm not sure if they allow you to extract "specific data" from a PDF file. You might be able to extract the whole contents of the file and you can create a text file out of this extracted data.

It is a crappy thing, but it's life -^ Carlo Pallini

Re: .NET PDF Parser

Programm3r22-Jun-09 3:26

Programm3r

22-Jun-09 3:26

Hi Rajesh,

Thanks for the info.

Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Haris21-Jun-09 23:29

21-Jun-09 23:29

Hi
I have two projects, A and B. A is referencing B. And I want to compile programmatically in the project A the referenced project B to a DLL-File.
How can I do that?

-Haris

Christian Graus21-Jun-09 23:34

Christian Graus

21-Jun-09 23:34

By deploying the command line compiler, and running it with Process.Start, I guess. Why do you want to do that ? I'm not sure what changes you can make to the dll and have your reference still work.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Haris21-Jun-09 23:41

21-Jun-09 23:41

Wow! Thanks for that fast answer! Big Grin | :-D

Hm, could you explain that more detailed, because I am kind of a newbie in all that compiling stuff...
I am part of a team and my part is to compile this DLL, based on the interface definition

Manas Bhardwaj21-Jun-09 23:47

Manas Bhardwaj

21-Jun-09 23:47

This [^]should help

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Haris22-Jun-09 1:05

22-Jun-09 1:05

I just glanced over the link you gave me. Seemes to be good help.

But in my case, it's the user who is generating this DLL dynamically.
In the article you gave me, it is described how to compile the DLL by giving the source files (.cs) as parameters. But when I release my application the user just gets a .exe file of the application, without the .cs files. How can I compile the project without the given source files, just the released .exe file?

-Haris

DoctorMick22-Jun-09 6:11

DoctorMick

22-Jun-09 6:11

You can't....there would be nothing to compile! What exactly are you expecting the user to compile? If they already have a compiled exe and no .cs files what more could they want?

Haris22-Jun-09 6:28