Member Avatar for Dili1234

I 'm doing an application using vb.net 2008 and sql 2005 i want to know whether it is possible load data into message box from database when form is loaded......

  • 2 Contributors
  • 2 Replies
  • 562 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Dili1234
Member Avatar for Jx_Man

Post your code. How far you doing this and we try to help you.

Member Avatar for Dili1234

Thank you very much
i'm not genius vb so i wrote the coding like this
I wrote this coding to Form Load event

Dim BName as String
myCommand2 = New SqlCommand(" Select Reg_No FROM Student Where Name= 'sa' ", myConnection)
        Dim dr As SqlDataReader = myCommand2.ExecuteReader
        While dr.Read()


            BName = dr(0).ToString

            'currentbalance = Double.Parse(dr(2).ToString)

        End While
        dr.Close()
        MessageBox.Show("Name:", BName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information

there was no errors but the message box is also not displaying..........
this the data table i used..........

Untitled.jpg 42.28 KB
Edited by Dili1234
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.