Re: Databases - Visual Basic Discussion Boards

First Prev Next

Re: add

User 171649231-Jul-06 4:43

User 1716492

31-Jul-06 4:43

Read this beginner tutorial
http://www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp[^]

more tutorials here
http://www.codeproject.com/info/search.asp?cats=2&cats=3&cats=4&cats=5&cats=6&searchkw=ADO.net&Submit1=Search&author=&sd=15+Nov+1999&ed=31+Jul+2006[^]

modified 1-Aug-19 21:02pm.

Re: add

kyosugi31-Jul-06 6:05

kyosugi

31-Jul-06 6:05

thx for the links ^^
tried them out n still tryin to understand
kinda got a prob since i'm using vb 2005 express edition and cant open the source files to take a look at the examples
noe where can i get examples for using vb software?
sry fer da trouble. been looking but cant find yet.
saw da ultimate grid ad at the side n kinda looking into it.

Re: add

Kevin McFarlane31-Jul-06 6:17

Kevin McFarlane

31-Jul-06 6:17

See http://msdn.microsoft.com/vbasic/learning/introtovb2005/[^]

Kevin

Re: add

User 171649231-Jul-06 14:23

User 1716492

31-Jul-06 14:23

As far as I recall, the Code Project tutorial I referenced was written with C#.

Use "VB.NET and C# Comparison" cheat sheet from (I think) www.harding.edu[^] but in case it wasn't, Google for it.

This should help you to understand what is happening in both C# and VB.net, but as you are just learning, consider downloading the Microsoft PDF e-book that is available to registered users of vb.net 2005 Express Edition.

Also, you might like to get a copy of "VB.NET Fundamentals" from http://www.pdsa.com/[^] this is a free e-book that comes with source code. As I understand, you are required to register with them before they let you have a copy to download.

modified 1-Aug-19 21:02pm.

Re: add

kyosugi31-Jul-06 21:30

kyosugi

31-Jul-06 21:30

ok, thx a lot

Databases [modified]

Nolin31-Jul-06 3:50

Nolin

31-Jul-06 3:50

Hi.
I need your help please

how do i connect a mircosoft access database into my forms. And wat code do i use to save the data entered into the database. And edit code for editing information.And the search code.how do i link the textboxes with the fields in the database.

Could you supply me with code

I need help please please

Kind Regrds

Nolin

-- modified at 8:42 Tuesday 1st August, 2006

Re: Databases

Tyquaun Hunter31-Jul-06 9:28

Tyquaun Hunter

31-Jul-06 9:28

what database exactly?

Re: Databases

Werries31-Jul-06 11:35

Werries

31-Jul-06 11:35

Hi there.

If you use an Access database here is an example on how to use it.

First add a reference to ADODB.dll

Declare database connection varaible as follow:

Private cnDatabase As ADODB.Connection

Open the database. Note that the DatabaseName must be the full path of the database.

cnDatabase = New ADODB.Connection
cnDatabase.Open(DatabaseName)

Fetch data from the Database:

Dim rsRecord As New ADODB.Recordset
Dim strSql As String
Dim tempValue As Object

strSql = "SELECT * FROM " & TableName

rsRecord.Open(strSql, cnDatabase)

With rsRecord
If Not .EOF Then
tempValue = .Fields("FieldName").Value
End If

.Close()
End With

rsRecord = Nothing

Save data to the database:

Dim rsRecord As New ADODB.Recordset
Dim strSql As String

strSql = "SELECT * FROM " & TableName

rsRecord.Open(strSql, cnDatabase, ADODB.CursorTypeEnum.adOpenKeyset,
ADODB.LockTypeEnum.adLockOptimistic)

With rsRecord
.AddNew()

.Fields("FieldName").Value = YourValue

.Update()

.Close()
End With

rsRecord = Nothing

Hope this wil help you.

A programmer's life is good... or is it?? Ek dink nie so nie!

Return String from C to VB

MohammadAmiry31-Jul-06 3:33

MohammadAmiry

31-Jul-06 3:33

Hi I want to send a string (LPSTR) or any other type from C to VB6 from a dll. It causes vb to crash.
How should I do it? I have no problem sending numbers....
Thanks

ComboBox MouseMove

tibmark31-Jul-06 2:56

tibmark

31-Jul-06 2:56

How can I track the mouse movements when the combobox has dropped down. The mousemove event does not fire after the combobox has dropped for selection.I want to know what item the mouse is over?

Mark Thibodeaux

Re: ComboBox MouseMove

Tyquaun Hunter31-Jul-06 9:30

Tyquaun Hunter

31-Jul-06 9:30

vb or vb.net?

Re: ComboBox MouseMove

tibmark31-Jul-06 12:05

tibmark

31-Jul-06 12:05

vb.net

Mark Thibodeaux

Orgnisional structure [modified]

Sinchan Nikam31-Jul-06 2:07

Sinchan Nikam

31-Jul-06 2:07

I have developed one software.
In that I want to represent my data in an organisational structure.
Or hierarchical diagram.
I am using VB6.0 and SQL server as my platform.
Please help me

-- modified at 9:57 Monday 31st July, 2006

Return Parameter in ADO.NET

Carlos Paiva31-Jul-06 2:02

Carlos Paiva

31-Jul-06 2:02

Hi all

I'm moving an VB6 app to .NET and i'm faced with the following problem:

Having the following stored procedure in SQL SERVER 2000, that returns a dataset (Read only) AND has an OUTPUT parameter at same time, which of the command methods should i use, since it seems that ExecuteReader (Thats seems to be the only that returns a rowset) doesnt update the OUTPUT parameter.
Im I missing something?, Is there Any work Around?

'==============================================================================
ALTER PROCEDURE spGetResourceText (@frmName varchar(20),@MaxIndex int OUTPUT)
AS
SET NOCOUNT ON

SELECT @MaxIndex = Max(Id) FROM tblResourceText WHERE frmName = @frmName
SELECT * FROM tblResourceText WHERE frmName = @frmName

RETURN
'==============================================================================

Thanks in advance for your time!
Carlos Paiva

Re: Return Parameter in ADO.NET

Carlos Paiva31-Jul-06 3:12

Carlos Paiva

31-Jul-06 3:12

Sorry, I've post in the wrong place.
Repost in ADO.NET messageboard!

Thanks
Carlos Paiva

Re: Return Parameter in ADO.NET

akchandru31-Jul-06 5:23

akchandru

31-Jul-06 5:23

Carlos,

I hope you want to receive 2 result sets. So you can use DataSet for executing your SQL procedure. Normally Dataset return result sets as Tables.

So from the above, you will get 2 tables, you can written the code like below and retrieve both the resultsets,

Dim DA As New SqlDataAdapter
Dim DS as new Dataset

DA.SelectCommand = {pass your Command object}
DA.Fill(DS)

dim intMaxIndex as integer
intMaxIndex = DS.Tables(0).Rows(0).Item(0)

For intIndex = 0 To DS.Tables(1).Rows.Count - 1
{within this loop you can get each record/field values by
DS.Tables(1).Rows(intIndex).Item({field name})}
Next

Best Regards,
:-OChandru Blush | :O

Find Function? [modified]

Harold_Wishes31-Jul-06 1:33

Harold_Wishes

31-Jul-06 1:33

Hello, I am new to VB and need help on a specific question.

I need to know if there is a find function in VB so that I can terminate a loop. Example, suppose I need to find all tildas (~) in a file from start to finish in MS-Word. I would like to use a find function (if it exist) in my test condition so that the program exits the loop when the last tilda is found. Below is a for loop that I hard coded to repeat so many times but I would prefer doing it a better way. Help is appreciated.

Sub test()
'
' test Macro
' Macro recorded 7/30/2006 by Harold-Wishes
'
    Selection.Find.ClearFormatting
    For Counter = 1 To 20
    
    With Selection.Find
        .Text = "'"
        .Replacement.Text = "'"
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    Selection.Find.Execute
    Selection.TypeText Text:="'"
    Next
End Sub

-- modified at 7:36 Monday 31st July, 2006

Re: Find Function?

Tyquaun Hunter31-Jul-06 7:00

Tyquaun Hunter

31-Jul-06 7:00

Try exit sub

Tyquaun

Re: Find Function?

Harold_Wishes31-Jul-06 7:30

Harold_Wishes

31-Jul-06 7:30

Hello,

Could you clarify?
I would like to remove the code below and have the loop stop when the last tilda is found. Currently I have it set to loop twenty times.

For Counter = 1 To 20

I know there is some boolean function for find, but I'm not getting the syntax correct.

Re: Find Function? [modified]

Tyquaun Hunter31-Jul-06 9:27

Tyquaun Hunter

31-Jul-06 9:27

Try using regular expression. Once your value has been found exit the loop. Here is an article in MSDN

http://support.microsoft.com/default.aspx?scid=kb;en-us;818802[^]

-- modified at 15:27 Monday 31st July, 2006

javasript problem using vb.net

jimsharma31-Jul-06 1:16

jimsharma

31-Jul-06 1:16

hi friends
please tell me custom control min,max,close button of browser through script
if possible then send code if no then why i am using vb.net script javascript
keep in touch
byee
Regards
Irvendeep

Re: javasript problem using vb.net

Guffa31-Jul-06 3:02

Guffa

31-Jul-06 3:02

You can't minimize a window using Javascript.

You can't maximize a window using Javascript. The closest is to set the window size to be the same as the screen size. Off the top of my head, something like: window.moveTo(0,0);window.resizeTo(screen.x, screen.y);

Use window.close(); to close the window.

---
b { font-weight: normal; }

how to check the check box programatically in vb..?

Ron.S31-Jul-06 0:51

Ron.S

31-Jul-06 0:51

hi there
i am trying to check the checkbox through program .. can any one please help me .. thanks in advance..

bharath.s

Re: how to check the check box programatically in vb..? [modified]

TDSp31-Jul-06 1:14

TDSp

31-Jul-06 1:14