Compare data with the SQLite database

Ram Prasad

Compare data with the SQLite database, display the output if data exist in database and insert in database if does not exist in database

I am getting a string of words as output in `returnValue` which I want to compare to a SQLite database. If the value of `returnValue` exists and starts with the letter 'k' in the database then output gets displayed. If `returnValue` starts with the letter 'k' and does not exist in database then it gets added into the database. Any other string starting with any other letter does not do anything.

For example, assuming 'Kevin' already exists in the database, if the output in `returnValue` is Kevin then Kevin must show in `Console.Write`. If output in `returnValue` is 'Kelly' (which does not exist in the database) then it gets added into the database. If the output of `returnValue` is 'John', nothing happens.

I tried the following code, but it is not working.

string returnValue = string.Join("", dataResult.ToArray());
Database databaseObject = new Database();
databaseObject.OpenConnection();
SQLiteCommand cmd = new SQLiteCommand();
SQLiteDataReader dataReader;
if (returnValue.StartsWith('k'))
{
string value = cmd.ExecuteScalar() as string;
if (returnValue.Equals(value))
{
databaseObject.OpenConnection();
using (cmd = new SQLiteCommand("SELECT * FROM k", databaseObject.myConnection))
{
dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
Console.Write(Data);
}
}
}
else
{
query = "INSERT INTO k ('Data') VALUES (@Data)";
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Data", returnValue);
}
databaseObject.CloseConnection();
}
else
{
return;
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ram Prasad5y ago
@Sachin - Thanks for your prompt response again.
New modification is still giving the same issue
+2
Sachin Singh5y ago
might be a case issue so test with
static void Main(string[] args)
            {
                string returnValue = string.Join("", dataResult.ToArray());
                Database databaseObject = new Database();

                using (SQLiteConnection con = new SQLiteConnection(databaseObject.myConnection))
              {
                  SQLiteCommand cmd = new SQLiteCommand("select * from k where Data like '%K'", con);
                  con.Open();
                  var rdr = cmd.ExecuteReader();
                  while (rdr.Read())
                  {
                      if (Convert.ToString(rdr["Data"]).ToLower() == returnValue.ToLower())
                      {
                          Console.WriteLine(Convert.ToString(rdr["Data"]));
                      }
                     else
                     {
                         SQLiteCommand cmd1 = new SQLiteCommand("INSERT INTO k ('Data') VALUES (@Data)", con);
                         cmd1.Parameters.AddWithValue("@Data", returnValue);
                         cmd1.ExecuteNonQuery();
                     }
                  }

              }

            }
            }
+1
Ram Prasad5y ago
@Sachin - Thanks for taking time to answer the question.

This code is working fine when data is not available in database. However it is not getting into the loop of
if (Convert.ToString(rdr["Data"]) == returnValue)
{
    Console.WriteLine(Convert.ToString(rdr["Data"]));
}
when data is in there.

Thanks
+2
Sachin Singh5y ago
proceed as shown below
static void Main(string[] args)
            {
                string returnValue = string.Join("", dataResult.ToArray());
                Database databaseObject = new Database();

                using (SQLiteConnection con = new SQLiteConnection(databaseObject.myConnection))
              {
                  SQLiteCommand cmd = new SQLiteCommand("select * from k where Data like '%K'", con);
                  con.Open();
                  var rdr = cmd.ExecuteReader();
                  while (rdr.Read())
                  {
                      if (Convert.ToString(rdr["Data"]) == returnValue)
                      {
                          Console.WriteLine(Convert.ToString(rdr["Data"]));
                      }
                     else
                     {
                         SQLiteCommand cmd1 = new SQLiteCommand("INSERT INTO k ('Data') VALUES (@Data)", con);
                         cmd1.Parameters.AddWithValue("@Data", returnValue);
                         cmd1.ExecuteNonQuery();
                     }
                  }

              }

            }
            }
+2