Visual Basic

Re: Icons and Images for VB forms

17-Oct-07 5:28

sure

http://www.planeticons.com/[^]

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Mark Cabbage17-Oct-07 12:54

Mark Cabbage

17-Oct-07 12:54

Thanks however I'd prefer more basic onces than these. I'd also prefer NOT to get a second mortgage on the house for a few images.

Surely there are some basic icons / collections we can download for free......

Lost my post

~V~17-Oct-07 1:40

~V~

17-Oct-07 1:40

Hi
Last month i posted a question in this site, i don't know how to see my post Sleepy | :zzz:

Plz help me! Rose | [Rose]

Re: Lost my post

ChandraRam17-Oct-07 1:42

ChandraRam

17-Oct-07 1:42

Click on the image next to your user name, it should take you to your profile page. On that, you have a link to "Messages posted".

Re: Lost my post

Steven J Jowett17-Oct-07 1:45

Steven J Jowett

17-Oct-07 1:45

Use the 'Search Comments' option above, which has filters by date range, keywords and Author

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

Re: Lost my post

~V~17-Oct-07 2:42

~V~

17-Oct-07 2:42

I m greatful to both of you Rose | [Rose]

Thanks

Change Debug Level to 0

matjame17-Oct-07 0:52

matjame

17-Oct-07 0:52

Hello guys.

I have an error on my page from something I downloaded and the message says "To avoid this message, change ur EO.Web.Runtime.DebugLevel to Zero".

I have found the EO.Web.Runtime.DebugLevel but it says DebugLevel() as Integer and dont know how to change it to Zero.

Please help guys.Thanx in advance.

kagiso

Re: Change Debug Level to 0

Dave Kreskowiak17-Oct-07 6:52

Dave Kreskowiak

17-Oct-07 6:52

Is this a library you downloaded from somewhere?? I think you're going to have to ask the people who wrote the library you're using.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Unable to connect to Active Directory via SSL using VB.net

Daniel Chew16-Oct-07 22:40

Daniel Chew

16-Oct-07 22:40

I am trying to connect to an Active Directory via secure socket.

Below are my codes.

Dim adConnection As String

adConnection = "LDAPS://cisdcccc.ccccccc.eee.mmmmm.com.mm/dc=cccccc,cd=eee,dc=mmmmm,dc=com,dc=yy"

Dim entry As New System.DirectoryServices.DirectoryEntry(adConnection, "username", "password",
DirectoryServices.AuthenticationTypes.SecureSocketsLayer)

Dim searcher As New System.DirectoryServices.DirectorySearcher(entry)

searcher.SearchScope = DirectoryServices.SearchScope.OneLevel

The exception that gets thrown is

Stack Trace:

[COMException (0x80005000): Unknown error (0x80005000)]
System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) +610
System.DirectoryServices.DirectoryEntry.Bind() +36
System.DirectoryServices.DirectoryEntry.get_AdsObject() +31
System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne) +73
System.DirectoryServices.DirectorySearcher.FindOne() +42
_Default.Page_Load(Object sender, EventArgs e) +82
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

The port 636 is open. I am unable to understand what is causing this problem.

Please help.

Thanks.

Re: Unable to connect to Active Directory via SSL using VB.net

Dave Kreskowiak17-Oct-07 15:16

Dave Kreskowiak

17-Oct-07 15:16

I hope you copied and pasted this code and not retyped it. One of your dcs in the string is mistyped as cd.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Unable to connect to Active Directory via SSL using VB.net

Daniel Chew17-Oct-07 16:21

Daniel Chew

17-Oct-07 16:21

Thanks.

I have changed it but it is still throwing the same exception. Confused | :confused:

Xml scchema and data tables

JonCox16-Oct-07 22:35

JonCox

16-Oct-07 22:35

Hi, i am currently trying to get to grips with creating a data table in VB.Net (visual studio 2003), however after creating the schema, I try to creat the data table but as soon as I conect the schema to the xml file I get an error report stating the schema does not support the root function Frown | :(

I have very little knoledge about this and I am just learning the language, please can anyone help?

Thank you.

Re: Xml scchema and data tables

Dave Kreskowiak17-Oct-07 15:14

Dave Kreskowiak

17-Oct-07 15:14

JonCox wrote:
I try to creat the data table but as soon as I conect the schema to the xml file

What do you mean by this?? Did you already have an XML file and then try and create a schema to match it??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

SQL Check if a record exists

The ANZAC16-Oct-07 22:00

16-Oct-07 22:00

Look...i'm really not good with sql since i don't do it that often...can someone please give me a really dumbed down answer so i understand. I am sorta just getting into using sql.

How do i check if a record exists, i need to know everything, i have a table called users. When a user puts a username in a textbox, how do i check if a record exists with there user name.

Please check out my articles:
The ANZAC's articles

Tom Deketelaere16-Oct-07 22:38

Tom Deketelaere

16-Oct-07 22:38

just put it in the where clause and check if you get a record back:

sql: select username from users where username='me'

then you just check you'r datareader/adapter if there is a record in it
if so the user exist of not the user doesn't exist

hope this helps

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

The ANZAC17-Oct-07 0:08

17-Oct-07 0:08

i appreciate the help, but i am not at all database experienced and to me this is extremely vague, i'm seriously like a lost sheep when it comes to this, you need to be really detailed for me. thanks though.

Please check out my articles:
The ANZAC's articles

Vimalsoft(Pty) Ltd16-Oct-07 22:47

16-Oct-07 22:47

HI The ANZAC

Follow me. Lets say i have a textbox in my form and i want to see if there is a user name that Exist in my table "Users", and am using VB.NET. the First thing is to set up the adapter. you must tell the adapter that you going to Accept inputs from users. e.g

SELECT  USERS FROM MYTABLE WHERE (USERNAME = @USERNAME)

When you are done with that create a dataset and Fill your dataset with Data like this.

myadapter.Fill(mydataset)

After that , you need to call this from your form.
in your form put in a Button , call it "btnSearch", and in the button click event write the Following code.

try

myadapter.SelectCommand.Parameters("@Username").Value = txtUsername.Text
            mydataset.Clear()
           myadapter.Fill( mydataset, "MYTable")
            If mydataset.Tables("MYTable").Rows.Count = 0 Then
                MessageBox.Show("The USERNAME does not Exist in the Database you can Continue Add it", "Info", MessageBoxButtons.OK)
            Else
                MessageBox.Show("The Property Exist in the Database, you cannot Add this liskey", "Error", MessageBoxButtons.OK)
            End If
        Catch ex As SqlClient.SqlException
            MessageBox.Show(ex.Message)
        End Try

Hope this Helps, if doesnt TEll me

The ANZAC17-Oct-07 0:04

17-Oct-07 0:04

This is helping, but where do i put that select statement, i am really new to this.

Please check out my articles:
The ANZAC's articles

Vimalsoft(Pty) Ltd17-Oct-07 0:24

17-Oct-07 0:24

i suggest you use the Wizard for now, as you are new. drag an Adapter from your ToolBox, The wizard will popin and Click next, if you have no Connection create a new one, if you are using Access as a Backend choose JET4 provider and select where the database is and test the connection. after that right click on the adapter and choose Configure the adapter --> and you will see that database had been selected and click next-->:Choose the First Opttion "Use SQl statement", ---> Next this Part its where you put your SQL statement, after that you will click next, all neccessary command statement will be generated for Update, select and Delete and Click Finish

hope it Helps

The ANZAC17-Oct-07 0:49

17-Oct-07 0:49

This has helped. I managed to do it slightly different..in that it counts the amount of users which have the same name as the above.

select count(*)

Please check out my articles:
The ANZAC's articles

Vimalsoft(Pty) Ltd17-Oct-07 1:41