Visual Basic

Re: VB-Access: Syntax error in INSERT INTO command

3-Aug-09 11:17

I am guessing you need to provide the adapter with an insert statement ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Paramu19733-Aug-09 21:16

Paramu1973

3-Aug-09 21:16

Here I used ACE.OLEDB.12.0. for office 2007-Access [accdb] But I want you to use Jet.Oledb for office 2003-Access [mdb]

Dim Ithuva As String = "Samples To Aman"

con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\sample1.accdb;Persist Security Info=False")
con.Open()
Dim CmdTxt As String = "Insert into address (city) values ('" & Ithuva & "')"
Dim cmd As OleDbCommand = New OleDbCommand(CmdTxt, con)
cmd.ExecuteNonQuery()
con.Close()

Re: VB-Access: Syntax error in INSERT INTO command

Hristo-Bojilov4-Aug-09 7:34

Hristo-Bojilov

4-Aug-09 7:34

Do you have any primary keys defined for the underlying table?
If you don't OleDbCommandBuilder will not work.

List all active windows

NewbieDave3-Aug-09 10:02

NewbieDave

3-Aug-09 10:02

I am trying to find a program in Visual Basic that will list all open windows on a computer. I am trying to activate a window based on it's title bar. I've looked up EnumWindows and GetWindow for examples but I am running into problems with the code I find (it doesn't work). I'd like to find some code that does. I have a intranet website that shows customer info and i'd like to activate a window based on the number they called. I want to call this program with a variable that will bring a window to the forefront based on that variable. Any help you provide would be most appreciated.

Thanks for all the help
NewbieDave

Christian Graus3-Aug-09 10:32

3-Aug-09 10:32

I don't know that you can enumerate windows on a client, from the server.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Dave Kreskowiak3-Aug-09 10:36

3-Aug-09 10:36

You cannot enumerate windows on a client machine from a web server.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Christian Graus3-Aug-09 10:44

3-Aug-09 10:44

I did note he was saying it was on an intranet, that's why I assumed he may not be totally insane. But, even then, I'm pretty sure he can't do it.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

NewbieDave3-Aug-09 11:05

NewbieDave

3-Aug-09 11:05

We just installed the Cisco Unified communications system and we can have a web display that shows customer info based on thier phone number. I'd like the end user to have a dual monitor setup so that the customer info shows up on one screen (web display) and on the other would be a windows program for entering info about the customer. So it sounds like I'd have to have my program resident on the users computer, pass the program the customer info then populate the web display from the program while it also enumerates the correct program. Does that sound possible?

Thanks for all the help
NewbieDave

Christian Graus3-Aug-09 11:17

Object disposed when trying to assign column width

3-Aug-09 11:17

It sounds like you want to not use the web at all, and just write a program that runs over the internet.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Hypermommy3-Aug-09 9:27

Hypermommy

3-Aug-09 9:27

Hi all,

I have a datagridview on a form. I have a subroutine called LoadReloadProcs that has this line in it

Me.dgvProcs.Columns(0).Width = Me.dgvProcs.Width * 0.75

This is the line where the error's happening. I'm getting an objectdisposed error.

Funny thing is, it'll run through this routine twice without reporting an error. It only reports the error when I come back from running a report. Also, if I put a breakpoint right there and use the immediate window to check the value of the width (i.e., ? dgvProcs.Columns(0).Width) the system tells me that it is 100. But if I try to assign a value to the width (i.e., in the immediate window dgvProcs.Columns(0).Width = 435) the system throws the object disposed error.

Why would I be able to request information of an object that is disposed? I shouldn't be able to, right? Or if it is not disposed, which being able to query the value of something suggests, why can't I assign a value to that property?

This has me really confused.

I've put the code for the procedure below... I don't see anything in there that helps me understand, but I figured one of y'all might. Also, I've searched for "dgvProcs.dispose" and just for ".dispose" and didn't find any relevant to dgvProcs.

 Private Sub LoadReloadProcList(ByVal strsql As String)
        Try
            'Me.Controls.Remove(dgvProcs)
            Dim daMyList = New SqlCeDataAdapter(strsql, myDB.cn)
            Dim dsMyList = New DataSet
            daMyList.Fill(dsMyList)
            Dim myBinding As New BindingSource
            myBinding.DataSource = dsMyList
            Me.dgvProcs.DataSource = myBinding
            Me.dgvProcs.DataMember = "Table"
            Me.dgvProcs.Columns(0).HeaderText = "Name"
            Me.dgvProcs.Columns(0).Width = Me.dgvProcs.Width * 0.75
            Me.dgvProcs.Columns(1).HeaderText = "Barcode"
            Me.dgvProcs.Columns(1).Width = Me.dgvProcs.Width * 0.15
            Me.Controls.Add(dgvProcs)
        Catch ex As Exception
#If DEBUG Then
            MsgBox(ex.Message)
#Else
            MsgBox("There was a problem gathering information on your previous procedures.  If this problem persists please contact your distributor.")
#End If
        End Try
    End Sub

Thanks in advance for any help you can give.

Denise "Hypermommy" Duggan

Re: Object disposed when trying to assign column width

Dave Kreskowiak3-Aug-09 10:33

Re: Object disposed when trying to assign column width

3-Aug-09 10:33

You have a DataGridView on your form that YOU called dgvProcs. So, obviously searching the Internet for a name that you made up is going to be pointless.

The error message says that you destroyed the dgvProcs object and now you're trying to use it. The line that you commented out in your code snippet would do that if it wasn't commented out before. Me.Controls.Remove(dgvProcs) would detroy the dgvProcs object.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Hypermommy3-Aug-09 10:48

Hypermommy

3-Aug-09 10:48

I'm not so confused that I searched the internet for dgvProcs. I searched the code. Sorry I didn't make that clearer... I guess I just figured it was obvious.

And yes, if that line weren't commented out I can see that it would do it. But that line's been commented out the whole time and I'm still getting the error. It's really wierd.

Denise "Hypermommy" Duggan

Re: Object disposed when trying to assign column width

Dave Kreskowiak3-Aug-09 16:21

Re: Object disposed when trying to assign column width

3-Aug-09 16:21

No, there could be no more references holding on to it.

The other thing, that i didn't see earlier, is possibly the columns being wiped out and rebuilt after the data bind.

And, of course, the possibility of having to Clean the project, then rebuild.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Hypermommy3-Aug-09 23:03

Hypermommy

3-Aug-09 23:03

Clean the project and rebuild? I'm afraid I don't understand. There's still a lot of tools in Visual Studio that I'm learning... is "clean" one of them?

I do appreciate the assistance, believe me!

I ended up finding a workaround... I noticed that if I clicked OK on the messagebox that informed me of the error, the system went on ahead and built everything and all looked and acted okay. So what I did was just put a separate catch block in there to catch just the object disposed exception and swallow it up and ignore it. That done, everything appears to work fine. Of course, the "solution" makes me a bit nervous as ignoring exceptions is probably not the safest thing to do.....

But maybe it gives a clue to one of you gurus that says what's going on... 'cause this is still too weird to me.

Denise "Hypermommy" Duggan

Re: Object disposed when trying to assign column width

Luc Pattyn3-Aug-09 10:50

Luc Pattyn

3-Aug-09 10:50

Hi Dave,

Dave Kreskowiak wrote:
Me.Controls.Remove(dgvProcs) would detroy the dgvProcs object

I'm not with you here. Who would be doing the Dispose?

Are you saying ControlCollection.Remove(x) actively calls x.Dispose()?
(I can't see that in the doc)

or x being removed becomes collectible? from the code dgvProcs is a class member, so this reference is still alive.

Couldn't the problem be that by setting a new DataSource the Columns[] collection got lost?

Confused | :confused:

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

CustomPanel: MenuStrip and Panel

eusta3-Aug-09 9:13

eusta

3-Aug-09 9:13

Hello everyone,

I have a UserControl, I inserted inside a MenuStrip and a Panel.
This UserControl must be a Panel, when do I upload controls, inserted controls, must be entered panel I inserted in the usercontrol. Big Grin | :-D

Sorry for my poor English, I hope my problem is clear.

Thank you Smile | :)

Re: CustomPanel: MenuStrip and Panel

Dave Kreskowiak3-Aug-09 10:30

Re: CustomPanel: MenuStrip and Panel

3-Aug-09 10:30

eusta wrote:
I hope my problem is clear.

Not in the slightest. I have no idea what you're trying to say.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

eusta3-Aug-09 12:30

eusta

3-Aug-09 12:30

This is more intuitive Smile | :)

http://img338.imageshack.us/img338/213/usvbnet.png

Thank you

Re: CustomPanel: MenuStrip and Panel

Dave Kreskowiak4-Aug-09 15:36

Problem Inserting Blob Datatype image into MySQL

4-Aug-09 15:36

No, it's not... I still have no idea what your on about.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

wr30283-Aug-09 7:45

wr3028

3-Aug-09 7:45

Hi,

I am new to VB.Net and i am working on School Management project in VB.Net windows application. In that i need to insert the Images of the Students. So i am trying using BLOB Datatype in MySQL, but i am unable to store the image and also the saved image should be retrieved.

So, Please if any one knows the solution of my problem help me and do me the favour.

Thanks in advance,
Victoria

VB.Net

Re: Problem Inserting Blob Datatype image into MySQL

Dave Kreskowiak3-Aug-09 8:11