Hazzza Posts - Answer Overflow

Hazzza

Posts Comments

CC#

•Created by Hazzza on 12/3/2024 in #help

SQL gives Missing operator error

14 replies

CC#

•Created by Hazzza on 12/2/2024 in #help

SQL: Trying to obtain all rows that have a primary key inside a inputted table

The code works if the Recipe string replaces the ? in the string. However, as I want to prevent SQL injection the RecipeString isn't treated as SQL so the ' ' either side of each name in RecipeString isn't identified in the SQL string hence returning no values. Hopefully you understand the issue. If anyone has any ideas on how to fix this it would be greatly appriciated. Thanks Code:

C#
string _sSqlString = "SELECT * FROM IngredientRecipe WHERE ProductName IN (?)";

string RecipeString = "";

foreach(string name in Recipes.elements)
{
    if(name != "")
    {
        RecipeString += $"'{name}',";
    }
}
RecipeString = RecipeString.Remove(RecipeString.Length - 1);


string[] Parameters = new string[1];
Parameters[0] = RecipeString;

DataTable result = databaseUtils.ExecuteSqlQuery(_sSqlString, Parameters);

C#
string _sSqlString = "SELECT * FROM IngredientRecipe WHERE ProductName IN (?)";

string RecipeString = "";

foreach(string name in Recipes.elements)
{
    if(name != "")
    {
        RecipeString += $"'{name}',";
    }
}
RecipeString = RecipeString.Remove(RecipeString.Length - 1);


string[] Parameters = new string[1];
Parameters[0] = RecipeString;

DataTable result = databaseUtils.ExecuteSqlQuery(_sSqlString, Parameters);

Example Recipe String is:

'bread','pizza'

'bread','pizza'

8 replies

CC#

•Created by Hazzza on 11/30/2024 in #help

Trying to detect when a checkbox is ticked/unticked in a datagridview checkbox column (WinForms)

Check Box Column Creation Code:

C#
            DataGridViewCheckBoxColumn RestrictIngredientColumn = new DataGridViewCheckBoxColumn();
            RestrictIngredientColumn.ValueType = typeof(bool);
            RestrictIngredientColumn.Width = 50;
            RestrictIngredientColumn.Name = "Restrict";
            RestrictIngredientColumn.HeaderText = "Restrict";
            dgvOptimiseIngredients.Columns.Add(RestrictIngredientColumn);

C#
            DataGridViewCheckBoxColumn RestrictIngredientColumn = new DataGridViewCheckBoxColumn();
            RestrictIngredientColumn.ValueType = typeof(bool);
            RestrictIngredientColumn.Width = 50;
            RestrictIngredientColumn.Name = "Restrict";
            RestrictIngredientColumn.HeaderText = "Restrict";
            dgvOptimiseIngredients.Columns.Add(RestrictIngredientColumn);

Checkbox Click Detection Code: (Column[1] is the column of checkboxes)

C#
private void dgvOptimiseIngredients_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    if (e.ColumnIndex == 1 && e.RowIndex != -1)
    {
        DataGridViewCell cell = dgvOptimiseIngredients[e.ColumnIndex, e.RowIndex];

        MessageBox.Show((Convert.ToBoolean(cell.Value) == true).ToString());
    }
}

C#
private void dgvOptimiseIngredients_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    if (e.ColumnIndex == 1 && e.RowIndex != -1)
    {
        DataGridViewCell cell = dgvOptimiseIngredients[e.ColumnIndex, e.RowIndex];

        MessageBox.Show((Convert.ToBoolean(cell.Value) == true).ToString());
    }
}

Showcase of output: https://gyazo.com/101659e8af97d91876baa8a6cf4d1834 Seems to return true/false very randomly anyone have any idea why this happens. Thanks

7 replies

CC#

•Created by Hazzza on 8/27/2024 in #help

SQL help

22 replies

CC#

•Created by Hazzza on 8/23/2024 in #help

How do I detect if the mouse position is outside a panel and its children in WinForm

8 replies

CC#

•Created by Hazzza on 8/16/2023 in #help

❔ I can't run my C# code in VS code

I get the message 'The .NET Core SDK cannot be located. A valid dotnet installation could not be found. .NET Core debugging will not be enabled. Make sure .NET Core SDK is installed and is on the path

37 replies

Gaming

Programming