Click here to Skip to main content
15,895,084 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionExport Excel Formula Pin
ross16642-Jun-09 5:51
ross16642-Jun-09 5:51 
AnswerRe: Export Excel Formula Pin
Kschuler2-Jun-09 5:59
Kschuler2-Jun-09 5:59 
GeneralRe: Export Excel Formula Pin
ross16642-Jun-09 19:18
ross16642-Jun-09 19:18 
QuestionVB.net: How to update database from datagridview Pin
Roger Rainey2-Jun-09 4:35
Roger Rainey2-Jun-09 4:35 
AnswerRe: VB.net: How to update database from datagridview Pin
Kschuler2-Jun-09 5:45
Kschuler2-Jun-09 5:45 
QuestionRe: VB.net: How to update database from datagridview Pin
JohannNutter22-Jul-09 9:08
JohannNutter22-Jul-09 9:08 
GeneralRe: VB.net: How to update database from datagridview Pin
Kschuler22-Jul-09 9:35
Kschuler22-Jul-09 9:35 
GeneralRe: VB.net: How to update database from datagridview Pin
JohannNutter22-Jul-09 10:26
JohannNutter22-Jul-09 10:26 
Aha!

That did it. I added:

dim cb as new NpgsqlCommandBuilder
cb = New NpgsqlCommandBuilder(m_da)


Where:
m_da is a NpgsqlDataAdapter control in the design view.
m_cmd is a NpgsqlCommand in the design view.
m_ds is a System.Data.Dataset in the design view.

New code is after putting the SQL Select statement into m_cmd, and before m_da.fill(m_ds)

Thanks very much, this is *much* simpler than some sites made it look.

These seems more complicated than it was in VB6. Then, you had a datacontrol and a grid. Load the datacontrol's connection string, set the datasource to the query, 'refresh', all done.

Now I have something that works like the demo I described, but it's probably not a very good example, don't know which of the things I've pulled from the web actually contribute to it working yet.

At the risk of maybe should have clicked "Rant..."

I've only recently started using VB.NET. Started with VB in VB3. Stopped in VB6, because the upgrade wizard crashed on my 300 form, 250 modules/classes application. As of VS2008, upgrade wizard didn't crash, but it's looking like an 80% rewrite; what the upgrade wizard left looks like a transporter accident. data binding (in the converted application) is demolished, usercontrols didn't port for beans, deep heavy sigh.

My impression at this point is that VB has lost it's direction - it used to be going toward 'Simpler', ever easier to build stuff. Now it's trying to compete (and doing well at it) with Java and C++. I spent a decade programming in each of those, and chose VB6 for my own projects, because I like results more than tinkering with strongly typed stuff. I liked the direction VB was going, but it took an abrupt left turn with VB.NET.

Hopefully I'll get used to it. Probably slightly easier than relearning Java.
QuestionVBA and XL - Is this a Viable Function Request? [modified] Pin
Dalek Dave2-Jun-09 4:18
professionalDalek Dave2-Jun-09 4:18 
AnswerRe: VBA and XL - Is this a Viable Function Request? Pin
David Mujica2-Jun-09 4:55
David Mujica2-Jun-09 4:55 
GeneralRe: VBA and XL - Is this a Viable Function Request? Pin
Dalek Dave2-Jun-09 5:02
professionalDalek Dave2-Jun-09 5:02 
GeneralUnderstood Pin
David Mujica2-Jun-09 5:15
David Mujica2-Jun-09 5:15 
GeneralRe: Understood Pin
Dalek Dave2-Jun-09 5:23
professionalDalek Dave2-Jun-09 5:23 
Questionrandom access files .net 2005 Pin
vurdmal2-Jun-09 3:22
vurdmal2-Jun-09 3:22 
AnswerRe: random access files .net 2005 Pin
DidiKunz2-Jun-09 3:34
DidiKunz2-Jun-09 3:34 
GeneralRe: random access files .net 2005 Pin
vurdmal2-Jun-09 4:09
vurdmal2-Jun-09 4:09 
GeneralRe: random access files .net 2005 Pin
Jay Royall2-Jun-09 4:40
Jay Royall2-Jun-09 4:40 
GeneralRe: random access files .net 2005 Pin
vurdmal2-Jun-09 5:10
vurdmal2-Jun-09 5:10 
GeneralRe: random access files .net 2005 Pin
Jay Royall2-Jun-09 5:24
Jay Royall2-Jun-09 5:24 
GeneralRe: random access files .net 2005 Pin
vurdmal2-Jun-09 6:26
vurdmal2-Jun-09 6:26 
GeneralRe: random access files .net 2005 Pin
Jay Royall2-Jun-09 6:32
Jay Royall2-Jun-09 6:32 
Questionhow to embed hardware info programmatically to an executable at install time Pin
JayKhatri2-Jun-09 2:06
JayKhatri2-Jun-09 2:06 
AnswerRe: how to embed hardware info programmatically to an executable at install time Pin
DidiKunz2-Jun-09 3:24
DidiKunz2-Jun-09 3:24 
GeneralRe: how to embed hardware info programmatically to an executable at install time Pin
JayKhatri4-Aug-09 4:36
JayKhatri4-Aug-09 4:36 
GeneralRe: how to embed hardware info programmatically to an executable at install time Pin
DidiKunz7-Aug-09 6:47
DidiKunz7-Aug-09 6:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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