gistfile1.txt

  private int RemoveLog(Logbook parameters) // radera inlägg
        {
            try
            {
                int removeResult;
                string connection = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Databas.mdf;Integrated Security=True;Connect Timeout=30";
                SqlConnection con = new SqlConnection();
                using (SqlConnection conn = new SqlConnection(connection))
                {
                    conn.Open();
                    string sqlQuery = string.Format("DELETE FROM lb WHERE {0} like @search", parameters.GetComboBox());
                    SqlDataAdapter sda = new SqlDataAdapter(sqlQuery, conn);
                    sda.SelectCommand.Parameters.AddWithValue("@search", "%" + parameters.GetSearchWord());
                    DataTable dt = new DataTable();
                    sda.Fill(dt); 
                    dataGridView2.DataSource = dt; 
                    removeResult = dataGridView2.RowCount;
                    return removeResult;
                }
            }