Visual Basic

Re: I canot get the Datagrid to populate from access database on other computers

15-Aug-04 4:46

It would appear that one of the programs requirements is the installation of MDAC 2.7 or better. Check it out here[^].

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

Anonymous16-Aug-04 11:39

Re: I canot get the Datagrid to populate from access database on other computers

16-Aug-04 11:39

that did not solve the problem... Frown | :(

Dave Kreskowiak16-Aug-04 18:15

Re: I canot get the Datagrid to populate from access database on other computers

16-Aug-04 18:15

My mistake, the Jet database engine that access uses last appeared in the 2.6 version of MDAC, not 2.7.
Does the tartget machine have Office on it?

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

cdesouza17-Aug-04 10:30

Re: I canot get the Datagrid to populate from access database on other computers

17-Aug-04 10:30

I've done some work using an access databse and VB.net. You need to have the .NET Framework and the JET Drivers installed on the machine. That's all I needed. That's assuming it's a very basic & simple app. The .NET Framework is available at www.windowsupdate.com. As for the Jet Drivers needed for Access. Look here http://support.microsoft.com/default.aspx?kbid=829558

Hope that helps you ! Smile | :)

Dave Kreskowiak18-Aug-04 5:22

Re: I canot get the Datagrid to populate from access database on other computers

18-Aug-04 5:22

You might want to tell the original poster this stuff. I don't need it because I don't do any of myu work in Access/Jet anymore.

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

cdesouza18-Aug-04 5:36

Re: I canot get the Datagrid to populate from access database on other computers

18-Aug-04 5:36

Thanks for sharing that with us Dave ! Roll eyes | :rolleyes:

cdesouza18-Aug-04 5:28

18-Aug-04 5:28

SetCursorPos etc.

Anonymous14-Aug-04 7:05

14-Aug-04 7:05

Hi, I am a beginner in .NET programming, and I need build an app, which allows me to click on any place on the screen - I heard about API function SetCursorPos during my VB6 programming in the past, but I don't remember the string which declares this function and I don't know if it is still possible to do it by this way. The second problem - how can I click on this place, specified by SetCursorPos function, now I haven't a clue how to do it. Please help. Thanks.

Re: SetCursorPos etc.

Aaron Eldreth15-Aug-04 13:57

Aaron Eldreth

15-Aug-04 13:57

Anonymous wrote:
need build an app, which allows me to click on any place on the screen

You should be able to click any place on the screen without an app.

Aaron Eldreth

TheCollective4.com
My Articles

I hereby boycott this poll. Really....
- Leppie

Re: SetCursorPos etc.

Anonymous15-Aug-04 22:11

15-Aug-04 22:11

Thanks, but I would need to build an app to do it automaticaly... (something like macros etc...

DataTable Scope

Greg_VFP814-Aug-04 5:49

Greg_VFP8

14-Aug-04 5:49

Hi All,

How is scope controlled with DataTables ?

I have a pocketpc project that has 4 forms

The first form provides a listbox bound to a datatable that allows the user to choose which record they want to work with

The other 3 forms allow them to manipulate data in that record of the datatable. I have bound the listbox like so:

' Create a new dataset.
myDataSetDS = New DataSet

' Set the Locale for the DataSet,
' using current culture as the default.
myDataSetDS.Locale = CultureInfo.CurrentCulture

' Set file names and create file streams.
' The XSD, XML, and EXE must be in the same directory.
xmlFileName = "\program files\mis\units.xml"
xsdFileName = "\program files\mis\units.xsd"
Dim FsXML As New FileStream(xmlFileName, FileMode.Open)
Dim FsXSD As New FileStream(xsdFileName, FileMode.Open)

' Load the schema into the DataSet.
Dim xtrXSD As New XmlTextReader(FsXSD)
myDataSetDS.ReadXmlSchema(xtrXSD)
xtrXSD.Close()
FsXSD.Close()

' Load the data into the DataSet.
Dim xtrXML As New XmlTextReader(FsXML)
myDataSetDS.ReadXml(xtrXML)
xtrXML.Close()
FsXML.Close()

unitsDt = myDataSetDS.Tables("x_Units")

'Bind the list box to the unit names.
lboUnits.DataSource = unitsDt
lboUnits.DisplayMember = "unit"
lboUnits.ValueMember = "id"

now on form2 if I have a textbox bound to the same datatable
changing from one row to another in the listbox does not update the textbox on the second form ? Is the textbox bound to a 2nd copy of the datatable ? How to properly scope the datatable to have the row change update the new record values in the rest of the project ?

Thanks

Gregory O. Foote
Software At Work, Inc.
Pensacola, Fl

Re: DataTable Scope

Dave Kreskowiak15-Aug-04 15:36

Using ActiveX controls at runtime !

15-Aug-04 15:36

THe scope is no different from any other variable you declare. Once the function that declared the variable finished it's execution, is falls out of scope. Your not binding to a copy of the same datatable, but it all depends on how your getting your information to and calling up form2. Without seeing any code, it's impossible to tell you whats going on.

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

TopGunPk13-Aug-04 12:03

TopGunPk

13-Aug-04 12:03

Hi !

I am writing a software in Visual Basic 6.0, and i want the user to select from a list of all the registered ActiveX controls in Windows, and then add & use this control in my software at runtime.

How can this be done ?

For example, when a user enters "c:\windows\system\MyControl.OCX" in a textbox and presses "SAVE" button, this path is saved in a Access Database table. Next time when this software is run, it reads this path from the database at start up time, loads the control pointed to by the path and displays the GUI interface of this control on the Form.

Connect to MySQL

cdesouza13-Aug-04 10:45

13-Aug-04 10:45

I know this is a very basic level question. But how can I connect to a MySQL Database and pass queries to and from the database. Help !

Thanks Smile | :)

Re: Connect to MySQL

Mekong River14-Aug-04 4:19

Mekong River

14-Aug-04 4:19

You should tell us that which interface that you will use. If you want to connect to the web using PHP, then you should read from here[^]

Hope that help Big Grin | :-D

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

Re: Connect to MySQL

cdesouza17-Aug-04 10:22

how can I change to select variable instead of slectedRow?

17-Aug-04 10:22

I am trying to access the mySQL Database from VB.net. I downloaded and installed the myODBC drivers. I set them up in Contol Panel->Admin Options->ODBC drivers. It connects fine from here. But I have no idea how to access these drivers from within my VB.net program. I am currently connecting to an access databse. I need to use a mySQL databse instead. Any help will be greatly appreciated !

Thanks

How can I do this?

Lisana13-Aug-04 10:44

Lisana

13-Aug-04 10:44

how can I code a whole column cell to unactive in datagrid?
I have 3 column in my datagrid, and I only want my first column cell to be active. the rest of them should not be active. is everybody know how to code it?

Thanks

Lisa

Re: How can I do this?

Syed Abdul Khader16-Aug-04 0:09

Syed Abdul Khader

16-Aug-04 0:09

Derive a new ColumnStyle from DatagridTextBoxColumn and override its Edit method with return. Use that column style for your Inactive column.

Public Class DataGridInactiveColumn<br />
    Inherits DataGridTextBoxColumn<br />
<br />
    Protected Overloads Overrides Sub Edit(ByVal source As System.Windows.Forms.CurrencyManager, ByVal rowNum As Integer, ByVal bounds As System.Drawing.Rectangle, ByVal [readOnly] As Boolean, ByVal instantText As String, ByVal cellIsVisible As Boolean)<br />
        Return<br />
    End Sub<br />
End Class

Lisana13-Aug-04 8:30

Lisana

13-Aug-04 8:30

I have this code to slected row and return row number. In my datagrid, I have entity_id, name, description, and I hide my entity_id column. when user selected the row, then it returned the entity_id instead of that rowNumber. Is anybody know how to change the code below to enable to return entity_id instead of row number?

Public Function GetSelectedRows(ByVal dg As DataGrid) As System.Collections.ArrayList
Dim al As New ArrayList
Dim cm As CurrencyManager = Me.BindingContext(dg.DataSource, dg.DataMember)
Dim dv As DataView = CType(cm.List, DataView)
Dim i As Integer
For i = 0 To dv.Count - 1
If dg.IsSelected(i) Then
al.Add(i)
End If
Next
Return al

End Function

Lisa

Re: how can I change to select variable instead of slectedRow?

S Sansanwal15-Aug-04 17:30

S Sansanwal

15-Aug-04 17:30

Change function as
Public Function GetSelectedRows(ByVal dg As DataGrid) As System.Collections.ArrayList
Dim al As New ArrayList
Dim cm As CurrencyManager = Me.BindingContext(dg.DataSource, dg.DataMember)
Dim dv As DataView = CType(cm.List, DataView)
Dim idCol As Integer
idCol = 2
Dim i As Integer
For i = 0 To dv.Count - 1
If dg.IsSelected(i) Then
al.Add(dg.Item(i, idCol))
End If
Next
Return al

End Function

Assign idCol the Index of entity_id column. I have used 2 for sample

Sanjay Sansanwal
www.sansanwal.com

Re: how can I change to select variable instead of slectedRow?

Lisana16-Aug-04 2:57

Lisana

16-Aug-04 2:57

Thanks! It works.. Smile | :)

Lisa

vb.net

sm_knc13-Aug-04 8:09

sm_knc

13-Aug-04 8:09

creation of dataadapter through coding... no wizards..

sm

Re: vb.net

Anonymous13-Aug-04 8:19

13-Aug-04 8:19

MustInherit Public Class DataAdapter
Inherits Component
Implements IDataAdapter

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatacommondataadaptermemberstopic.asp

Re: vb.net

Dave Kreskowiak13-Aug-04 9:11