VB.NET

Displaying record from SQL Server in a grid

•

Join Date: May 2008

Posts: 23

Reputation: realone has a little shameless behaviour in the past

Solved Threads: 0

realone

Offline

Newbie Poster

Displaying record from SQL Server in a grid

Aug 21st, 2009

Pls see my code.Nothing is displaying in the grid

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
          Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric"
        Dim myConnection As OleDbConnection = New OleDbConnection
        myConnection.ConnectionString = connString
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection)
        Dim ds As DataSet = New DataSet
        Dim dc1 As DataColumn = New DataColumn
        'da.Fill(ds)
        da.Fill(ds, "bdata")
        dc1 = ds.Tables("bdata").Columns("id")
        DataGridView1.DataSource = ds.DefaultViewManager
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
          Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric"
        Dim myConnection As OleDbConnection = New OleDbConnection
        myConnection.ConnectionString = connString
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection)
        Dim ds As DataSet = New DataSet
        Dim dc1 As DataColumn = New DataColumn
        'da.Fill(ds)
        da.Fill(ds, "bdata")
        dc1 = ds.Tables("bdata").Columns("id")
        DataGridView1.DataSource = ds.DefaultViewManager

Last edited by John A; Aug 21st, 2009 at 6:33 pm. Reason: added code tags

•

Join Date: May 2009

Posts: 249

Reputation: jbisono is an unknown quantity at this point

Solved Threads: 35

jbisono

Offline

Posting Whiz in Training

Re: Displaying record from SQL Server in a grid

Aug 21st, 2009

add this at the end.
DataGridView1.DataBind()

regards

If your already resolved your issue, flag it as solved.
José Bisonó

•

Join Date: Oct 2008

Posts: 3,949

Reputation: adatapost has a brilliant future

Solved Threads: 705

adatapost

Offline

Senior Poster

Re: Displaying record from SQL Server in a grid

Aug 22nd, 2009

@jbisono: add this at the end. DataGridView1.DataBind()
No, It's not working. It is for ASP.NET.

 Help with Code Tags 
 vb.net Syntax (Toggle Plain Text) 
 DataGridView1.DataSource = ds.Table("bdata")
 DataGridView1.DataSource = ds.Table("bdata")

•

Join Date: May 2009

Posts: 249

Reputation: jbisono is an unknown quantity at this point

Solved Threads: 35

jbisono

Offline

Posting Whiz in Training

Re: Displaying record from SQL Server in a grid

Aug 24th, 2009

Oops that is true adatapost my bad.
thanks for correcting me.

If your already resolved your issue, flag it as solved.
José Bisonó

•

Join Date: Sep 2008

Posts: 150

Reputation: samir_ibrahim is on a distinguished road

Solved Threads: 16

samir_ibrahim samir_ibrahim is offline

Offline

Junior Poster

Re: Displaying record from SQL Server in a grid

Aug 24th, 2009

•

Originally Posted by realone

Pls see my code.Nothing is displaying in the grid
Help with Code Tags

VB.NET Syntax (Toggle Plain Text)
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
          Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric"
        Dim myConnection As OleDbConnection = New OleDbConnection
        myConnection.ConnectionString = connString
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection)
        Dim ds As DataSet = New DataSet
        Dim dc1 As DataColumn = New DataColumn
        'da.Fill(ds)
        da.Fill(ds, "bdata")
        dc1 = ds.Tables("bdata").Columns("id")
        DataGridView1.DataSource = ds.DefaultViewManager
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric" Dim myConnection As OleDbConnection = New OleDbConnection myConnection.ConnectionString = connString Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection) Dim ds As DataSet = New DataSet Dim dc1 As DataColumn = New DataColumn 'da.Fill(ds) da.Fill(ds, "bdata") dc1 = ds.Tables("bdata").Columns("id") DataGridView1.DataSource = ds.DefaultViewManager