C# Discussion Boards - CodeProject

First Prev Next

Re: Cannot Update Non Local MYSQL Table using C#.NET and ODBC

led mike31-Jul-07 4:17

led mike

31-Jul-07 4:17

][cecu3e wrote:
I hope that there is someone out there that can work out what is going on with my application!

I found what is wrong

][cecu3e wrote:
I am a n00b trying to use ODBC drivers to update a remote MySQL database, and as such i have been trying to piece code i have found on the internet to get it working.

That's wrong on so many levels

Re: Cannot Update Non Local MYSQL Table using C#.NET and ODBC

][cecu3e31-Jul-07 4:27

][cecu3e

31-Jul-07 4:27

lmao, yeh i probably sound like the dumbest man alive, its all been going well until this.. ive almost no experience with this so my descriptive terminoligy is probably way off. im just tryin to get that update command to work....

lol, also when i say im jsut piecing other peoples code together im not doing it in a literal sense, im using other FAQs to write this, attempting to understand this odbc connection stuff Smile | :)

soz..can u shed any light?

Re: Cannot Update Non Local MYSQL Table using C#.NET and ODBC

martin_hughes31-Jul-07 4:56

martin_hughes

31-Jul-07 4:56

Try:

DataSET.AcceptChanges();

Also, "Bob" is a much nicer name for a database table; surnames are reserved for school and the military Smile | :)

"It was the day before today.... I remember it like it was yesterday."

-Moleman

Re: Cannot Update Non Local MYSQL Table using C#.NET and ODBC [modified]

][cecu3e31-Jul-07 5:06

][cecu3e

31-Jul-07 5:06

hehe, true and thnx for the reply, unfortunatly it doesnt make the table update Frown | :(

i ammended the code to (i have placed it after the mapping too, jsut in case..):
lol, also changed the table name to test!

DataSET.AcceptChanges();<br />
DataAdapter.TableMappings.Add("TableData", "Test");<br />
DataAdapter.Update(DataSET, "TableData");<br />
DataAdapter.TableMappings.RemoveAt("TableData");

But it still doesnt update the mysql table Frown | :(

im am very confused, i think maybe my DataAdapter.Update() line may be wrong

many thanx again, i think i need your added line aswell as the code fix!

Can anyone help, im going insane with this one :P

-- modified at 12:20 Tuesday 31st July, 2007

C implemented Linear Equation Solver?

sukatoa31-Jul-07 3:38

sukatoa

31-Jul-07 3:38

Does anyone knows the simple yet powerful algorithm in solving Systems of linear equations?

Thanks!!

Re: C implemented Linear Equation Solver?

Luc Pattyn31-Jul-07 4:01

Luc Pattyn

31-Jul-07 4:01

that is "LU decomposition" well known to Google and the rest of the world.

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

c# Interop

Amit_bad31-Jul-07 3:22

Amit_bad

31-Jul-07 3:22

How can i expose the public enum created in c# form to the vb6 application?

-Amit

Re: c# Interop

Justin Perez31-Jul-07 5:01

Justin Perez

31-Jul-07 5:01

I don't believe you can expose the C# form to the v6 application, but you can expose that enum to a vb6 by creating a dll and adding a reference to it.

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

Re: c# Interop

Brady Kelly31-Jul-07 6:02

Brady Kelly

31-Jul-07 6:02

There is a new toolkit from Microsoft for exposing .NET UI stuff to VB6 apps, but I can't remember what it is called.

Problem with office XP interop assemblies

Wjousts31-Jul-07 3:11

Wjousts

31-Jul-07 3:11

I'm trying to write an application that will allow an external device to be synchronized with a PowerPoint presentation. So I wrote a very simple Windows Forms application that will load a PowerPoint presentation and get a list of the slides. It then allows the user to hook each slide to an event on the external device with the objective being that when that slide appears, the external device should do a certain action. I'm using the office XP primary interop assemblies from Microsoft and all of this works fine up to this point.

Now I have a button that starts the actual presentation. My program will handle the SlideShowNextSlide, SlideShowEnd and PresentationClose events (from PowerPoint) and everything works great. My handler is triggered when the slide changes and based on which slide is displayed, it makes the external device do something.

The problem occurs after the presentation ends and I then try and restart it. At this point when I get to the SlideShowSettings.Run() method I get a COMException with the message "Presentation (unknown member) : Object does not exist."

Does anybody have any idea what the problem here might be? I'm assuming that something needs to be cleaned up on exit, but I've closed the presentation with the Close() method and even tried reinitializing a whole new PowerPoint.Application and PowerPoint.Presentation, but it just doesn't work.

Re: Problem with office XP interop assemblies

Luc Pattyn31-Jul-07 3:41

Luc Pattyn

31-Jul-07 3:41

Hi,

I never do these things, but IIRC I read something like that on CodeProject
a couple of months ago.
I think this has been a bug, and some patch exists to solve it.

So I suggest you search CP for it (using the looking glass), or else just Google it.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Problem with office XP interop assemblies

Wjousts31-Jul-07 10:30

Wjousts

31-Jul-07 10:30

Thanks but I've struck out on Google. I'm getting nothing.

how to find page controls

Farhan Ali31-Jul-07 3:10

Farhan Ali

31-Jul-07 3:10

Hi:

i am creating controls on a webpage dynamically and then want to get all page controls using "page.controls.count" but it is not getting page controls

anybody have any idea??

thanx

Re: how to find page controls

Colin Angus Mackay31-Jul-07 3:26

Colin Angus Mackay

31-Jul-07 3:26

When you created your dynamic controls, did you add the controls to the Page.Controls collection?

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

My website

Re: how to find page controls

Farhan Ali31-Jul-07 3:51

Farhan Ali

31-Jul-07 3:51

thanx for ur reply
yes i added it to the page controls.

Re: how to find page controls

Sandeep Akhare31-Jul-07 4:52

Sandeep Akhare

31-Jul-07 4:52

Might be the controls are not getting added to the page
Where are you adding the controls to the page ?
First check by debugging the application

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Re: how to find page controls

Malcolm Smart31-Jul-07 5:05

Malcolm Smart

31-Jul-07 5:05

Are you counting the controls on postback? On a postback, you have to create and add all the controls again.

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

Capturing Mouse Pointer?

Janu_M31-Jul-07 2:10

Janu_M

31-Jul-07 2:10

Is there any mechanism to take the screenshot of the desktop along with the mouse pointer?

Here what i need is an image of the desktop in which it contains the mouse pointer.

Thanks in Advance
Ramu Medida.

Re: Capturing Mouse Pointer?

snorkie31-Jul-07 3:34

snorkie

31-Jul-07 3:34

Ramu,

Have you tried Googling for that? If you did, you might have come with http://www.codeproject.com/csharp/DesktopCaptureWithMouse.asp, which would show you how to do it...

Hogan

Thanks you very much.

Janu_M31-Jul-07 19:40

Janu_M

31-Jul-07 19:40

Thank you very much.

Thanks and regards
Ramu

openGL

Noharyiasa31-Jul-07 1:58

Noharyiasa

31-Jul-07 1:58

Where can I find the GLUT and GLAUX Libraries in c# ?

Noha

Re: openGL

led mike31-Jul-07 4:33

led mike

31-Jul-07 4:33

Noharyiasa wrote:
Where can I find the GLUT and GLAUX Libraries

You mean other than on the internet?

Getting the value of a column of selected row in DataGridView

VijayaRam31-Jul-07 1:36

VijayaRam

31-Jul-07 1:36

Hi,
I have problem in retrieving the value of a column of selected row in DataGridView control using c#.net 2005

VijayaRam

Re: Getting the value of a column of selected row in DataGridView

Herman<T>.Instance31-Jul-07 2:53

Herman<T>.Instance

31-Jul-07 2:53

easy one

<br />
public String returnGridViewCellValue(GridViewRow row, String fieldName)<br />
    {<br />
        String result = String.Empty;<br />
<br />
        try<br />
        {<br />
            result = DataBinder.Eval(row.DataItem, fieldName).ToString();<br />
        }<br />
        catch<br />
        {<br />
            result = String.Empty; // or result = fieldName + " not found";<br />
        }<br />
<br />
        return result;<br />
    }<br />

Re: Getting the value of a column of selected row in DataGridView

il_masacratore31-Jul-07 2:57

il_masacratore

31-Jul-07 2:57

Here is an example(getting the value of a cell of the first row selected ):

<br />
DatagridView oGrid;<br />
<br />
//If you know the ordinal of the column<br />
if( oGrid.SelectedRows.Count>0 )<br />
{<br />
    object oValue = oGrid.SelectedRows[0].Cells[0].Value;<br />
}<br />
<br />
<br />
//If you know the name of the column<br />
if( oGrid.SelectedRows.Count>0 )<br />
{<br />
    object oValue = oGrid.SelectedRows[0].Cells["colName"].Value;<br />
}<br />
<br />
//Then you can try to Convert the object to a different type.

Visit my blog at http://dotnetforeveryone.blogspot.com/

Last Visit: 31-Dec-99 18:00 Last Update: 20-May-24 6:25

Refresh

ᐊ Prev 1...8819 8820 8821 882288238824 8825 8826 8827 8828 Next ᐅ

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