Can I create a method that populate a label with userid without using a datagrid,datalist or a repeater? If so could guide me...Help!!
************************************************** ********************
I get the following error:
Compiler Error Message: BC30408: Method 'Public Function Getid(sender As Object, e As System.EventArgs) As Object' does not have the same signature as delegate 'Delegate Sub EventHandler(sender As Object, e As System.EventArgs)'.
************************************************** ********************
In the form I have a label "lbl2"
...Some Code...
<asp:Label id="lbl2" runat="server" OnInit="Getid" />
...Some Code...

Function Getid(sender As Object, e As System.EventArgs)

Dim myConn AS OleDbConnection
Dim myAdapter As OleDbDataAdapter
Dim vData As DataSet
Dim query As String

'specify the data source
myConn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("/db/sel.mdb"))

'define the command query
query = "SELECT Distinct Salesman.Nroid FROM Customers,Salesman WHERE Salesman.Username='" & Context.User.Identity.Name &"'"

'create a command object and set its
myAdapter = New OleDbDataAdapter(query, myConn)

Try
 vData = new DataSet()
 myAdapter.Fill (vData)
catch
End Try
return vData

End Function

What am I doing wrong?

Dont Double post.

http://p2p.wrox.com/topic.asp?TOPIC_ID=54293

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
 is good !

=========================
  Success grows out of struggles to overcome difficulties.
My Email:[email protected]

=========================