What property controls the "format" of DataTable columns? - C# Discussion Boards

21-Jul-08 14:39

nelsonpaixao wrote:
I have visual studio 2008 pro, i hoped it to be there when editing excel in visual c#.

I know there is one, not sure about the pro version, but I have that installed at work, so I can look for you in about 8 hours Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: C# macro recorder

leppie21-Jul-08 21:58

What property controls the "format" of DataTable columns?

21-Jul-08 21:58

Yes the Pro version does have a macro recorder.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

JoeRip21-Jul-08 13:22

JoeRip

21-Jul-08 13:22

I have a DataTable (dt) with a DataColumn (dc) whose Datatype is System.Int64.

I want this column to display the 64 bit Int in Hexadecimal format, as if the number had been converted like Int64Data.ToString("X").

What property of a column controls this display? There's no "format" property for a column, and "Expression" appears to be for aggregation.

It's important that the column datatype remain INT64 (and not string), or I would just do the formatting conversion myself.

Can somebody point me to the correct method for setting the column display formatting?

Thanks.

Re: What property controls the "format" of DataTable columns?

JoeRip21-Jul-08 13:34

JoeRip

21-Jul-08 13:34

Doh. Of course. You don't format the display of a DataTable DataColumn, because it's never displayed. You format the display of the column in the DataGridView, in which the DataTable data is displayed.

Man, you don't do any table stuff for a year, and you forget everything.

Re: What property controls the "format" of DataTable columns?

leppie21-Jul-08 14:40

extern keyword not only with DllImportAttributte

21-Jul-08 14:40

Hehe, it happens Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Lutosław21-Jul-08 13:01

Lutosław

21-Jul-08 13:01

Hi!

While browsing the .Net Framework source code I saw many methods marked extern, but without a DllImport attributte. My question is how could I use the extern keyword that way and when is it useful (no documentation on msdn; the only thing I found is this post[^].
For example, in String.cs:

[MethodImplAttribute(MethodImplOptions.InternalCall)] 
private extern String PadHelper(int totalWidth, char paddingChar, bool isRightPadded);

And in comstring.cpp:

FCIMPL4(Object*, COMString::PadHelper, StringObject* thisRefUNSAFE, 
INT32 totalWidth, CLR_CHAR paddingChar, CLR_BOOL isRightPadded)
{
    CONTRACTL {
        DISABLED(GC_TRIGGERS);
        THROWS;
        MODE_COOPERATIVE;
        SO_TOLERANT;		
    } CONTRACTL_END;

    STRINGREF refRetVal = NULL;
    STRINGREF thisRef = (STRINGREF) thisRefUNSAFE;
    HELPER_METHOD_FRAME_BEGIN_RET_ATTRIB_1(Frame::FRAME_ATTR_RETURNOBJ, thisRef);
    //-[autocvtpro]-------------------------------------------------------

    WCHAR *thisChars, *padChars;
    INT32 thisLength;

    if (thisRef==NULL) {
        COMPlusThrow(kNullReferenceException, L"NullReference_This");
    }
(...)

So: how do I have to setup the compiler to build a program which has some methods marked as "InternalCall", without making a separate unmanaged DLL library.
Another question is why VS won't download the unmanaged parts of a source code and forces as to search for them manually...

Greetings - Gajatko

Portable.NET is part of DotGNU, a project to build a complete Free Software replacement for .NET - a system that truly belongs to the developers.

Re: extern keyword not only with DllImportAttributte

leppie21-Jul-08 14:46

Re: extern keyword not only with DllImportAttributte

21-Jul-08 14:46

gajatko wrote:
While browsing the .Net Framework source code I saw many methods marked extern, but without a DllImport attributte. My question is how could I use the extern keyword that way and when is it useful

This is normally built into the assembly. I do not know the exact details, but I think the method body just refers to some unmanaged section of code. I think you can 'get this' by using the Managed C++ compiler.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Lutosław21-Jul-08 23:43

Lutosław

21-Jul-08 23:43

leppie wrote:
I think you can 'get this' by using the Managed C++ compiler

How to compile a C# code with a Managed C++ compiler?

Greetings - Gajatko

Portable.NET is part of DotGNU, a project to build a complete Free Software replacement for .NET - a system that truly belongs to the developers.

Printing from a webservide

Dirso21-Jul-08 12:47

Dirso

21-Jul-08 12:47

Hi,

From a webservice, is it possible to print out something directy to the printer? (Without showing the default internet explorer print dialog). I need that because a few barcode printers required data in a special format (usually an ascii sequence)

Thanks,
Dirso

Re: Printing from a webservide

leppie21-Jul-08 14:43

Re: Printing from a webservide

21-Jul-08 14:43

Dirso wrote:
From a webservice, is it possible to print out something directy to the printer?

As long as your server has a printer it should work Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Dirso21-Jul-08 15:10

Dirso

21-Jul-08 15:10

Hi,

Sorry, I think my question was not good. My actual question is: Is it possible to print a line or something directly to a windows printer installed in the computer where the .aspx is been called? For example, If I make a webapplication, put a button on it and an event when the user clicks that button some text must be printed as it is, without the pre-formatation internet explorer does. If it's possible, how can I do that?

Thanks,
Dirso.

WebService uploading/processing/returning the results

Dirso21-Jul-08 12:40

Dirso

21-Jul-08 12:40

Hi,

1) I need to create a webservice that should receive a file and some string data and then write to the response stream the results
2) The major problem: How to create a client software that uploads async a file to this webservice and gets the responde with the results? I think the WebClient class doesn't fit my needs, because it was suppose to upload the file quietly, gets the response (and it can be a big response) also quietly and after all that shows a message or write to the log file the results

Thanks,
Dirso.

Speed Search Text File

polishprogrammer21-Jul-08 11:19

21-Jul-08 11:19

I need to retrieve some information from a text file that basically consists of two columns of data in a tab delimited format. The first column consists of a unique identifier to lookup the main piece of information contained in the second column. This text file will consist of approximately 60,000 lines of data and I need to search through the text file in response to a particular event to retrieve the main piece of information from the text file using the unique identifier to search the file.

This search process needs to occur rapidly (t < 1 second). Is there a way to search a text file that rapidly? Alternatively, I could pull this information into an MS Access database (the database format used by my application) each time the user logs in to my application and perform a basic SQL query to retrieve the relevant information.

Any advice regarding the best method for searching this information (searching text file or importing text file data into database or some other method) would be appreciated.

Thank you.

CPallini21-Jul-08 11:35

CPallini

21-Jul-08 11:35

Well, databases are optimized...
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

polishprogrammer21-Jul-08 11:42

21-Jul-08 11:42

The database option would be fine with me. I think that the text file that my application will be supplied with will be updated only once a day and my application is used throughout the day with only 1 or 2 log in events per 8 hour shift, so if I retrieve the information from the database only on log in, I should be OK.

Another question I have, though, is how to optimize retrieving the information from the text file. I would need some sort of BULK INSERT utility with MS Access. I know SQL Server has a BULK INSERT command, but unfortunately I do not have the luxury of using SQL Server at present. Is there a way to get the same functionality from Access?

Thanks.

Luc Pattyn21-Jul-08 12:12

Luc Pattyn

21-Jul-08 12:12

Hi,

there is a Microsoft SQL Server 2005 Express Edition which is free, and I trust a
better performer than Access is.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

polishprogrammer21-Jul-08 12:28

21-Jul-08 12:28

Thanks, Luc. Yes, I understand that, but "my application" is not truly my application. I work for a company and they decide what database gets used. So, for now I'm stuck making this work with MS Access and need a solution using MS Access.

nelsonpaixao21-Jul-08 12:52

nelsonpaixao

21-Jul-08 12:52

I also think that you should try sql server 2005.
Store your text files in the database and build some good search store procedures.
With C#,Trigger the SP on an event and display it in a datagridview object.

Good Luck Roll eyes | :rolleyes:

Alan Balkany22-Jul-08 4:01

Alan Balkany

22-Jul-08 4:01

IMHO using a database is overkill for this application. A simple hash table will do the job easier and faster than a database.

1. Create a hash table with size around 120,000 (prime numbers work best).
2. Read (key, value) pairs from the text file and insert them into the hash table.
3. While you probably can't read and process a text file that size in under a second, you can retrieve an entry from the hash table in less than a hundredth of a second.

polishprogrammer23-Jul-08 8:08