Re: DataGrid Display Question - Visual Basic Discussion Boards

Re: Start Your Application Automaticly

NathanJonker25-Feb-05 2:55

NathanJonker

25-Feb-05 2:55

Thanx Colin

Re: Start Your Application Automaticly

Dave Kreskowiak25-Feb-05 0:49

Dave Kreskowiak

25-Feb-05 0:49

In addition to what Colin said, when he mentioned that your app has to run continuously, that means that a user has to be logged in and running your app 24x7. Are you sure this is what you want? Or are you considering converting your application to a service?

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

Re: Start Your Application Automaticly

NathanJonker25-Feb-05 3:02

NathanJonker

25-Feb-05 3:02

Thanx Dave

Yes that sounds good how do you convert your application to a service

Re: Start Your Application Automaticly

Dave Kreskowiak25-Feb-05 4:21

Dave Kreskowiak

25-Feb-05 4:21

The best way to do it is if it is written as one from the start.
Windows Services: New Base Classes in .NET Make Writing a Windows Service Easy[^]
How Do I...Write a Simple Service Application?[^]

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

DataGrid Display Question

satcomengineer24-Feb-05 16:15

satcomengineer

24-Feb-05 16:15

I am linking all of the columns of a database table to a dataset, binding the table to a datagrid, and using simple binding to bind individual fields to text boxes. However, in the datagrid, I would like to only display a small subset of the columns in the record so that a user can recognize and select the desired record. I don't see a convenient way to do this. The DataView appears to require display of all of the table's columns. Any suggestions?

Re: DataGrid Display Question

Dave Kreskowiak25-Feb-05 1:04

Dave Kreskowiak

25-Feb-05 1:04

The DEFAULT DataView will generate all columns. Create your own DataView using only the columns you want (why do you think they call it a VIEW?), then Bind the DataGrid to that.

Creating a DataView[^] (.NET Developers Guide) Pay particular attention to the links at the bottom of the page.

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

Re: DataGrid Display Question

satcomengineer25-Feb-05 2:14

satcomengineer

25-Feb-05 2:14

You were right. Thanks. It was right under my nose all the time.

Re: DataGrid Display Question

Avarona25-Feb-05 1:05

Avarona

25-Feb-05 1:05

You should charge into dataset ONLY the lines and columns of the database table you really need, in this way it should works fine. To do it you only need to filter them using a SQL query. I mean you shouldn't charge dataset directly from database, you should charge dataset using a SQL query, in this way you'll see into Datagrid only the lines and columns you need.

I hope this help you. Big Grin | :-D

From text to time

numbrel24-Feb-05 15:24

numbrel

24-Feb-05 15:24

Using VB.NET and an Access DB

How do I get from text to time that is recognized by .NET?

I am currently using the Masked Edit Control from VB.6 which I added to my toolbox. I have one Masked Edit Control for date, and am able to get the correct date. I have another control for time and no matter what I enter, it comes back as 1/1/2001.

For maskDate: format property is: dddddd, mask property is: ##/##/##
for maskTime: format property is: hh:mm, mask property is: ##:##

    Dim dtmTime As Date<br />
    Dim dtmDate As Date<br />
<br />
    Dim drTime As ds5TimeDate.TimeTblRow<br />
    drTime = Ds5TimeDate1.TimeTbl.NewTimeTblRow<br />
    <br />
    drTime.EventID = txtEventID.Text<br />
    dtmDate = maskDate.FormattedText<br />
    dtmTime = maskTime.FormattedText<br />
    drTime._Date = dtmDate<br />
    drTime.Time = dtmTime<br />
<br />
    Ds5TimeDate1.TimeTbl.AddTimeTblRow(drTime)

Re: From text to time

Dave Kreskowiak25-Feb-05 1:00

Dave Kreskowiak

25-Feb-05 1:00

Are you looking for DateTime.Parse()[^]?

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

Re: From text to time

numbrel25-Feb-05 5:30

numbrel

25-Feb-05 5:30

Thanks, Dave,

But that seems to be about taking DateTime and manipulating it to get the string values desired. I want to go the other way, from string to DataTime.

On further investigation, it looks like VB is accepting the user input as LongTime (#10:00:00 AM#). The problem seems to be in updating the data source, the database in Access.

Anyone know how to turn the LongTime into 24-hour clock time?

Re: From text to time

Dave Kreskowiak25-Feb-05 7:14

Dave Kreskowiak

25-Feb-05 7:14

numbrel wrote:
But that seems to be about taking DateTime and manipulating it to get the string values desired.

If that were the case, the method would be called .ToString(). DateTime.Parse() takes a string, and optionally, a format provider for some guidance, and returns a .NET DateTime object with the numerical version of the date and time.

If the user is entering date and time seperately, you can combine them and submit the new date/time string to the Parse method:

dtmDate = maskDate.FormattedText
dtmTime = maskTime.FormattedText
Dim myDateTime As DateTime = DateTime.Parse( dtmDate & " " & dtmTime )

The .Parse() method assumes that the full date and time are provided in the current culture, which on default US machines is "mm/dd/yyyy hh:mm:ss". If any information is missing, the default action is to replace the missing information with the current date/time info.

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

Microsoft compact Framework

Member 37044324-Feb-05 9:05

Member 370443

24-Feb-05 9:05

Hi all,
i downloaded microsoft .net framework 1.0 sp2 installer.i installed it on my windowsxp( sp2 ) on which already .net studio is installed but after installation of compact framework i got
NCFSetup.exe error and it showing error as "RAPI.dll was not found.Reinstalling the application may fix this problem" , but after reinstallation also it showing giving same error.
pl. can u sugguest me how to tackle this problem.

kunal

Deacreasing Memory Usage

Mitch F.24-Feb-05 7:20

Mitch F.

24-Feb-05 7:20

Hello,

I have just finished writing a simple program that consists of 1 form, 2 embedded icons, and 1 notify icon. When I go into task manager, it says that it is taking up 21, 288 KB (21 MB) of memory.

How can I decrease the size of the memory "footprint" that my application puts on the computer? Or is it a limitation due to the .Net Framework?

D'Oh! | :doh:

Any suggestions or help will be appreciated,

Programmer2k4

My sig:

"The so-called 'Bugs' do not exist, they are merely features hidden by developers with message boxes that say 'An unhandled exception has occurred'." - Programmer2k4

"And it is a professional faux pas to pay someone else to destroy your computer when you are perfectly capable of destroying it yourself." - Roger Wright

I now use my CodeProject Blog!

Re: Deacreasing Memory Usage

Dave Kreskowiak24-Feb-05 7:33

Dave Kreskowiak

24-Feb-05 7:33

Everyone new to the .NET Framework see's this and freeks out. It's normal! You don't (and CAN'T) do anything about it.

If you minimize the app and restore it, you'll see that your application seemingly dumps alot of this memory. In reality, it's not. What's going on is that you've got the weight of the .NET Framework under your application. When you minimize your app, alot of your code and data (whether it's part of your app or part of the Framework) gets swapped out to disk and no longer resides in physical RAM. When you restore the app, only the code and data that's needed immediately gets swapped back to RAM. As you use your application, more data and code is swapped back and forth to the pagefile as needed.

If the Garbage Collector sees that there is plenty of RAM to run your application, it might not swap this stuff out and free up RAM. Why waste the time, if it's really not necessary? Only when RAM starts to run low will the garbage collector be more aggressive swapping code and data out to disk and cleaning up objects that aren't in use any more.

Don't panic! Just let the Garbage Collector do it's job!

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

Re: Deacreasing Memory Usage

Mitch F.24-Feb-05 8:00

Mitch F.

24-Feb-05 8:00

Thanks for the quick response. I originally thought it was due to my application.

Thanks,

Programmer2k4

My sig:

"The so-called 'Bugs' do not exist, they are merely features hidden by developers with message boxes that say 'An unhandled exception has occurred'." - Programmer2k4

"And it is a professional faux pas to pay someone else to destroy your computer when you are perfectly capable of destroying it yourself." - Roger Wright

I now use my CodeProject Blog!

Office Automation

mav070724-Feb-05 3:57

mav0707

24-Feb-05 3:57

Hi everyone,

I'm trying to find out if there is a way to apply Microsoft's Word formatting features to a textbox in .NET and be able to save and the retrieve the field to SQL server without loosing any of the formatting set. Does anyone know if this is possible? I would appreciate any comments or suggestions. Thanks so much!

Tasha

Re: Office Automation

Dave Kreskowiak24-Feb-05 4:44

Dave Kreskowiak

24-Feb-05 4:44

No, the TextBox doesn't support any formatting. The RichTextBox does, but on a much smaller scale than Word's formatting capabilities. Since the RTF formatting codes are in-line with the text, all you have to do to save everything is get the RichTextBox.Rtf, which returns a String, and save that to your database.

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

Formatting text in Text or rtf file

Thirumalaraj24-Feb-05 2:25

Thirumalaraj

24-Feb-05 2:25

hi,
in vb.net i have a form which contains 2 buttons and some text fields. the user may enter the data in text fileds in the following format.
ex. "have a #nice# day". some of the words may be prefixed and suffixed with the # symbol. now when user presses the first button i want to store these data(dataset) to the rtf or text file.
when the user presses the 2nd button, i want to open the same text or rtf file and then i want to format the file in such a way that. all the #(hash) delimited words should be italisized and the file has to be save.
so anyone pls. help me.

thanks in advance
thiru.

Re: Formatting text in Text or rtf file

Dave Kreskowiak24-Feb-05 4:25

Dave Kreskowiak

24-Feb-05 4:25

Help you with what? So far, you haven't asked a question we can answer. You'll have to be specific about what part of your application you need help with and what the problem is.

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

Re: Formatting text in Text or rtf file

Thirumalaraj24-Feb-05 15:56

Thirumalaraj

24-Feb-05 15:56

I need code for two buttons. to save the tab delimited file in the file. and when i press the 2nd button to italisize the # delimited text in the file.
thank u,
thiru

Re: Formatting text in Text or rtf file

Dave Kreskowiak25-Feb-05 0:59

Dave Kreskowiak

25-Feb-05 0:59

Ok. There is nothing "tab delimited" about your initial post.

All your doing is saving the Text to a file. If your using a RichTextBox control, all you need is the .LoadFile and .SaveFile methods to do this for you.

The the second part, you have to scan the text to find the first occurance of a '#' character. Save that position. Continue scanning until you find the next '#". This will give you enough information to set the .SelectStart and .SelectLegth properties of the RichTextBox, then use the .SelectionFont property to change the font to italics. An example of which is found here[^] on MSDN.

Why does this smell like homework?

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

Control's Main Bindable Property

JanEngelKetmig24-Feb-05 1:17

JanEngelKetmig

24-Feb-05 1:17

Is there a way, to get at the 'Main Bindable Property' of any given control. I am thinking, probably using system.reflection but i don't know how.

I have a bunch of different controls and i need to programmatically bind them to a dataset. To create a windows.forms.binder i need to know the property i want to bind to - the main bindable property for this particular control.

Help anyone? Confused | :confused:

Jan Engel Ketmig

Re: Control's Main Bindable Property

Dave Kreskowiak24-Feb-05 1:35

Dave Kreskowiak

24-Feb-05 1:35

JanEngelKetmig wrote:
'Main Bindable Property'

????? Confused | :confused:

Are you talking about the "default property"? Like Text for a TextBox?

I think you're looking for DefaultPropertyAttribute[^], which you should be able to find using Reflection. I don't have any example code, because frankly, I've never had to find/use the DefaultProperty for anything.

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

Re: Control's Main Bindable Property

JanEngelKetmig24-Feb-05 2:16

JanEngelKetmig

24-Feb-05 2:16

WOW that was fast... yes!, that oughtta do it... Thanks man..!

Jan Engel Ketmig

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