Cor,
I will look into the Pascal notation. Right now i have all the code in
Hungarian and I dont want to make mods till this works..... Below is the
code you have me with 3 errors I ws unable to repair. Also you dumped the
data into a listbox, I was looking for Datagridview... or shuold i wait till
i se thi code running.
Thanks again
Marcelo
oSQLcmd.Connection = oSQLconn
oSQLcmd.CommandType = CommandType.Text
oSQLcmd.CommandText = "SELECT nAME, password FROM t_dssemp"
oSQLconn.Open()
Dim dt As New DataTable
Try
oSQLcmd.Fill(dt) 'Error - 'Fill' is not a member of
system.data.sqlclient.sqlcommand
Catch ex As Exception
MessageBox.Show(ex.ToString)
Finally
oSQLconn.Close()
End Try
dt.Columns.Add("Name", System.String, "FullName") ' Error = 'Sting'
is not a type in 'System' and can not be used as a expression
Listbox1.DataSource = dt
ListBox1.DataMember = "Name" ' Error - DataMember is not a member of
system.windows.form.listbox
"Cor Ligthert[MVP]" wrote:
I have pasted this in your code, by the way, did you know that the Hungarian
method is rare used in dotNet.
I have typed this on the fly, so watch typos etc.
\\\
cmd.Connection = conn
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT FullNAME, Address FROM t_dssemp"
conn.Open
dim dt as new datatable
Try
cmd.Fill(dt)
Catch ex as exception
MessageBox.Show (ex.Tostring)
Finally
conn.Close
End Try
dt.Columns.Add("Name",System.String,"FullName + " " + Address")
Listbox1.DataSource = dt
ListBox1.DataMember = "Name"
///
"Marcelo" <Ma*****@discussions.microsoft.comschreef in bericht
news:4C**********************************@microsof t.com...
Cor,
Sory I did not completly understand you commant but could you show me
the
code to take my list view and make it a Datagridview?
thanks
Marcelo
"Cor Ligthert[MVP]" wrote:
Hi Marcelo,
With the DataGridView a datatable is still working the best. You can use
a
datareader however are always busy to synchronise the indexes from the
columns.
Just my opinion
Cor
"Marcelo" <Ma*****@discussions.microsoft.comschreef in bericht
news:5E**********************************@microsof t.com...
Hello,
I am new to pulling data into VB and using DataGridViews..... so
this
might be a dumb question but I can not seem to understand how to make
this
work.
What I need acomplished:
Exec a select statement and out put the results to a DataGridView.
The
columns must be created on the fly as the query may return different
fields.
A small example I got to work to a List box. If you could convert this
to
a
DGV for me it would be great ....
Col1 - Full Name
Col2 - Address
oSQLcmd.Connection = oSQLconn
oSQLcmd.CommandType = CommandType.Text
oSQLcmd.CommandText = "SELECT FullNAME, Address FROM t_dssemp"
strSQLopen = OpenSQLConn() ' Open Connection
If oSQLconn.State = ConnectionState.Open Then
oSQLdr = oSQLcmd.ExecuteReader() 'executing the command and
assigning it to connection
While oSQLdr.Read()
ListBox1.Items.Add(oSQLdr.Item("FullName") & " " &
oSQLdr.Item("Address"))
End While
End If
oSQLdr.Close()
Thank you very much
Marcelo
