error in sentence mysql

[ucaff]

Hello guys

 

I take the data from a Datragrid....

 

" IniRead();
            string constring = "datasource=" + Host.Text + ";port=3306;username=" + User.Text + ";password=" + Passwd.Text;
            MySqlConnection conDataBase = new MySqlConnection(constring);
            string Query = "DELETE " + DataBase.Text + "FROM .t_quest WHERE a_index='" + QuestID.Text + "'";
            MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
            MySqlDataReader myReader;
            try
            {
                conDataBase.Open();
                myReader = cmdDataBase.ExecuteReader();
                MessageBox.Show("(DELETE OK)!");
                while (myReader.Read())
                {
 
 
                }
 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
 
            }
 
            SelectDB();  "
 
........Someone could correct code ?, failed to make it work.
 
I want to delete rows in the db....
 
 
 
from already thank you very much for your help
.

[Wizatek]

if you want to delete a entire row the query would be like this

DELETE FROM t_quest WHERE a_index = 1

 

That would delete quest 1

[ucaff]

In your example "should look like?

 

private void Button3_Click(object sender, EventArgs e)
        {
            IniRead();
            
            string constring = "datasource=" + Host.Text + ";port=3306;username=" + User.Text + ";password=" + Passwd.Text;
            MySqlConnection conDataBase = new MySqlConnection(constring);
            string Query = "DELETE FROM t_quest WHERE a_index ='"+QuestID.Text+"'";
           MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
            MySqlDataReader myReader;
            try
            {
                conDataBase.Open();
                myReader = cmdDataBase.ExecuteReader();
                MessageBox.Show("(DELETE OK)!");
                while (myReader.Read())
                {
 
 
                }
 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
 
            }
 
            SelectDB();
        }.....
 
Not work
 
 
Only a sign that says "no Database Select"     

[Wizatek]

add the database in your connection string, dbname=

or add it in the query, DELETE FROM newproject_data.t_quest WHERE a_index = "+QuestID.Text+";

[ZaTii]

string Query = "DELETE FROM " + DataBase.Text + ".t_quest WHERE a_index = " + QuestID.Text + ";";

 

that should mostly work

 

 

 

 

And for the variables i would load them in a public static string when the first form i loaded. Then u can acces them by Form1."variable" so u dont need 4 textboxes in every Form who are invisible to load the db settings

[ucaff]

Thanks Wizatek and ZaTii, problem solved