Visual Basic

Re: Creating database during installation

26-Jan-06 6:03

There's absolutely no reason why you wouldn't you be able to put a bunch of INSERT INTO statements into a text file and have SQL run that too.

The XML version you have works too.

If you have a TON of data to preload, create a DTS job to import it. If it's a bunch of data, an XML import works too. If it's just a few things, you could drop the appropriate INSERT INTO statements into the SQL script...

The point is it can be automated, it's just a matter of preference how you want to do it.

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

Mekong River26-Jan-06 12:27

overcome timer interval limitations

26-Jan-06 12:27

To create the scritp just right click on the database and try to find the command "Generate to script..." may be in the "All task" sub menu. But it just generate the structure of the database, not all of the record.

Marc Soleda25-Jan-06 21:31

Marc Soleda

25-Jan-06 21:31

Hi all,
is there another control or a way to ovorcome the timer limitations in VB6? I mean that the standard control can be configured to a maximum of 65535 ms. I'm interested to set it to minutes. Is it possible or is there any other control to do that?

Thanks in advance,

Marc Soleda.

... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits

Re: overcome timer interval limitations

Dave Kreskowiak26-Jan-06 4:56

26-Jan-06 4:56

There's no way to change the control. Setting a Timer for minutes is also not a real good idea. Usually, people are doing this thinking it can be used as a scheduler to launch some task at a specified time. That's a bad design.

In any case, you're much better off setting the Timer for, say, 60 seconds, then in the Tick event, checking the current time against the scheduled time of the process you want to launch.

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

CMOS Battery Voltage

RichardBerry25-Jan-06 20:58

RichardBerry

25-Jan-06 20:58

Hi

Does anyone know if there is a way to read the CMOS battery voltage using vb.Net

Cheers

Richard

Dave Kreskowiak26-Jan-06 4:54

26-Jan-06 4:54

Only if the motherboard supplyies such information and you have some software interface to get at it. 99% of them don't.

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

Mekong River26-Jan-06 12:22

26-Jan-06 12:22

IF the motherboard supply information, where does this information is located? In the system information or in device manager dialog?

Dave Kreskowiak26-Jan-06 14:53

26-Jan-06 14:53

You'll have to consult with the motherboard manufacturer. There is no standard to follow, therefore, no way to know how it's going to be exposed.

It's not going to be listed anywhere in the System Properties, Device Manager dialog, or anywhere else for that matter.

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

Mekong River27-Jan-06 4:14

displaying selective data in datagrid

27-Jan-06 4:14

Thank you very much for your information.

D.N.25-Jan-06 19:18

D.N.

25-Jan-06 19:18

i have two tables from each table one unique columns values are displayed on two combo box i also have a textbox, i have developed a datagrid which on clicking add button displays thes three values and one value based on a formula as first row of datagid. but when i again select the different values to insert in my datagrid as second row clicking add button replace the old valus with new valus.
how can i add more rows in my datagrid in every click preserving my old selected values?

Dev

Re: displaying selective data in datagrid

RichardBerry25-Jan-06 20:54

RichardBerry

25-Jan-06 20:54

Not sure I understand your question, but you can create a datatable to store your values you want to save, so each time you click your button add a new row to the table. Use the table as the datagrid 'DataSource'

<br />
Public Sub setupTable()<br />
        Dim c1 As New DataColumn<br />
        Dim c2 As New DataColumn<br />
        Dim c3 As New DataColumn<br />
        Dim columns() As DataColumn = {c1, c2, c3} 'Array of Datacolumns<br />
        dt.Columns.AddRange(columns)<br />
        'Use this table as the datasourec for your datagrid<br />
        Me.DataGrid1.DataSource = dt<br />
    End Sub<br />
<br />
<br />
    Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged<br />
        If Me.ComboBox1.SelectedIndex > -1 And Me.ComboBox2.SelectedIndex > -1 Then<br />
            Me.TextBox1.Text = CStr(CInt(Me.ComboBox1.SelectedItem.ToString) * CInt(Me.ComboBox2.SelectedItem.ToString))<br />
        End If<br />
    End Sub<br />
<br />
<br />
    Private Sub ComboBox2_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox2.SelectedIndexChanged<br />
        If Me.ComboBox1.SelectedIndex > -1 And Me.ComboBox2.SelectedIndex > -1 Then<br />
            Me.TextBox1.Text = CStr(CInt(Me.ComboBox1.SelectedItem.ToString) * CInt(Me.ComboBox2.SelectedItem.ToString))<br />
        End If<br />
    End Sub<br />
<br />
<br />
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
        Dim dr As DataRow<br />
        dr = dt.NewRow<br />
        dr.Item(0) = CInt(Me.ComboBox1.SelectedItem.ToString)<br />
        dr.Item(1) = CInt(Me.ComboBox2.SelectedItem.ToString)<br />
        dr.Item(2) = Me.TextBox1.Text<br />
        dt.Rows.Add(dr)<br />
    End Sub<br />

view text file

eagertolearn25-Jan-06 14:21

eagertolearn

25-Jan-06 14:21

Hi guys,
I was wandering, is there any way to open/view a text file using the default/any text editor?
I am creating an application that will generate a report. It would be very nice if there is a button that will open the generated report.

thank you for your time

Dave Kreskowiak25-Jan-06 15:39

25-Jan-06 15:39

Use the Process[^] class to launch the file you want to open in its default application.

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

eagertolearn26-Jan-06 5:42

eagertolearn

26-Jan-06 5:42

thanks Dave,

The other issue is, my file doesn't have any extension.
So when i tried to run it, it will give me an error msg saying "there is no application to open this file".
I was wondering, since i can't modify the name of the file, can i just specify i want to use a text editor to open the file or can i make it to treat the file as a text file?

This application will be used in many different computers with different textEditor ex. notepad++ and textpad

Thank you

-- modified at 12:10 Thursday 26th January, 2006

Dave Kreskowiak26-Jan-06 7:27

26-Jan-06 7:27

In that case, using the very same Process class, launch Notepad and make the file you want to open a command line parameter. The same examples in the docs apply to doing it this way too.

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

eagertolearn26-Jan-06 9:32

eagertolearn

26-Jan-06 9:32

Yes, I'm doing it this way:
Try
System.Diagnostics.Process.Start("Textpad", path)
catch
try
System.Diagnostics.Process.Start("Notepad++", path)
catch
try
System.Diagnostics.Process.Start("Notepad", path)
catch
msgbox(ex.message)
end try
end try
end try

However, this way i specify what texteditor i want to use, it has to be either textpad, notepad++ or notepad. Other than that it will error out.
Is there another better way to do it? :S

Thank you

Dave Kreskowiak26-Jan-06 14:51

26-Jan-06 14:51

If you really wanted to use an external editor, then no. Otherwise, you could write you own little text editor class and use that. Although Notepad is on every version of Windows ever installed...

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

DataGrid

welbert25-Jan-06 13:26

welbert

25-Jan-06 13:26

Need Help on how to customize datagrid in windows form, using vbnet2005... that will allow me to click one grid...

Thanks and more power..... Blush | :O

Mekong River25-Jan-06 14:11

http://msdn.microsoft.com/msdnmag/issues/03/08/DataGrids/[^]

25-Jan-06 14:11

Dave Kreskowiak25-Jan-06 15:34

25-Jan-06 15:34

That won't work for the GridView in 2005...

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

Dave Kreskowiak25-Jan-06 15:40

25-Jan-06 15:40

Great! You've narrows it down to the new DataGridView. That just increased the number of things you can customize to a few hundred. I'll ask you again...

HOW DO YOU WANT TO CUSTOMIZE THE GRID??

"allow me to click one grid" doesn't make any sense what-so-ever.

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

welbert25-Jan-06 16:01

welbert

25-Jan-06 16:01

tnx anyway... Suspicious | :suss:

Dave Kreskowiak25-Jan-06 16:14

Connect to employee time clock via modem

25-Jan-06 16:14

For what? You haven't asked a question anyone can answer. Quite literaly, your asking "how can I customize my car?". I'm asking you what you want to customize. Paint job? Engine? Exhaust? Body work? Interior? Sound system?

The quality of answer you get is directly related to the quality of the question.

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

kherrerab25-Jan-06 12:37

kherrerab

25-Jan-06 12:37

Hi all.. i want to download the info from the employee time clock via modem and vb6.. how can i do this??

Re: Connect to employee time clock via modem

Mekong River25-Jan-06 14:16