Visual Basic

Re: How can I bind data to a database

17-Mar-07 7:32

It sounds like you have some misconceptions about how all this works. Post the code you're using to get the data and bind the grid and we'll see if we can straighten it out. Is this an ASP.NET app or Windows Forms?

You don't bind to a stored procedure. You call a stored procedure to return the records you want. The records end up in either a DataTable or some other bindable source. You then bind the grid to that record set.

Dave Kreskowiak
Microsoft MVP - Visual Basic

mghiassi19-Mar-07 8:41

mghiassi

19-Mar-07 8:41

I wrote this code
<asp:gridview id="GridView1" runat="server" allowpaging="True" autogeneratecolumns="False"
="" backcolor="#CCCCCC" bordercolor="#999999" borderstyle="Solid" borderwidth="3px" cellpadding="4" cellspacing="2" forecolor="Black" datasourceid="SQLDS_Select_Project">
<footerstyle backcolor="#CCCCCC">
<columns>
<asp:boundfield datafield="Number" headertext="تعداد">
<asp:boundfield datafield="Model" headertext="مدل">
<asp:boundfield datafield="Heavy" headertext="سنگین">
<asp:boundfield datafield="Kind" headertext="نوع ماشین">
<asp:boundfield datafield="Number_M" headertext="تعداد فعال در پروژه">
<asp:boundfield datafield="Title" headertext="عنوان پروژه">
<asp:boundfield datafield="Row" headertext="ردیف" readonly="True">

<rowstyle backcolor="White">
<selectedrowstyle backcolor="#000099" font-bold="True" forecolor="White">
<pagerstyle backcolor="#CCCCCC" forecolor="Black" horizontalalign="Left">
<headerstyle backcolor="Black" font-bold="True" forecolor="White">

<asp:sqldatasource id="SQLDS_Select_Project" runat="server" connectionstring="<%$ ConnectionStrings:SamanMohitConnectionString %>"
selectcommand="Select_Project" selectcommandtype="StoredProcedure">
<selectparameters>
<asp:parameter defaultvalue="Farsi" name="F_Language" type="String">

and in .aspx.vb i write this code
Protected Sub Page_Load(Parameters)
GridView1.DataBind
End Sub

Re: How can I bind data to a database

Dave Kreskowiak19-Mar-07 8:46

OLEDb provider for Sybase on Framework 1.1

19-Mar-07 8:46

What code? This is HTML. There's nothing here that calls any kind of database.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Muhammad Nauman Yousuf17-Mar-07 6:07

Muhammad Nauman Yousuf

17-Mar-07 6:07

Hi,

I am have to use Sybase database in my appliction.
Is there any way to use it without installing ODBC Driver on each machine, I mean like is there any way to directly connect to Sybase by imporing a reference dll or something.

Thank you!

"Mess with the Best, Die like the rest"

Re: OLEDb provider for Sybase on Framework 1.1

Dave Kreskowiak17-Mar-07 7:30

Re: OLEDb provider for Sybase on Framework 1.1

17-Mar-07 7:30

Well, you could TRY to use the OleDb methods, but they're not going to support SyBase the best since they're kind of "generic". Other than that, you have no choice but to install the driver, or use a different database, like SQL Server or Access, that comes with the drivers already installed.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Muhammad Nauman Yousuf18-Mar-07 9:22

Muhammad Nauman Yousuf

18-Mar-07 9:22

If now OleDb wht other choice do i have, since i am using a IVR system that only deployes Sybase as their database.

Thank You!

"Mess with the Best, Die like the rest"

Re: OLEDb provider for Sybase on Framework 1.1

Dave Kreskowiak18-Mar-07 12:01

How to browse Active Directory from VB.Net

18-Mar-07 12:01

M. Nauman Yousuf wrote:
since i am using a IVR system that only deployes Sybase as their database.

The only other choice you have is to install the drivers.

Dave Kreskowiak
Microsoft MVP - Visual Basic

®ol@nd17-Mar-07 4:25

17-Mar-07 4:25

I'm trying to create an application where i can browse the Active Directory OU folder structure. I need to select an OU and need the OU name for a next action in the application.

Any help is welcome.

Roland

[Message Deleted]

Mudsoad17-Mar-07 7:25

Mudsoad

17-Mar-07 7:25

[Message Deleted]

®ol@nd17-Mar-07 9:26

17-Mar-07 9:26

Already found some information like this below, but it doesn't show any results:

mports System
Imports System.DirectoryServices
Public Class Form1

Class DirLister

Shared Sub Main(ByVal args() As String)

Dim enTry As DirectoryEntry = New DirectoryEntry("LDAP://192.168.1.1")
Dim mySearcher As DirectorySearcher = New DirectorySearcher(enTry)
mySearcher.Filter = ("(objectClass=computer)")

Dim resEnt As SearchResult
For Each resEnt In mySearcher.FindAll()
Form1.Text = (resEnt.GetDirectoryEntry().Name.ToString())
Next

End Sub
End Class

Mudsoad17-Mar-07 21:36

Mudsoad

17-Mar-07 21:36

Replace this line :
Dim enTry As DirectoryEntry = New DirectoryEntry("LDAP://servername/DC=DCNAME, DC=local")

hopes it helps,
Wachill

Signature has been encrypted

®ol@nd18-Mar-07 2:07

18-Mar-07 2:07

That didn't work either, i also changed it after your suggestion into:

Imports System
Imports System.DirectoryServices
Public Class Form1
Class DirLister

Shared Sub Main(ByVal args() As String)

Dim enTry As DirectoryEntry = New DirectoryEntry("LDAP://mydomain.local/RootDSE")
Dim mySearcher As DirectorySearcher = New DirectorySearcher(enTry)
mySearcher.Filter = ("(objectClass=computer)")

Dim resEnt As SearchResult
For Each resEnt In mySearcher.FindAll()
Form1.Text = (resEnt.GetDirectoryEntry().Name.ToString())
Next

End Sub
End Class

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub
End Class

Do i forgot something? I just want to test this with display the results at my empty form and work from there with the results.

Roland

Mudsoad18-Mar-07 5:15

Mudsoad

18-Mar-07 5:15

Can you tell me what is not working correctly. Is it that you are not getting the required results or that you are getting an error message.

Signature has been encrypted

Dave Kreskowiak18-Mar-07 5:47

18-Mar-07 5:47

Ummm... To be frank, you're copying and pasting code that you don't understand at all, and I'm not talking about the directory searching code. It's this

Form1.Text = blah, blah, blah

in int your Main. The search code may actually be working, but since you put all this in the Main method, before the form even shows on the screen, you'll never see the results. And, the Text property of the Form just changes the TitleBar text. It doesn't show up in the form itself.

Get rid of Main method and move it into the Form_Load event. Add a ListBox to the Form and expand it to cover the form. Then change the code in the Form_Load event:

Dim enTry As DirectoryEntry = New DirectoryEntry("LDAP://your AD server/AD path to search")
Dim mySearcher As DirectorySearcher = New DirectorySearcher(enTry)
mySearcher.Filter = "(objectClass=Computer)"
 
Dim resEnt As SearchResult
For Each resEnt In mySearcher.FindAll()
    ListBox1.Items.Add(resEnt.GetDirectoryEntry().Name)
Next

Dave Kreskowiak
Microsoft MVP - Visual Basic

®ol@nd18-Mar-07 8:47

18-Mar-07 8:47

Thank you, i got it working with your supplied code. Just need some finetuning now, but this is working.

Roland

®ol@nd18-Mar-07 9:52

Re: How to browse Active Directory from VB.Net [modified]

18-Mar-07 9:52

I also got i working with a treeview and a OU list. I changed:

ComboBox1.Items.Add(resEnt.GetDirectoryEntry().Name)

into:

TreeView1.Nodes.Add(resEnt.GetDirectoryEntry().Name)

The problem now is that i only see a list of OU's and not into a real treeview.

So i see:

OU1
OU2
OU3
OU1a
OU1b

Instead of:
- OU1
- OU1a
- OU1b

etc.

How can i get this working?

Roland

Dave Kreskowiak18-Mar-07 11:54

18-Mar-07 11:54

Your searching the entire subtree under the starting container. Don't.

The trick is to populate only the top level of the treeview, putting a dummy child under each leaf so you get the little plus sign next to it. Upon the user clicking each node, you have to requery AD to get the containers under that particular node, and fill in the nodes under the node that was clicked.

Didn't think this was going to be that complicated, did you?

-- modified at 17:59 Sunday 18th March, 2007

Dave Kreskowiak
Microsoft MVP - Visual Basic

®ol@nd25-Mar-07 7:23