PDA

Click to See Complete Forum and Search --> : Write inputs to SQL/ODBC


podman99
Aug 21st, 2007, 06:25 PM
Not sure if there is an easy answer but ill see if i can word the question correctly and hopefully i will get the answer i need.

I am designing a simple application (1 window) to write data to a RSS feed ... stored in a MySQL database.

The page consists of 3 boxes

Title
Content
Date

ID is generated automaticly by the SQL server upon insert.

I have a submit button on the page...

currently the code i have is

Code Snippet

private void button1_Click(object sender, EventArgs e)
{

}

This is as far as my knowledge goes...

I wish to simply post (php programmer sorry) the 3 boxes to the SQL server for saving, I have created a DSN to connect to the database but I have no idea how useful that actually is as i have no clue how to write the data to the database.

I would assume that when I click the submit button the code within the { }'s is executed to save the data to the database... what do I put in the { }'s to make this all work... once this works I will prob arrange to start making a sql viewer/editor and increate its editing potential but to start with i just want it saving to the database....

Nice (simple) one for you.
59171
Thanks

Keith

ComputerJy
Aug 22nd, 2007, 04:00 PM
If you take a look at the MySQL website you'll find "MySQL.VisualStudio" add-in so you can easily use MySQL from VS

I also recommend reading some books or going through some tutorials to help you learn C# as I understand you are new to this.

We here would love to help you with your problems but as long as you're not asking us to do your stuff ;)

Cheers, and Welcome to the .NET hell