Hi there I am new to .net and I have put at least 4 hours in to figuring out why i cannot view my results when I run a datagrid in my 2010 visual studio WPF application.

Also, it looks like it is only filling one record in the datagrid. Any ideas?

Dim cnn As SqlConnection
Dim connectionString As String

connectionString = "Integrated Security=SSPI;Initial Catalog=TestDb;Data Source=" & Environment.MachineName.ToString
cnn = New SqlConnection(connectionString)
Dim sql = "SELECT * FROM address "

Dim dscmd As New SqlDataAdapter(sql, cnn)
Dim ds As New DataSet



hello !
well try this code ,you have some errors in your code , first , you define dataset , but you had not define a table in it , 2nd one datagrid.items.add(ds) , this is wrong way , if you want to populate the grid then use datasource property , here is a code , hope this will solve your prob

dim con as new sqlconnection("Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;")
'now here i am defining a data adapter
dim da as new sqldataadapter("select * from table",con)
'now m going to define dataset 
dim ds as new dataset 
'here i create a table in it.
'here i fill that table
        da.Fill(ds, "Table")
'here populate the grid
DataGrid1.datasource = ds.tables("table")
        Catch ex As Exception

        End Try

this will solve your prob , :)


This article has been dead for over six months. Start a new discussion instead.