[C# - MySql] LC Warehouse!

[Nikolee]

t_stash is right for wearehouse, the best is if someone has already something in wearehouse and u insert it in the right t_stash where he has already the other item but not sure if this also works, the location of t_stash should be where t_character is

 

Help me out, i will need to select all from all stash the user_id ?

 

How i can include this in my Code i really dont understand it how to return the selected mysql result in a variable.

 

string user_id = textBox35.Text;
string sqlHelm = @"INSERT INTO t_stash00 (a_user_idx, a_item_idx, a_serial, a_count, a_used, a_plus)
VALUES ('"+user_id+"', '"+TitanHelm+"', 'MNIKSHJF54', '1', '-1', '25' )";

MySqlConnection con;
MySqlConnectionStringBuilder csb = new MySqlConnectionStringBuilder();
csb.Server = Server;
csb.UserID = user;
csb.Database = _Chardb;
csb.Password = pw;
con = new MySqlConnection(csb.ConnectionString);
MySqlConnection connection = new MySqlConnection(csb.ConnectionString);
connection.Open();

MySqlCommand insertBann = new MySqlCommand(sqlHelm, connection);
int i = insertBann.ExecuteNonQuery();