multiple sql queries in c#

Question

Hello,

 

I have 5 letters in a database that i want to read and return. so I am using sqlconnection in c#.

I have wrote a small code but i want to know what is missing. Will this work?. Thanks for the help

 

Do i have to use adapter fill??.. I mean does the following code provide the the 5 letters and return them??

 

static DataTable SMSTable(DataTable dtt)
{

using (MySqlConnection connection = new MySqlConnection("server=10.2.151.147;port=3306;database=MR_61_MSDB"))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
string sql1 = "Select intMobileID, strTasten_Name,dblX_Wert,dblY_Wert,dblZ_Wert from [Tastatur_Daten] Where intMobileID=1144 AND strTasten_Name=" + "H";
string sql2 = "Select intMobileID, strTasten_Name,dblX_Wert,dblY_Wert,dblZ_Wert from [Tastatur_Daten] Where intMobileID=1144 AND strTasten_Name=" + "A";
string sql3 = "Select intMobileID, strTasten_Name,dblX_Wert,dblY_Wert,dblZ_Wert from [Tastatur_Daten] Where intMobileID=1144 AND strTasten_Name=" + "L";
string sql4 = "Select intMobileID, strTasten_Name,dblX_Wert,dblY_Wert,dblZ_Wert from [Tastatur_Daten] Where intMobileID=1144 AND strTasten_Name=" + "L";
string sql5 = "Select intMobileID, strTasten_Name,dblX_Wert,dblY_Wert,dblZ_Wert from [Tastatur_Daten] Where intMobileID=1144 AND strTasten_Name=" + "O";

using (MySqlCommand command = new MySqlCommand(sql1, connection))
{

using (MySqlDataReader reader = command.ExecuteReader())
{

}

}

using (MySqlCommand command = new MySqlCommand(sql2, connection))
{


using (MySqlDataReader reader = command.ExecuteReader())
{

}

}


using (MySqlCommand command = new MySqlCommand(sql3, connection))
{

using (MySqlDataReader reader = command.ExecuteReader())
{

}

}

using (MySqlCommand command = new MySqlCommand(sql4, connection))
{

using (MySqlDataReader reader = command.ExecuteReader())
{

}

}
using (MySqlCommand command = new MySqlCommand(sql5, connection))
{

using (MySqlDataReader reader = command.ExecuteReader())
{

}

}
}
else
{
MessageBox.Show("Could not connect to database!");
}

return (dtt);
}
}