Help Creating and Modfying Data Base in C# Visual Studio 2010

[King_Jay16]

Hey guys I am creating an inventory program in C# and I need to store the data and be able to add/delete/update the database. How do I go about doing this? I am using Visual Studio 2010

[mobile_fan_2k5]

Are you using SQL server 2008 r2 or MYSQL C# Connector..

Personally I like using MYSQL C# connector because its light weight and faster than SQL server 2008..

Download connector from here
http://www.mysql.com/downloads/connector/net/


Ohhh and its free BTW.

CRUD on MYSQL connector latest version

string connectionString ="server=localhost;user=root;database=YourDataBase ;port=3306;password=;";//connection string
MySqlConnection conn = new MySqlConnection();//MYSQL connection function



Insert/Add
conn = new MySqlConnection(connectionString);//passing connection string into the connection function
conn.Open();
MySqlCommand cmd = conn.CreateCommand();//create a command function that utilises the connection string to execute commands
cmd.CommandText = "INSERT INTO yourTable VALUES (@fname,@lname)";//insert firstname and lastname into your table
cmd.Prepare();

//---------------
cmd.Parameters["@fname"].Value = firstname.Text;//example the string is passed from textbox
cmd.Parameters["@lname"].Value = lastname.Text;//example the string is passed from textbox
//---------------
cmd.ExecuteNonQuery();//Command is executed. hence its written to database
conn.Close();//close connection

Update

conn = new MySqlConnection(connectionString);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE yourTable set price=@NewPrice WHERE Console =@conSoleName";
cmd.Prepare();
cmd.Parameters["@NewPrice"].Value = "25000";
cmd.Parameters["@conSoleName"].Value = "PSP";
cmd.ExecuteNonQuery();
conn.Close();

Delete

conn = new MySqlConnection(connectionString);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = "Delete * from yourTable";
cmd.Prepare();
cmd.ExecuteNonQuery();
conn.Close();

Here is the documentation it will help you out alot..... http://dev.mysql.com/doc/refman/5.5/...ector-net.html
That's the latest...

------------------------------------------------------
Here are some example.. but they are using the older 1.0 version. Its basically the same. But here anyway
http://bitdaddys.com/MySQL-ConnectorNet.html

[King_Jay16]

Thanks will look into it right now. I was thinking about using and linking an Access Database file but this seems a lot easier.

[mobile_fan_2k5]

its not just easier its more practical..You can build scalable apps with it. Its not as powerful as SQL server 2008 r2 but it beats it in terms of speed.

[King_Jay16]

Thanks, I am reading into it now...

This is what I am planning to do... I am creating an Inventory program for three departments. For each I am recording the following devices Computer, Keyboard, Mouse, Printers with the following details Device Name, Serial and Quantity and technician who added or removed the device. All from within a GUI. so trying to get my bearings on this all..

[pezz]

I know how to do this with a cookie. learning how to do with database as we speak.

[King_Jay16]

I know how to do this with a cookie. learning how to do with database as we speak.

Cool, I will be doing my database course for my IT BS next semester... should be interesting... lol...

mind giving me some tips and help with this lil project tho?