[randomsai]

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {}
              private void hello(object sender,System.EventArgs e)
            {
               
                MySql.Data.MySqlClient.MySqlConnection MyCon = new MySql.Data.MySqlClient.MySqlConnection("server=localhost; Database = textinfo; user id=root; password=random;");
                MyCon.Open();
                MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand("INSERT INTO texting (phone_no) VALUES('666666')", MyCon);
                command.ExecuteNonQuery();
                MyCon.Close();
              

        }
    }
}

*** MOD EDIT: Added code tags. Please ***

This post has been edited by JackOfAllTrades: 30 January 2010 - 11:20 PM

[FlashM]

Well, there seems nothing is wrong with your code. Do you get any exception thrown? It might be something wth you database. Could you provide some more info about your database schema.

[ThatThatGuy]

Your code is perfectly right although i doubt that you are not putting your password... **** like you showed us in the code.....

Also i doubt that the phone_no field is numeric.... and your're putting a data of type string..


debug to see your code....


Click the below link if my reply helped you

[TravisP]

It could be your internal security settings, try running VS as administrator (right click and go "open as"). Then see if the connection will work.

[randomsai]

no the password is a string, sorry bout that.
well just to text i set the value of the phone_no field to varchar, so i think that the string input into the table heading would have no effect.

i was watching the code and it seemed that this line stopped the debugging when stepped into:
static void Main(string[] args)
{}


what should i do, not to familiar with c#, better at php

also, the purpose of this is just to text that i can send values to the database through c#, as most of my project is php. i am using C# for the texting aspect of it. where a text message is simulated and the phone no and the message sent is stored in the database, just scraping the surface.


thanks to all who responded

[Sergio Tapia]

Since you are using a C# console application your code must be inside the Main tag.

Write in all function invocations inside of the Main function.

Try doing this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            MySql.Data.MySqlClient.MySqlConnection MyCon = new MySql.Data.MySqlClient.MySqlConnection("server=localhost; Database = textinfo; user id=root; password=random;");
            MyCon.Open();
            MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand("INSERT INTO texting (phone_no) VALUES('test2')", MyCon);
            command.ExecuteNonQuery();
            MyCon.Close();
        }
    }
}

This post has been edited by stapia.gutierrez: 30 January 2010 - 11:23 PM

[randomsai]

i got it to work

This post has been edited by randomsai: 30 January 2010 - 11:24 PM

[JackOfAllTrades]

Code is "perfectly right," "nothing is wrong"? Can I have some of what you guys were having?

Look at the code again (note I added code tags). There's a Main function...then NOTHING INSIDE IT!!!

You must do something inside your Main function for the program to actually...well, do something.

[randomsai]

i did exactly that stapia.gutierrez, thanks

[Sergio Tapia]

No problem, glad I could help.