For several days I’ve been struggling to display data from the MySql 5.7.21 table in DataSet. When I do not put a condition in the WHERE, it shows me the complete table. I only need part of the table PERSON where the column number is the between wnumber1 and wnumber2.
myConnectionString = pwput;
MySqlConnectionconpara = new MySql.Data.MySqlClient.MySqlConnection();
conpara.ConnectionString = myConnec DataSetionString;
try
{
conpara.Open();
if (conpara.State == ConnectionState.Open)
{
string wnumber1 = wnalog1.ToString();
string wnumber2 = wnalog2.ToString();
string nupita = “SELECT* FROM person WHERE years = wyears AND number >= wnumber1 AND number >= wnumber2 “;
MySqlCommandcmdnal = new MySqlCommand(nupita, conpara);
cmdnal.Parameters.AddWithValue(”@years”,wyears);
MySqlDataAdapte radda = new MySqlDataAdapter(cmdnal);
MySqlCommandBuildercbb = new MySqlCommandBuilder(adda);
DataSet dsd = new DataSet();
adda.Fill(dsd, “person”);
conpara.Close();