Okay I retraced my steps and everything and remembered I had changed my query and since then I started having the issue. Originally this was the function which populated the comboBox above with values:
void fillCari()
{
try
{
string connectionString = "Data Source=CMDLAP126;Initial Catalog=Carimed_Inventory;User ID = sa; Password = 123456;";
SqlConnection con2 = new SqlConnection(connectionString);
con2.Open();
string query = "SELECT DISTINCT Item_Description FROM dbo.Carimed";
SqlCommand cmd2 = new SqlCommand(query, con2);
SqlDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
string cari_des = dr2.GetString(dr2.GetOrdinal("Item_Description"));
suggestComboBox1.Items.Add(cari_des);
suggestComboBox1.Text.Trim();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
This particular line was the issue:
string query = "SELECT DISTINCT Item_Description FROM dbo.Carimed";
Turns out it has something to do with "DISTINCT." Am not entirely sure why removing it and changing it to this solved my issue:
string query = "SELECT Item_Description FROM dbo.Carimed";
I had no idea that my query would have been the issue, that's why I left it out from my question. Thanks for all who helped.