DataRelation - Visual Basic Discussion Boards

Anonymous5-Jul-04 1:52

5-Jul-04 1:52

Hi,

i try to insert values to a Access DB from VisualBasic .All the fields are TEXT datatype.For null values i assign vbNullChar(also i tried with vbNull).

Insert statement is:
con.Execute "Insert INTO " & TableName & " (" & tempFields & ") VALUES (" & tempInputs & ")", 1, 1

tempFields & tempInputs are arrays.

But some how the insert fails with the error:
Error :

Desc: "[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement."
Number : -2147217900
source : "Microsoft OLE DB Provider for ODBC Drivers"

Pls help
Ram

Re: INSERT Fails

Hesham Amin5-Jul-04 4:56

Hesham Amin

5-Jul-04 4:56

insert does not work with arrays.
create a command object
OR :
specify each field by its own like :

Insert INTO TableName (Filed1,Filed2,Filed3)<br />
values (val1,val2,val3)

and ignore nullable fields.

Re: INSERT Fails

Dave Kreskowiak6-Jul-04 3:37

Dave Kreskowiak

6-Jul-04 3:37

The best way to go about that is to create a command object with your SQL statement, but use parameters in the appropriate places.

Dim sqlString As String = "INSERT INTO MyTable (Field1, Field2, Field3) VALUES (?, ?, ?)"
Dim comm As New OleDbCommand(sqlString)

comm.Parameters.Add("@Field1Value", OleDbType.VarChar, 80).Value = somevalue
comm.Parameters.Add("@Field2Value", OleDbType.VarChar, 80).Value = somevalue
comm.Parameters.Add("@Field3Value", OleDbType.VarChar, 80).Value = OleDbType.Empty

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

vb.net and forms

mrdance4-Jul-04 21:20

mrdance

4-Jul-04 21:20

I have some problems accessing a form when using a public sub in a module as startup object.

Module:

Friend frmMain as Friend
dim frm as new form1
frm.show
call Fill()
public sub Main

public sub Fill
frmmain.text = "ok"
end sub

In the form:

form1_load

frmmain = me

I am doing something/somethings wrong. I want to be able to reach this form after creating it like altering the caption in sub Fill. Any ideas how I do this?

thanks / Henrik

end sub

--- neteject.com - Internet Solutions ---

Re: vb.net and forms

Dave Kreskowiak6-Jul-04 3:49

Dave Kreskowiak

6-Jul-04 3:49

Well, the code you posted won't even compile. Try copying and pasting next time. The code frmMain = me doesn't do anything constructive at all. I don't know what you trying to do here.

First, when your Sub Main reaches the end, your app is going to quit. You have to give the form control to keep it's message pump running so your app won't quit. I assume you doing something in the Sub Main before displaying the form. This should take care of your problem.

Module Module1
    Public Sub Main()
        Dim myForm As New Form1
        Fill(myForm)
        Application.Run(myForm)
        myForm.Dispose()
    End Sub

    Private Sub Fill(ByRef form As Form)
        form.Text = "My Caption Text..."
    End Sub
End Module

But, if this is all you wanted to do, then you would create a normal Windows Forms application and put this in the Form Load Event:

Me.Text ="My Caption Text..."

or change the appropriate properties in the Property Page in the Forms Designer.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: vb.net and forms

mrdance12-Jul-04 4:55

mrdance

12-Jul-04 4:55

thanks, but what if I want to open a form from the mainform and then set myform.text. How can I do that the best and most efficient way? Should I use "Friend" and if so, how do I use that?

thanks / Henrik

--- neteject.com - Internet Solutions ---

Re: vb.net and forms

Dave Kreskowiak12-Jul-04 12:36

Dave Kreskowiak

12-Jul-04 12:36

Dim nextForm As Form2
nextForm.Text = "Set some text here..."
nextForm.Show()

You really should take a look at this[^] article on MSDN.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

DataRelation

Guerven4-Jul-04 17:50

Guerven

4-Jul-04 17:50

I have an Access table that has a parent table named TBLBooks and several tables that relating to it.

What im trying to do:
I am trying to display the TBLbooks information on a set of textboxes and display the authors on a datagrid.

What I have accomplished:
I successfully displayed the information on the textboxes and added buttons to move around the Book records. (Using BindingMAnagerBase).
I also already added a relationship into the dataset (using BookID which is present in both tables TBLbooks,TBLauthors)

I was able to display the authors on the grid but it wouldn't move with the TBLbooks (textboxes).

THE PROBLEM:
I need to show the AUthors information on my grid and is should move or change with my textboxes. I can't use Rowfilter to filter the Authors information. I really need to make the relation work. Eek! | :eek:

Is there any piece of code that you have that does just this?
*parent-child data relation with datagrid*
or ofcourse you could tell me how to do it. Laugh | :laugh:

Marvin N. Guerrero
- Casting More!!

Program help please

Anonymous4-Jul-04 8:01

Anonymous

4-Jul-04 8:01

Any one have time to help with school project? I am trying to create a random graph generator with a given proboility 0 < p < 1, probability that the edge exsist between to nodes in a graph (undirected and not weighted), using an adjacency matrix. I must then time the execution of DFS and BFS to see which perform best and show stats to prove it. I am having trouble with timing the algorithms and random generators for the graph....any ideas?

Thanks

Re: Program help please

Dave Kreskowiak6-Jul-04 3:55

Dave Kreskowiak

6-Jul-04 3:55

You never said what your problem was. But, your best source of information is going to be your prof. That's what he's there for...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

vb6 (data grid)

nazerudeen3-Jul-04 7:51

nazerudeen

3-Jul-04 7:51

how can i display only the required fields of a table in a datagrid using vb6.

Re: vb6 (data grid)

Hesham Amin4-Jul-04 0:50

Hesham Amin

4-Jul-04 0:50

Hi check Using DataGrid and data controls to access an access database[^]

Re: vb6 (data grid)

Ravi S.V.7-Jul-04 19:58

Ravi S.V.

7-Jul-04 19:58

Either u change the select statement with the required fields to be displayed in the grid
-or-
after assigning the recordset to datagrid's datasource property, make the unrequired columns width to zero.

Errors Occured

Ravi S.V.2-Jul-04 18:31

Ravi S.V.

2-Jul-04 18:31

Hi gurus,

I have a problem in programming thru VB and Oracle.
I have created a class Module thru which I am retriving Database fields
While retriving a particular Date Field, I am getting an Error 'Errors Occured' (Not for all Date Fields). When try to look Quick Watch in the value box it shows empty, if I try isnull(rs.fields(1)) it returns false, if I try isempty(rs.fields(1)) it returns false, if I try isobject(rs.fields(1)) it returns true

Please go thru it and help me

Re: Errors Occured

beowulfagate3-Jul-04 0:41

beowulfagate

3-Jul-04 0:41

Could you post the code please?

DataGrid - Please Help

viettho2-Jul-04 18:11

viettho

2-Jul-04 18:11

How do I resize the first column of datagrid control to be zero, so that it can work as ListViewItem.tag in listview control? Is there a way to hide the first column and set the with to 0?

Please help . Thanks.

Re: DataGrid - Please Help

Ravi S.V.2-Jul-04 19:24

Ravi S.V.

2-Jul-04 19:24

you can resize the grid columns:

after filling the datagrid this line is to be added

datagrid1.columns(0).width = 0

chart program

sirChris2-Jul-04 15:53

sirChris

2-Jul-04 15:53

Hello guys I am new comer in the exciting world of programming,but i learn very fast.i want to try my skill in writting a chart software,Please kindly outline the algrithm explain how to comfigure my winsocket so that at least two systems can exchange text data
thanks
chris

chris

Re: chart program

Dave Kreskowiak6-Jul-04 4:05

Dave Kreskowiak

6-Jul-04 4:05

Your question is vauge to say the least. Which is it? The chart program or winsock?

You chart question really depends on the graph your trying to make and what you want to support as far as options. Titles, axis labels, data ranges, auto scaling, log charts, line graphs, bar graphs, X/Y charts, Radar charts, ... There is no one algorithm that will encompass all of this. You really have to be more specific in what you want and do a bit of research and think about your design and what it will require before you start writing code.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

video confrence

sirChris2-Jul-04 14:41

sirChris

2-Jul-04 14:41

hi greate guys, I want to use winslock to write a program that can transfer audio and visual data btween two systems
kindly direct me on the best approch
just chris

chris

Re: video confrence

Colin Angus Mackay2-Jul-04 15:24

Colin Angus Mackay

2-Jul-04 15:24

That's a little vague. Where do you need direction? Are you already competent with Sockets, but need direction on audio and video streaming algorithms? Or do you already know about audio and video streaming algorithms, but need assistance with Sockets?

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

My Blog

Re: video confrence

sirChris2-Jul-04 16:00

sirChris

2-Jul-04 16:00

My major stress is the algorithm to streming video and audio data but i need useful tips on how to configure the socket so that everything will be alright
i am but a baby programmer still in school ,so kindly do justice to my stress
chris

chris

Re: video confrence

Colin Angus Mackay3-Jul-04 0:58

Colin Angus Mackay

3-Jul-04 0:58

Well, A quick google for Audio Compression Algorithm[^] and Video Compress Algorithm[^] turned up quite a few results.

As for Sockets, my recommendation for an introductory reference to Sockets in .NET is C# Network Programming by Richard Blum[^] I'm not sure what the VB.NET books on the subject are like - but as the core is all in the framework and not in the individual language this could still be a good reference.

Re: video confrence

Tallest4-Jul-04 2:48

Tallest

4-Jul-04 2:48

Forum Visual Basic / VB.NET
Subject: Re: video confrence
Sender: sirChris
Date: 20:41 2 Jul '04

I greate guys, I want to use winslock to write a program that can transfer audio and visual data btween two systems
kindly direct me on the best approch
just chris

chris

Re: video confrence

Un121-Aug-04 5:54

Un1

21-Aug-04 5:54

Visit avphone home:
http://www.banasoft.net/AVPhone.htm

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.