Public function not working from class

Question

1.00/5 (1 vote)

See more:

Public Function

not working from class when i use a class and connection then it is not working

Public Function connection()

        con = New SqlConnection("server=DESKTOP-BNDMR5K;database=irfanansari;integrated security=true")
        Return con
    End Function

Public Function getvalueto() As SqlCommand


      com = New SqlCommand("select * from sale", Me.con)

      adpt = New SqlDataAdapter
      adpt.SelectCommand = com
      table = New DataTable

      adpt.Fill(table)
      MsgBox("Record Save Sussfully Now", MsgBoxStyle.Information, "Saved Record")




  End Function

not working when i use like this

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

'GridView1.DataSource = c.getvalueto
       'GridView1.DataBind()

End Sub

What I have tried:

<pre>Public Function connection()

        con = New SqlConnection("server=DESKTOP-BNDMR5K;database=irfanansari;integrated security=true")
        Return con
    End Function

Public Function getvalueto() As SqlCommand


      com = New SqlCommand("select * from sale", Me.con)

      adpt = New SqlDataAdapter
      adpt.SelectCommand = com
      table = New DataTable

      adpt.Fill(table)
      MsgBox("Record Save Sussfully Now", MsgBoxStyle.Information, "Saved Record")




  End Function

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

'GridView1.DataSource = c.getvalueto
       'GridView1.DataBind()

End Sub

Posted 14-Aug-19 8:31am

irfanansari

Updated 14-Aug-19 9:05am

Add a Solution

Comments

MadMyche 14-Aug-19 14:38pm

Any errors being thrown? Have you debugged this and looked at the values step-by-step?

Richard Deeming 15-Aug-19 14:09pm

NB: You've tagged this as ASP.NET, but you're using MsgBox. That will not work. Remember, your code is running on the server.

At best, the code will throw an exception telling you that you can't display a user interface in a non-interactive program. At worst, the message will pop up on the server, where nobody will ever see it, and your code will hang waiting for an administrator to log in to the server and acknowledge thousands of messages.

It might appear to work when you debug the code in Visual Studio. But that's only because, in that specific case, the client and the server are the same computer. As soon as you deploy the code to a real server, the code will stop working.

irfanansari 16-Aug-19 6:00am

i told already no error but Gridview not show any record and when i use same code behind form load its works it is not error not problem just it is not working as function

GridView1.DataSource = c.getvalueto
'GridView1.DataBind()

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2019-08-14T09:06:00

Solution 1

See the examples here: Function Statement (Visual Basic) | Microsoft Docs[^]
e.g.

Function MyFunction(ByVal j As Integer) As Double
    Return 3.87 * j
End Function

Posted 14-Aug-19 9:06am

RickZeeland

Comments

irfanansari 16-Aug-19 6:04am

sir i use this
Public Function getvalueto() As SqlCommand

com = New SqlCommand("select * from sale", Me.con)

adpt = New SqlDataAdapter
adpt.SelectCommand = com
table = New DataTable

adpt.Fill(table)
MsgBox("Record Save Sussfully Now", MsgBoxStyle.Information, "Saved Record")

End Function

and behind load form

GridView1.DataSource = c.getvalueto
'GridView1.DataBind()

but not show any resuld not bound but as i use same code behind form load then it works

RickZeeland 16-Aug-19 7:26am

Your function is not returning anything, use the Return statement.