Community > Computers & Technology

Post Reply
Topic: Visual Basic 2005 and SQL
the_wizard67's photo
Thu 11/20/08 11:34 AM
Anyone here any good at dealing with basic databases with VB?
ksrover's photo
Mon 12/08/08 07:31 PM
I'm primarily PHP/ASP and Transact but have some experience with VB.net. Anything in particular?
no photo
Mon 12/08/08 07:34 PM
I know a wee bit but I have some books that I can look stuff up in. I was never very good at SQL though

I'm more of a Matlab and Labview user
the_wizard67's photo
Mon 12/08/08 10:13 PM
That's all cool, I was trying to figure out how to pull two fields out of a database and compare them to user inputs, but I figured it out. Now I am trying to implement all that I have into a website. I am trying to use ASP, but have never used it before. I do have a question about ASP that y'all might know the answer to.

If I am using just a basic template, how do I associate a text box to a value that I have stored for a variable? It is pretty easy with VB, but I don't know if I am just not using the right extensions or if it is just completely different. I picked up a couple of books today, but I haven't had time to look at them yet. I would apprieciate any help at any rate.
BrettBrett's photo
Wed 12/10/08 12:59 AM
I'm assuming you're refering to ASP.NET and VB.NET

datasets were a bit of a change up of how programmers structured data manipulation. Most people praise the concept, but it hasn't really been a new concept since implemented before 2003 edition. I'm glad you have it down.

It's important to know how you want this value changed,

server-side (IE runat="server", that the server will execute using a codepage or 'codebehind')

or

client-side (a script of some sort, that the client browser will execute)

' Server-Side:

<asp:textbox id="mytextbox" value="" runat="server">

' .:codebehind:.

Class myClass
Inherits System.Web.UI.Page

Protected Sub mytextbox_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles mytextbox.Load
mytextbox.Text = "BrettBrett"

End Sub
End Class



says that when the asp.net control, named mytextbox, is loaded by the server, it will change the value (.text) of that control to "BrettBrett"

' Client-Side:
...
</head>
<script type="text/ecmascript">

function MyFunction(document)
{
MyTextInput.value = "BrettBrett"
}

</script>

<body onload='MyFunction(document)'>

<input type='text' id="MyTextInput" />
...


This doesn't involve any asp.net or vb.net codebehind.

It is simply ECMAscript and an HTML input tag
the_wizard67's photo
Fri 12/12/08 09:36 PM
ok, let me ask a different question. I am using ASPX and don't really understand how to bind a database like Access so that I can pull in information into difference list boxes and combo boxes. I think that I am going to start a new thread for this, but I welcome any help that I can get.

Community > Computers & Technology

Post Reply